Welcome to WebmasterWorld Guest from 54.196.175.173

Forum Moderators: ocean10000

Message Too Old, No Replies

ASP and Access

True/False db field causes 500 error

     

chris_f

8:01 am on Jun 16, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi All,

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.

Thanks
Chris

chris_f

8:16 am on Jun 16, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Please ignore. Fized.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month