You'll have to loop through the form values at both the category and
subcategory levels.
Without more info on the inserts you are trying to do, I can only guess:
(psuedo-code)
<loop through categories>
insert into categories table values (loop.category)
<loop through subcategories>
Insert into subcategories table values(loop.category,
loop.subcategory)
</loop>
</loop>
-----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