> 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? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Hi, My question is how can i do the insertion but in different rows, I mean i want to insert each item of the select list in a new row, how can I do that?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2826 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
