Yes/No Field causing problems

[christrinder]

Hello,

I've created a database and that db is available on line through ASP pages using various search criteria. I am currently working on the admin pages, i.e. for adding pages to the database and editing them. I have successfully created the addition page, although the only way I can get it to work is by omitting the yes/no fields. The values sent through from the form always seem to be of an invalid type, presumably because they're not numbers or plain text fields. How can I get around this?

Thanks in advance for your help.

Regards,

Chris

[whammy]

I usually use bit fields of 0 or 1, if you just put a 0 or 1 in Yes/No fields I think it will work though. No single quote delimiters!