cfqueryparam with list
hi,
i have a query (# 1) is orginal, i need to put it into cfqueryparam (#2). I don't know why my #2 is not getting any results back. what's wrong and diffrent b.w two?
Thanks
==========
#1: record returned
<<cfquery>
......
and contract_number in (#quotedvaluelist(getcontract.contract_num)#)
</cfquery>
#2: nothing returned
<cfset variables.ctList = quotedvaluelist(getcontract.contract_num) />
<cfquery>
.......
and contract_number in (<cfqueryparam value="#variables.cList#" list="yes" />)
</cfquery>
