Try scoping the variable in your cfparam: <CFPARAM NAME = "form.displayA" DEFAULT = "No">
tim P. -----Original Message----- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 6: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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
