I haven’t been a big fan of QueryNew() but today I can across a scenario that could come handy.
But then, I ran into a issue that baffled me. May be this issue has been addressed by Adobe but on ColdFusion 8, it’s a still there.
The Issue is. when the value is passed say the column type is not supported(something in that nature. I don’t remember the exact message.) But there are solutions for it.
Here is Adobe‘s workaround but as usual I wasn’t satisfied with that.
So after some more searching, I found a solution. It’s a casting issue and can be addressed by,
<cfset x = queryNew("foo,bar","integer,varchar") />
Read more from here.