cfqueryparam with list

[kt03]

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>

[Dan_Bracuk]

You overengineered it.  Queryparam adds the quotes for you which means combining it with quotedvaluelist adds two sets of quotes.