Thanks man got it working!!!
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Hickman,
Matt
Sent: Monday, 6 January 2003 1:13 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: multiple selects
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/
---
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/
