[thelist] Re: Boolean and asp and access

Ken Moore psm2713 at hotmail.com
Tue Jan 27 13:31:41 CST 2004


Hi all,

Laura 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).
>
>I have also tried to plunk in YES, No, 1, -1, +1, 0, -0, +0 ... all with
>same results.
>
>Error message is "Microsoft JET Database Engine (0x80040E57)
>The field is too small to accept the amount of data you attempted to add.
>Try inserting or pasting less data." - even when giving it the numbers!
>
>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 
>;

This sounds like a bug in something or at least in the communications. Try 
this: Change Register to a Char(1) with a "Y" or "N" in the field. If this 
works - probably will - it will be a pain but at least you can handle it.

Ken

_________________________________________________________________
Find high-speed ‘net deals — comparison-shop your local providers here. 
https://broadband.msn.com



More information about the thelist mailing list