I have a form that has a bunch of checkbox fields that are dynamically created
from a database.
I need to take the fields selected and evaluate them and convert them to a list
that I can use in a SQL query.
Here is what is coming in to the action page:
FIELDNAMES=PICTCATEGORYNAME1,PICTCATEGORYNAME3,PICTCATEGORYNAME5
PICTCATEGORYNAME1=designed it myself
PICTCATEGORYNAME3=clothes
PICTCATEGORYNAME5=accessories
I need to take this data and get it into my SQLs IN function.
SELECT *
FROM profiles
WHERE pictcategoryname IN ('designed it myself','clothes','accessories')
Are there any magical CF functions that can deliver this? The form fields will
be changing according to what the user selected.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321732
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
