James,
The value of your multiple select is passed as a list.
You can loop through the values and insert them into
the database:
<CFLOOP LIST="#FORM.MySelectList#" INDEX="i">
<CFQUERY NAME="qInsertSelection" DATASOURCE="...">
INSERT INTO mytable
(column)
VALUES
(#i#)
</CFQUERY>
</CFLOOP>
Good luck,
Beau
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 12:47 PM
To: SQL
Subject: Inserting data from a muliple select list into database
I have a CFSELECT that has the option to select one or multiple items in
a
dynamic drop down list. If a user selects more than one how do I insert
that
into the database?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
