thank you so much. that worked great.
-----Original Message-----
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:49 PM
To: CF-Talk
Subject: RE: multiple select
It would be passed as a comma separated list
e.g., form.assignedEmps = "23,45,123,533,2"
So,
<CFLOOP list="#form.assignedEmps#" index="i" delimiters=",">
<CFQUERY datasource="yourdsn">
INSERT INTO yourtable (ProductID, EmpID)
VALUES (#form.ProductID#, #i#)
</CFQUERY>
</CFLOOP>
Assuming that you want a different row for each employeeid...
HTH,
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:45 PM
To: CF-Talk
Subject: multiple select
how would the insert statement look if i had a select box that allowed the
user to select multiple people to assign to a product? it would be the same
product id each time...just different empid's.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
