[thelist] Re: Boolean and asp and access

[Lightning]

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 ;

Laura