The items that were selected will come through as a comma-delimited list
of the selected values. If you are using these for a SELECT query,
consider using a WHERE xx IN () clause. If your option values are
strings, be sure to use the PreserveSingleQuotes() function to avoid
problems with the use of your CF form variable in the SQL.
"Man is a credulous animal and must believe something. In the absence of
good grounds for belief, he will be satisfied with bad ones."
-- Bertrand Russel, British philosopher (1872-1970)
"Danna D. Swain" <[EMAIL PROTECTED]>
01/21/2003 03:10 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Form List
I have a list item that allows mulitple choices. When I submit the form,
how do I reference the items that were selected. I am trying to use them
to
build a query page?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
