In the database field you can set the value to anything you want, however you will need to test for the value to properly set the checkboxes on the form to be checked or unchecked.
Example: CheckBoxField: Value could be "AGREE" or DISAGREE" on the Form: <input type="checkbox" name="abc" value="Agree" <CFIF qMyQuery.CheckBoxField EQ 'AGREE'>checked</cfif>> >>> [EMAIL PROTECTED] 11/01/02 10:29AM >>> When querying a db where some original input fields were check boxes and were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way to display a check box on the query page, either checked or unchecked, to create a form and add an insert field? If so, I'm having trouble with the conditional logic. Is there an approach I'm overlooking. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com