Try <CFPARAM NAME = "form.displayA" DEFAULT = "No"> <CFPARAM NAME = "form.displayB" DEFAULT = "No"> <CFPARAM NAME = "form.displayC" DEFAULT = "No">
> -----Original Message----- > From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 12 September 2002 10:15 a.m. > 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 > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
