hi jochem, yes, i am using nvarchar. column types are: a int b nvarchar c int d text e text f datetime
fyi, how would i set that param in the jdbc url? here is my current: jdbc:sqlserver:// server1 : 1433 ;DatabaseName=db1 -alex > > > > 1. no cfqueryparam all columns > > Time=31ms, Records=210 > > > > 2. no cfqueryparam no txt columns > > Time=31ms, Records=210 > > > > 3. cfqueryparam all columns > > Time=17297ms, Records=210 > > > > 4. cfqueryparam no txt columns > > Time=16359ms, Records=210 > > > > > > turns out the cfqueryparam is giving me the problem here. any > > thoughts? i use cfqueryparam mostly everywhere as a rule and never > ran > > into this problem. like, why here, why now? > > Are you using any 'N' fields in your database? Have you set > sendStringParametersAsUnicode in your JDBC URL? If not, set it to > false and try again. > Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:265827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
