Invalid data '100004' for CFSQLTYPE CF_SQL_NUMERIC. 1

[JohnandSwifty]

Hi,

I have a list - ,100004,100009,100010 - which i need to use in a query - AND Code IN (<cfqueryparam cfsqltype="cf_sql_numeric" list="yes" separator="," value="#ListQualify(URL.clipboardStr,"'",",")#">)

but i keep getting the above error ( Invalid data '100004' for CFSQLTYPE CF_SQL_NUMERIC.) - but it is a number?...

Thanks

 

[cfStarlight]

The values are numeric. They shouldn't be quoted. So remove #listQualify()#

 

[JohnandSwifty]

Thanks!

 

[cfStarlight]

Welcome!