I've seen this problem just recently when using a <cfqueryparam as part of an "IN ()" clause in my queries. With a large number of list values, the cfqueryparam version of the query took many times longer than using the list directly in the query....doesn't look like you have but a couple of values in your "IN", but maybe the problems are related..
On 1/5/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > Have you set sendStringParametersAsUnicode in your JDBC URL? If > > > not, set it to false and try again. > > > > fyi, how would i set that param in the jdbc url? here is my current: > > jdbc:sqlserver:// server1 : 1433 ;DatabaseName=db1 > > I'm pretty sure you can just tack it onto the end: > > jdbc:sqlserver://server1:1433;DatabaseName=db1;sendStringParametersAsUnicode > =false > > However, if you're using the DataDirect drivers, I'm pretty sure you can set > this within the CF Administrator. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4