They aren't double quotes, they are a pair of single quotes side by side. This is called "escaping" the quotes.
Look at PreserveSingleQuotes to solve this. Jerry Johnson >>> [EMAIL PROTECTED] 06/14/02 02:37PM >>> >I have a form with a multi-select box. In the action page I want to do a >query with an IN clause based on the values (text) selected. Here's the problem: The list gets passed as: COUNTY='Belknap','Carroll','Cheshire' The debug SQL looks like: ((towncounty.county) IN (''Belknap'',''Carroll'',''Cheshire'')) The cfquery piece is: ((towncounty.county) IN (#attributes.county#)) I know the query is okay, because I can hardcode ('Belknap','Carroll','Cheshire') and it works. Why are the single-quotes turning into double-quotes when I run the query? Thanks, SJ =========================================== Stephen Judd, Local Area Network Manager University of New Hampshire, Cooperative Extension 59 College Rd., G101 Taylor Hall Durham, NH 03824-3587 email - [EMAIL PROTECTED] voice (603) 862-2847 fax (603) 862-1585 =========================================== ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists