The way I've always done this is this: On the form page:
<input type="checkbox" name="thisBox" value="1"> On the processing page: <cfparam name="form.thisBox" default="0"> ..the benefit of this approach is that, should the checkbox be checked on the form page, form.ThisBox is passed to the processing page with a value of "1". When it is _not_ checked, it is not passed to the processing page at all; and the param tells CF that the default value for form.thisBox is "0". Takes care of any problems. The easiest way to do it, especially since I to tend to store checkbox values as BITs in the DB. Kennerly, Rick H CIV wrote: >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