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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
