Wondered if anyone else had experienced this. I have an IN clause query which runs in 500ms if I use cfqueryparam list="true". This same query runs in less than 10ms if I pass the values directly (e.g. 'value1', 'value2', etc...).
I've Googled around a bit and have the impression it's an issue with how the statement is prepared on the db server, but couldn't find any solutions that allowed for using cfqueryparam. Anyone have experience solving this problem? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
