Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    ASP




ASP CHECKBOX: How To Send True/false To DB


Been having problems sending a true/false value to my database from a checkbox/radio group. Using checkboxes.... Code:




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
True Or False In A Yes/no Field
in one of my sql queries on an asp page i am trying to select some data from an access table. The problem is the search criteria is based on a yes/no field. I need to find any record where the value is null or true. So far i have this:

if ISNULL(orseof("Returned")) OR orseof("Returned") = True then

the ISNULL section works it is just the = true bit that doesn't.

True Or False Quiz
i m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database

I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes

Random True/false Quiz
Here's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP).

I have 17 different html pages. quiz1.html > quiz17.html.

The user says take a quiz and it pops up a window holding quiz1.html.

Within each page is a true/false question. Upon answering the user is told:

1. what they answered.
2. if that is correct or not
3. a corresponding sentence about the question.
4. an image the corresponds to if they were corect or not.

(This is all done in javascript).

----

However, now I want to take these 17 questions and randomize them and choose 6 questions.

For example:

The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17.

I'd like to do this in ASP.

Display Ms Access True/false Fields As Check Marks On ASP Page
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.

Tick Checkbox If Database Is True
in my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out? Code:

Xml Variable FALSE
I'm not too familier with XML, this is probably a simple question but in my script I use this:

...
xml.Open "GET", url, FALSE
xml.Send()
Response.write xml.Responsetext
...

now, this is probably a very simple thing and I'm blind or something but how do I make it do something besides just quitting if it's false???

IsNumeric() = False
I wrote a stored procedure to INSERT a new row in the database. It returns the new ID via @@IDENTITY. This value is read by my ASP and stored in variable intNewID. The value displays fine via <%= intNewID %>. But when I tested it using IsNumeric(intNewID), it returned False.

If Exist=false
I need a way to check if a certain folder exists. If it doesn't exist i want to create it. How can i do this?

SendEmail Returning False
I have two forms, each with its own processor ASP. Both use the SendEmail.asp mailer program. One form works, the other fails at the SendEmail call, and I cannot figure out why.

The form code of the form returning no mail sent: ....

False User/password
I lethe user enter a username and password and through a SQL-statement I
check if there is a corresponding password in the database (Yes I know,
not very good security but for the moment it's enough). Problem is that
when I enter a false user/password, I want the code to redirect to
another .asp-page which states the user is not valid. Problem lies
within the statement "if rsMOS is nothing then response.redirect
"VWGloginAgain.asp" ". Somehow, the code does not return 'nothing' but
something else.
How do I figure out what it returns? Or, how can I make sure it returns
a 'nothing' when no such password is found in the database?
Here's my code snippet ('usr' and 'ww' are defined earlier; furthermore
I've left out the redirects, but I've tested the first
if-then-conditions and they work fine... Just the 'nothing' does not
work):

False 'ASP 0113' Error Message
Getting a false error message listed below. The error occurs only when using an ALIAS instead of actual computername i.e. the server name is INTRANET01 but the alias is HELPDESK.

error 'ASP 0113'

Script timed out

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeOut or by changing the value in the IIS administration tools.

SPLIT Either BOF Or EOF Is True?
I'm pretty new at this so if someone could tell me what I need to do to the foloowing code I would really appreciate it!

strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" ...

True Answer Re Timeouts
I've been using text files for Tab-Delimited/ADO/ASP sites so that users can
update and display their products lists through my system with relative
ease.

Only problem is that for the last few months or so, this system has been
generating loads of timeouts. ISP has said that I should be looking to
upgrade my system, as it is the mechanics of it that are creaking under the
strain. My queries are:

a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less?

b) If I convert the system to use 1 Access DB rather than 50-odd
tab-delimited text files will this REALLY perform better in relation to
timeouts?

To give you some idea of the problems, the site can viewed by going to
www.bardwells.co.uk and clicking the Product List link.

I just can't understand it because the pages on the whole are very lean and
zippy (esp. ADSL), but its these exact same Broadband users who seem to have
more trouble with timeouts than dial-up ones.

True Image Thumbnails
How can my ASP serverscript read a JPG file and create a small thumbnail
image? I don't mean simple resizing, but true resizing so that the image
actually gets smaller in size. Is this possible without the use of a 3rd
party component?Does anyone have a code example for me?

Subscript Out Of Range: 'True'
I'm getting this error:

Microsoft VBScript runtime error '800a0009'

Subscript out of range: 'True'

/Featured.asp, line 28

on this code:

Isnumeric Return True
why does isnumeric return true?

