what's the actual problem? at a look, try putting 's around the IN clause stuff.
(dbo.answer_rating.eval_email IN ('#manager_direct_staff#') -----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_manager_staff" datasource="emp_records"> SELECT userid FROM emp WHERE status='A' AND level = 2 start with userid='#ATTRIBUTES.manager#' connect by sup_emp_no=prior emp_no and emp_no <> sup_emp_no </CFQUERY> <cfparam name="get_manager_staff" default=""> <cfparam name="name_here" default=""> <cfloop query="get_manager_staff"> <cfset name_here = "'" & get_manager_staff.userid & "'"> <cfset manager_direct_staff = listappend(manager_direct_staff,name_here)> </cfloop> <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> In this case, I am having some problems using the "manager_direct_staff" list variable. Thanks SQL experts! ______________________________________________________________________ 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