Brian, Thanks, I will take the info and let you know how a make out.
James -----Original Message----- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 12:55 PM To: SQL Subject: RE: Inserting data from a muliple select list into database James, The form page will send a name value pair to your action page. If more than one value is selected it will send a comma-seperated list of values to the action page (ex. FormValueName=val1,val2,etc.) The way I usually insert multiple selects into a database table is to create a varchar column and insert the comma-sep. list into it. Then when you need to use this value list in any of your scripts you could simply loop through the list of values. Or if you need to use the list for any SQL queries you could just use IN. ex. SELECT ID FROM IDS WHERE ID IN CommaSepList Hope this helps. Brian Ferrigno -----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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
