Hi Sam, The problem you're running into involves one of the basic features of cfquery ( yes, it's a feature, not a bug ) ... When you place a variable within a cfquery tag, cf automatically escapes any single quotes in that variable, so that if you've created a form for users to insert data into the db and they type " margaret's stuff " into a form field, you can just say INSERT INTO userdata ( datacolumn ) VALUES ( '#form.userdata#' ) and you don't have to explicitly specify routines to escape the form variable when you insert or update the db.
So Allaire wisely provided a couple ways for us to use single quotes in queries ( less common ) with function calls... The most common functions used are ListQualify() and PreserveSingleQuotes ... In this case, what you want is something like this : select * from employee where userid in ( #ListQualify(ArrayToList(MyArray),"'")# ) hth Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
