Question
cfqueryparam and systax error
from this line of code, i got ann error "Conversion failed when converting the varchar value '103,102,101' to data type int. " what should i do, pls help.
<cfset IDList = "#ValueList(getpeople.id)#">
<cfquery name="get_archive" datasource="#db#">
.......
or id not in (<cfqueryparam value="#IDList#" cfsqltype="cf_sql_varchar">)
</cfquery>
Thanks