a=""
if isnumeric(a) then
response.write("test")
end if

empty isnt numerical is it?

Evaluate RegExp To True.
How do I evaluate a RegExp to true or false? Like I want to know if the value is correct or not using this snippet. Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted.
I am struggling with opening a database and reading data from it via SQL. Please tell me what is wrong with this code. I am trying to open up different tables and get information from them and put it on the one page. Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
ADODB.Field (0x800A0BCD)

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

This is the error I recieve when trying to run my site. I know why. I am passing a non existed URL Parameter. However I would like to recieve a MsgBox that says that such record doesn't exist. Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
It says I have 8 records but is not displaying them.

Error:
ADODB.Fielderror '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /deleteevent.asp, line 33 Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
I have several pages I set up in my web site and I am having trouble with two of them - search and results. The stat_search uses a form which seems to work right and when I test the recordset on the stat_results page and enter a value it returns the right results.

When a value is entered from the stat_search page the results page displays the records with the right value and the Records _ of _ indicates the right number of records but when I use the Next or Last arrows to move to the next record I receive the ADODB.Field error. Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
Howcome it doesn't work?

ADODB.Fielderror '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /gemetria/kjvresp3.asp, line 0

It was working before!!! Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted.
This is the error I'm getting:

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/ism5315/readtrends.asp, line 46

What I'm trying to do is select the records from my table that match the sensor and gauge the user selects. I have time fields that are optional, and I'm trying to get the page to work if the user selects no time frame first.

Of course, there can be mutliple records for the gauge and sensors, so I created a loop that should run thru and select them all. But I am getting the above error. But I know I am getting into the loop because I have included a response.write sql to verify I am selecting the correct objects. Code:

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
Exact error message:

ADODB.Fielderror '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admindemo/profiles_browse.asp, line 0

Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
Howcome it doesn't work?

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/gemetria/kjvresp3.asp, line 0

It was working before!

ASP VBScript Fails When Response.buffer = True
I have a big asp file that has an error under certain conditions -- totally
repeatable. However, it only fails when I set response.buffer = True at the
top. WHen I set it False in order to debug it, it works every time! I even
set it to True, but did a .Flush just before the error, and the error won't
happen.

It only happens when response.buffer is True and no .response.flush is issued.

The error is a string variable turns-up empty and crashes a function
requiring a date. I could test for this before the line where it crashes,
but where did my data go? Why is the buffer affecting it?

Get Data From Form, Send To A Html File And Send A Mail
i am trying harder to mix this 2 solutions... but without success... the below on seen to be grabing a template and replace the data with the values posted in a form Code:

Document.formulier.submit On Return False "page Cannot Be Displayed"
I'm having in my asp page a java script with function. It checks the form, see the code below:

When I click on my submit button is has onClick="invalid();"
If a field is indeed not filled in, it gives the alert message.

My problem is, when the alert apears and I click on OK it gives an errorpage, I won't that it returns to the form. Code:

ObjWshell.Run "%COMSPEC% /C Kill Iexplore.exe", 0, TRUE ???
what is wrong in the code bellow to kill iexplore.exe process after
processing my page??

'»»Before comes routines to access data base and to send email.

Set objWshell = Server.CreateObject("WScript.Shell")
objWshell.Run "%COMSPEC% /C kill iexplore.exe", 0, TRUE

Checkbox Value?
is there a way of having a dropdownlist and a text field with a checkbox so that you can check a box and have the vaule assigned from a option selct list or check another box and have the value assigned from a textfield?

Asp And Checkbox
I would like to make an interaction with a database using ADO and SQL. I would like to display some parts of the database using checkboxes to choose the different parts. But I don't know how to build the SQL command in fuction of which checkbox is checked.

Checkbox
I am new born kid of this block and want some help from my seniours.
I am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table).
I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve.
On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table.
Now my problems is...
1) how can I know which checkbox user selected ?
2) Are there someway to get the value of checkbox without making form ?

Checkbox
i have a update page the pulles date form a database. and two the these
fields have Y or N in them and if the RS("Value") = Y the i want the
checkbox to be checked how do i do this??

Checkbox
I know this is gonna sound silly but when I submit a form with a checkbox
html control "mychk", how can I see if that is checked or not ?

I have tried :

if request.form("mychk") = true then
' code
else
' code
end if

But it always executes the code in the else statement meaning it is never
true despite the fact I have given the checkbox a value of true.

Checkbox Value
how to write sql to give value true in db?

If Else Using Checkbox Value
I have a checkbox which is used to determine whether or not the user wants to display a map of their business with their listing the value of which is being written into a database.

