[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