> 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?
I don't know. However, there are a couple of approaches you can use to find out more. First, you might see if it's one specific CFQUERYPARAM that's causing the problem. Second, you might use SQL Profiler to capture your queries. You could then compare their execution plans. http://www.sqlservercentral.com/columnists/RDyess/obtainingqueryexecutionpla nsthroughsqlprofilertrac.asp 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:265819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
