> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182415 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
