Dave, So in CF 4 they transfered the query to a JDBC statement?
On Fri, 22 Oct 2004 19:47:54 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > I'd assume that is something that started at a certain version > > of CF? > > It started when the CFQUERYPARAM tag was added to CF - CF 4, I think. > > > Does it take just one cfqueryparam in the statement for that > > to happen? Such as a insert statement with two columns, one > > of which has a cfqueryparam and the other is a hard coded > > value (for whatever reason). > > If you want to get the full benefits of a prepared statement, to the degree > that it would reuse query plans as much as an analogous stored procedure, > you would need to replace all literal values in your SQL with CFQUERYPARAM > values. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54