For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable choices.
Luis -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 15, 2002 6:40 PM To: CF-Talk Subject: mySQL & CF Hi, all. I'm learning to use mySQL with CF instead of Access... Access had a yes/no field type...in mySQL, I'm using tinyint...is that appropriate? In Access, a value of "Yes" passed in a checkbox formfield put a 1 value in the field with a CFINSERT... Now, the value has been changed to 1 when checked, because mySQL doesn't like "Yes" for tinyint When inserting checkbox values into a mySQL db, I'm using 1 for "Yes" or "True"... but if the checkbox is unchecked, of course, no value is passed and the field (up to this point) has been left blank or null. Should I have it do a zerofill instead of being empty or null? The mySQL fields that were left blank or null when the CFINSERT occured, appropriately left the checkboxes unchecked when I used and update page... Best procedure for handling checkbox values in mySQL? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com