|
| |
Unticking a checkbox & saving the results in2 access db using asp problem
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
aaronwiles
Posts: 200
Joined: 7/5/2004
From: Aaron Wiles
Status: offline
 |
Unticking a checkbox & saving the results in2 access db... - 7/5/2004 2:38:24
I am trying to update a field in an access db that is of type Yes/No.
On my web page I am using multible checkboxs & am having a major problem in getting these to work correctly to update the database when a user selects or deselects a checkbox. I mange to get the page to tick the box if the data in the db is true and if unticked I am able to tick the box and send the setting to the db, but am unable to untick.
I am recieving the following error msg when unticking the box & submitting (see below).
--------------------------------------------------------------------
Error Type:
Provider (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
--------------------------------------------------------------------
<input type="checkbox" name="work" value="true" <% if chkboxwork = "true" then response.write "checked" %>>Work
It is now 07:29am and I have been up all night trying to figure this out. Please Help! Thanks in advance.
P.S. DB Info:
(Access 2000 Format, using asp 3)
Field Name: Work
Data Type : Yes/No (Format True/False)
|
|
|
|
fatlardo
Posts: 76
Joined: 4/15/2004
From: Shrewsbury
Status: offline
|
RE: Unticking a checkbox & saving the results in2 acces... - 7/5/2004 4:44:41
I'm not sure I understand your problem, but if i read it right (and a rare occasion that would be) you are having trouble writing to the database.
If so, try changing the database fields to text fields with the values yes and no.
If I am wrong, you are free to call me whatever you think necessary!!!!
Hope it helps.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Unticking a checkbox & saving the results in2 acces... - 7/6/2004 15:27:41
IIRC try using a -1 and 0 for true and false values when writing to the DB.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
