[thelist] Re: Boolean and asp and access

Gary McPherson lists at ingenyus.net
Tue Jan 27 18:41:39 CST 2004

Lightning wrote:

>this is my sql statemnt as is is being created by ASP.
>It was working till I added the boolean field (which is REGISTER).
>update activityTable set event=' Computer Class ' , eventType='Class' ,
>Instructor= 19 , InstructorAlt= 1 , Description= ' Entry level. Classes are
>very small. Pre-registration is required ', Duration=2 , Register=True,
>Location= 'Buzzell Snr Center' , Frequency= 'Weekly' where activityId = 11 ;
Might sound like a no-brainer, but is that query provided exactly as it 
is executed? If you're providing what you expect to see and not 
outputting the exact query being run, you should check that there are no 
quotes where you don't want them. Also, I'd suggest you double-check 
your field definitions - if you haven't been using the same _data_ for 
every test query, another field might well be at fault. The Description 
field seems a possible culprit - assuming you used a text type and 
didn't change the default length, the value you've provided would 
produce that precise error message.

Hope that helps,


More information about the thelist mailing list