Can you provide more of a snippet of code? Jim Eisenhauer
On Mon, Jun 14, 2010 at 9:54 AM, Matthew Lesko <m.le...@verizon.net> wrote: > > 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:334536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm