What about placing the client names into a dropdown and allow multiple selections? This would send a comma delimited list of the ClientIDs, then you could loop through the list in the action page, placing the IDs in your WHERE clause. This would save some real estate on the page depending on how many clients there are.
Otherwise, if you're sure you want to do the checkboxes, do a <cfparam value="Form.ClientIDHere" default="0"> for each ClientID just before the UPDATE/INSERT so that each client has a value. Then you'll either insert a 1 or 0 for each client. I hope my thinking is on the right track here for you. (That's my disclaimer) In any event, enjoy the day! ~Val ----- Original Message ----- From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 9:32 AM 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! > > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