When I am outputting the listings I am just trying to use a simple if else statement

i.e. If(ShowMap = true)Then
Response.Write("<td>Show Map</td>")
Else
Response.Write("<td>No Map</td>")
End If

Problem is I know the database contains different values for ShowMap i.e. some true, some false. Yet when I use this code, No Map is output for all records.

Checkbox
I populate my checkboxes in a table written in asp. Each checkbox has the same value but a different name. I want to say for checkbox in the asp table, call a procedure that will do the changes. Code:

Using A Checkbox
I have a profile search where people can search through our dating profiles. I want to add a checkbox which when checked filters out those records where the recordfield pictures is empty.

I have problems figuring out what the checked value of the checkbox should be and how to use the information from the checkbox in the searchresults page to build the record set. For understanding, if a user does not have a picture the picture field is empty.

Value In Checkbox
I am trying to display the value of a true/false value in my table through the use of the following:

<input type=checkbox name=FieldLabCheck value=" &
objRecordset("FieldLaborSuper") & "></input>

it doesn't work though.... what am I doing wrong.

Value Of Checkbox
I have a checkbox in a form from which I want to collect the value.
<input type="checkbox" name="Question11a" value="a">

In the asp page that is called on submit of the form, I declare a variable, iQuestion11a, and request the value of this checkbox:
iQuestion11a = Request("Question11a")

When I print out the value to an html page <% response.write(iQuestion11a) %> it is empty.

Checkbox Set To OFF
When using checkboxes on a form, if you uncheck them, the unchecked name/value pair in the Request.Form collection doesn't show up. It only shows when the checkbox is set to ON. Is this correct? What's the workaround if it is?

Checkbox With Textbox
anyone have any idea how to do checkbox with textbox beside.

Checkbox Disable
if i want to display many records from database with each record has one checkbox.. if the record do not meet the constraints.. e.g. if supplier name has no email address.. then that checkbox will be disabled....the rest will appear.. i tried the disabled/// but no result.

How To Update Checkbox !!
I have problem in updating checkbox (true-false) using SQL statement.

Checkbox And Javascript
I have a JavaScript function that gets a boolean value and checks or unchecks a checkbox based on the boolean value.

function initialize_p(thevalue) {
if (thevalue) {
document.form.cbx1.checked=true;

}
else {
document.form.cbx1.checked=false;

}

In the example, I want form.cbx1 to be checked if 'thevalue' is true and unchecked if 'thevalue' is false. However, it's not working as desired. I used the alert stmt to see what it does:

- When 'thevalue' is true, it goes to the 1st part of the if stmt and checks the checkbox.
- When 'thevalue' is false, it still goes to the 1st part of the if stmt and checks the checkbox

It looks it never goes to the else!! I used alert stmts to see where it goes if the 'thevalue' is false (used alert to show me the value of 'thevalue' and where it is in the if stmt). I don't understand what's going on. Can anybody see what is wrong with the function?

Checkbox And Two Variables
I need to assciate two varaibles dyanmically in value of the checkbox.
How can I do that? For ex., I have the following:

<td><input type='checkbox' name='chk<%=i%>' value='<%=rs("Field1")%>'>

Above, I need to add second fields value from database in value
property of the checkbox.

Checkbox Vs Text Box
I have a form with multiple records.

My intention is to have the user click a checkbox for each product he wants.
Then submit the form placing multiple items in his cart.

If I use a text box like the following and enter a 1 for each product,
submit, no problem.

The user gets the products he wants.
<input name="qty" type="text" value="0">

However, if I use the following checkbox code, and assuming the user checks
4 products half way down the page, he will get the first 4 products in the
recordset. If he clicks 1 checkbox, he will always get the first product,
not the product he chose. <input name="qty" type="checkbox" value="1">

What I have found is when I submit the form to a blank test page using
checkoxes or text boxes, there's a considerable difference. The text boxes
deliver a comma delimination for each occurance. The checkboxes only offer
comma delimination for each checkbox that is selected. At this point, I'm
assuming that's the difference between the two and it cannot be changed
through HTML.

Checkbox Question
I have a sql database with bit datatypes and I am trying to create a asp
webform which will display and update the data from checkboxes.

Dynamic Checkbox
I have a table in ASP page which displays records and it has a checkbox whose name is ChkBox<%= intRecID %>

<%= intRecID %> is the ID of that record. Now how should I chck whether check box is not checked.


Copyright © 2005-08 www.BigResource.com, All rights reserved