Give all the checkboxes the same name (but different values). The values
will be passed in FORM.myCheckboxName as a list. Loop through the list using
CFLOOP and do whatever updates you want.
Or if it suits your purpose, make use of the IN syntax in SQL, as in
UPDATE thisTable
SET y='mynewValue'
WHERE x IN(1,2,5,6,8,9)
Michael Caulfield
-----Original Message-----
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 8:20 AM
To: CF-Talk
Subject: multiple checkbox submit?
Hi,
I have a form with many (30) checkboxes on it, and would like to be able to
update a database with information as to which checkboxes were checked.
Is there a relatively easier way to do this other than 30 cfif/cfelses?
thanks,
Peter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
