The default sql driver for cf 6 - 8. MSSQL versions 2000 and 2005. Data direct versions 3.3 and greater. It's always been a problem. Most people aren't running databases with the amount of data we are, hundreds of tables many of them with millions or hundreds of millions of rows of data, and a transaction count that would make your head spin.
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, August 11, 2007 3:26 AM To: CF-Talk Subject: Re: Is cfqueryparam worth it? Porter, Benjamin L. wrote: > > When you use cfqueryparam the statement that gets compiled uses > sp_prepexec. For which driver and which MS SQL Server version did you observe this? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
