Thanks alot. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 3:28 PM Subject: Re: Form List
> 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
