Jeremy,
Heres an old chestnut i've used before, if i'm assuming right you've got a
form with checkboxes and user may click one or more and then you do
something with these values??
I was grabbing the value of the checkbox and storing it so i loop over the
"checkbox_id" then insert into db table
<cfloop list="#trim(FORM.checkbox_id)#" index="i">
<CFQUERY name="newHOTLink" datasource="#Application.DSN#" debug="yes">
INSERT INTO tablename (value1, checkbox_id)
VALUES ('#FORM.userID#', #val(i)#)
</CFQUERY>
</cfloop>
Is that what you're after???
Matty
-----Original Message-----
From: Jeremy Watson [mailto:[EMAIL PROTECTED]]
Sent: Monday, 6 January 2003 14:06
To: CFAussie Mailing List
Subject: [cfaussie] multiple selects
Hi guys,
Quick question. I have a form with multiple check boxes i.e. tick here to
turn on...i.e.
Description
red x
blue
green x
When they submit the form I only what the variables that the user has ticked
to be
passed to the database.
What would be the best way to do this? You know wot i mean?
Regards,
Jeremy Watson
ColdFusion Web Developer
BLA
Bob Littler Agencies Pty Ltd
45 Aquarium Avenue
Hemmant, Queensland 4174
Phone: 07 3890 0122
Fax: 07 3890 5388
www.bla.com.au <http://www.bla.com.au/>
www.humminbird.com.au <http://www.humminbird.com.au/>
www.minnkota.com.au <http://www.minnkota.com.au/>
****************************************************************
This e-mail, together with any attachments, is intended for the
named recipient(s) only. If you have received this message in
error, you are asked to inform the sender as quickly as possible
and delete this message and any copies of this message from your
computer system network.
Any form of disclosure, modification, distribution and/or
publication of this e-mail message is prohibited. Unless
otherwise stated, this e-mail represents only the views of
the sender and not the views of the Bob Littler Agencies Pty Ltd
****************************************************************
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
**********************************************************************"
This correspondence is for the named person's use only. It may
contain confidential or legally privileged information or both. "
No confidentiality or privilege is waived or lost by any "
mistransmission. If you receive this correspondence in error, please
immediately delete it from your system and notify the sender. You
must not disclose, copy or rely on any part of this correspondence
if you are not the intended recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to
be the views of Vodafone.
This email has been checked for viruses.
**********************************************************************
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
