> 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.
This sort of thing...
<cfloop list=#Category# item="ThisCategory">
<cfquery...>
INSERT INTO TheTable (Category) VALUES (#ThisCategory#)
</cfquery>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
