Yep this would be another way of presenting the data, handy for people who are used to using access which is usually accounts type people,
of course the data would be represented in a <cfgrid column> as oppossed to checkbox on output, I'm not sure about using cfgrid for initial fresh input, John -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 3:14 PM To: CF-Talk Subject: RE: Multiple Checkbox update? 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! > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
