perform a list loop
<!--- Insert the Category --->
<cfloop list="#MultiSelect1#" index="SomeVar">
<cfquery name="SomeQuery" DataSource="SomeDS">
INSERT INTO SOME_TABLE(SomeField)
VALUES(#SomeVar#)
</cfquery>
</cfloop>
to insert the sub categories you would do something similar. If I understand
the question right, this should work.
chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com
Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement. If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone. Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.
-----Original Message-----
From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 12:16 PM
To: CF-Talk
Subject: Multiple Multiple Selects in Query
I have a form that has 2 multiple select list boxes. I have the select
boxes set, but I can't figure out the query. Say I pass from the form these
values category 1,2 and subcategory 1,2. How do I Insert the values into a
database? Any help or suggestions would be appreciated.
If you have any questions or concerns, please feel free to call me at
407-514-5021.
Thank you,
> Issac Rosa
>
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
