No. Fields with the same name name return a comma-delimited list when more than 1 is checked. Also, a checkbox is not True or False, it is Undefined or Value (of value="#checkbox_value#).
In your case, the hidden field should be present on forms with checkboxes and provide, as you surmised, a defualt value of 0. Use IsDefined('FORM.checkbox_name') in the UPDATE to determine whether to updaytre the field. -----Original Message----- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 01, 2005 1:44 PM To: CF-Talk Subject: RE: inserting checkboxes into a db ><input type="hidden" name="c1" value="0"> > <input type="checkbox" name="c1" value="a"> > <input type="checkbox" name="c1" value="b"> So the hidden sets the default value, right? Here's what I did. on the page: <input type="hidden" name="#checkbox_name#" value="0"> <input name="#checkbox_name#" #checked# type="checkbox" id="#checkbox_name#" value="#checkbox_value#"> and on the UPDATE page, I left it as is: <cfif structKeyExists(form,'mandate')> <cfset session.mandate = form.mandate> mandate = <cfqueryparam value="#session.mandate#" cfsqltype="CF_SQL_NUMERIC">, </cfif> So, whenever the checkbox exists, it'll either input this the checkbox value or it's hidden field, because the checkbox won't overwrite it. right? oh, I just checked that and it sorta works. If it's not checked, it works fine. If it's checked, then it puts out 38352 in the value, rather than the 1 it's supposed to be. I suppose it's having problems with two fields being named the same. While I don't know if this is how you meant for me to implement it, it seemed intriguing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54