You could try <CFIF ParameterExists(DisplayA)> in you insert statement
-----Original Message----- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:15 PM To: CF-Talk Subject: checkbox -- insert to database problem I'm having problems with checkboxes. I can't find what I'm doing wrong. I've read and reread my sources. I think I understand what to do -- but it still isn't working. PROBLEM: The checkboxes works when they are selected but don't when not. I understand that unselected checkboxes do not pass a value. I thought that CFPARAM would solve the problem. No!!! ERROR MSG below: . Error resolving parameter <B>FORM.DISPLAYA</B><P><P>The specified form field cannot be found... CODE: My user-fills-out-form-page.cfm is <cfform name="eventsCalendar" method="post" action="submitEvent.cfm"> <snip></snip> <input type="checkbox" name="displayA" value="Yes"> <input type="checkbox" name="displayB" value="Yes"> <input type="checkbox" name="displayC" value="Yes"> <snip></snip> </cfform> My processing-page.cfm has <CFPARAM NAME = "displayA" DEFAULT = "No"> <CFPARAM NAME = "displayB" DEFAULT = "No"> <CFPARAM NAME = "displayC" DEFAULT = "No"> <cfquery name="displayEvents" datasource="eventsCalendar"> INSERT INTO displayEvents (displayA, displayB, displayC) VALUES ('#form.displayA#','#form.displayB#','#form.displayC#') </cfquery> I must be missing something very simple. thanks for any clues. gilbert midonnet ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
