| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe and Support WebmasterWorld|
|ASP and Access|
True/False db field causes 500 error
| 8:01 am on Jun 16, 2004 (gmt 0)|
This has been annoying me for two days and I'm hoping someone can call me a dip and point out something obvious that is wrong. I am using ASP to update a TRUE/FALSE field in an access database.
Whenever the update is perfomed I get:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/ocbs/ocbs2/manager/manbookings.asp, line 153
The line of code is:
CancelBooking.Open "UPDATE Bookings SET CancelledBooking = 'TRUE' WHERE BookingID = " & Request.Form("bookingid")
If I update another field it works fine and I have verified the field name "CancelledBooking". It must be the TRUE bit, however, I have tried it as TRUE, 'TRUE' and "TRUE" to no avail.
| 8:16 am on Jun 16, 2004 (gmt 0)|
Please ignore. Fized.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved