|
| |
|
|
Wendy P
Posts: 17
From: Timmins, Ontario, Canada
Status: offline
 |
Check boxes again.... - 6/21/2001 16:52:00
Thanks for the assistance on my last checkbox question....however the saga continues. I am now trying to update a database. One of the fields is a check box. I have no problem when the check box is marked "on" or "yes" or "1" or "true" or whatever else is the positive answer, but as soon as the check box is turned off, I get the following error when I run the update query: Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers One or more form fields were empty. You should provide default values for all form fields that are used in the query. Any ideas on how to deal with this? I assume the problem is caused because the checkbox field is going to the query as "" (null), but how do you work around this? Most greatful for any guidance. Wendy
|
|
|
|
Wendy P
Posts: 17
From: Timmins, Ontario, Canada
Status: offline
|
RE: Check boxes again.... - 6/22/2001 20:12:00
Thanks again spooky...I think I was over complicating things when I was trying to solve this one.....can you say b-r-a-i-n d-a-m-a-g-e :-)
| |
|
|
|
d00nson
Posts: 142
From: Australia
Status: offline
|
RE: Check boxes again.... - 12/13/2001 4:48:43
Spooky,
I know this one's a bit old but I have been traipsing the forums looking for a solution. You'll see me in Sarge's post as well http://66.155.126.102/topic.asp?TOPIC_ID=9446 I noticed u said that you can use ASP to do a check for null values, since my code is on a diet, can you elaborate on the ASP solution? does it involve some inline ASP code that says "if checkbox value = null (ie user unchecked it from a checked state) pass a value of 0" instead? I assume that if the checkbox was unchecked and user checks it, it would by default send -1 (checked) and I wouldn't need to test for the condition? TIA!!
| |
|
 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 
