Have you mailed the query to yourself (or some other way of looking at the actual query that is being thrown against your dbase)? You may need to use the infamous "preservesinglequotes()".
-----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 7:05 PM To: CF-Talk Subject: Using Text lists variable in SQL "IN" operator I'm having difficulty using the "IN" operator condition on a text list dynamically generated from previous query. Any suggestions? <cfquery name="get_category_avg" datasource="emp_review"> SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROM dbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email IN (#manager_direct_staff#)) AND (dbo.answer_rating.self = 'n') </cfquery> ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists