On another note, is it possible to incorporatre a checkbox into CFGRID>?
If so, this will work for me? -----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:53 AM To: CF-Talk Subject: RE: Multiple Checkbox update? <form ...> <input type="checkbox" name="customerOne"> <input type="checkbox" name="customerTwo"> <input type="checkbox" name="customerThree"> </form> Then when your doing your insert query <cfquery name="insert" datasource="#request.dsn#" ...> INSERT INTO tblSubscribe (customerOne,customerTwo,customerThree) ( <cfif IsDefined("form.customerOne")><cfset customerOne=1>#customerOne#,<cfelse>0,</cfif> <cfif IsDefined("form.customerTwo")><cfset customerTwo=1>#customerTwo#,<cfelse>0,</cfif> <cfif IsDefined("form.customerThree")><cfset customerThree=1>#customerThree#,<cfelse>0</cfif> ) </cfquery> Then if you had another page showing who has done what it could look something like this <cfquery name="get" datasource="#request.dsn#" ...> select customerOne,customerTwo,customerThree from dbo.somewhere where someid=#maybesomevar# </cfquery> <cfparam name="ATTRIBUTES.customerOne" default="#get.customerOne#"> <cfparam name="ATTRIBUTES.customerTwo" default="#get.customerTwo#"> <cfparam name="ATTRIBUTES.customerThree" default="#get.customerThree#"> <FORM ....> <input type="checkbox" name="customerOne" <cfif len(ATTRIBUTES.customerOne) GT 0>selected</cfif>> <input type="checkbox" name="customerTwo" <cfif len(ATTRIBUTES.customerTwo) GT 0>selected</cfif>> <input type="checkbox" name="customerThree" <cfif len(ATTRIBUTES.customerThree) GT 0>selected</cfif>> </FORM> Just a quick and straight forward way but there are others and probably better, J -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 2:33 PM To: CF-Talk Subject: RE: Multiple Checkbox update? All I need to do is have the action page either enter a 1 into a field in my DB if the checkbox is defined (selected). I've got a list of clients and they want the ability to check them off on a monthly basis inorder to keep track of billing. So, I have a drop down that has our different services. The user selects the ares they want, then it lists all the clients with a checkbox. If the checkbox is checked, they were billed in the previous cycle, if it isn't they will check it and add it to our accounting system. -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:29 AM To: CF-Talk Subject: Re: Multiple Checkbox update? There are many ways to skin this cat, but it all depends on your checkboxes and what your trying to accomplish. If you could provide more details, I am sure you will get some good help! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder > Does anyone happen to know where I can find a good example of a multiple > checkbox update? I need one today and I've never done it before. Any, > input would be appreciated. Thanks! > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
