1. No 2. Yes Dave Watts, CTO, Fig Leaf Software
-----Original Message----- From: Michael Christensen <mich...@strib.dk> Sent: Wednesday, 15 July, 2009 18:12 To: cf-talk <cf-talk@houseoffusion.com> Subject: CF prepared statements Okay, so here's how I figure it works: - If you use cfqueryparams in your query, the query is executed as a prepared statement on the SQL server. - If you don't use cfqueryparams, the query is not executed as a prepared statement. Am I right so far? If so, here's a couple of questions: 1) can you have queries with cfqueryparams not be executed as prepared statements on the SQL server? 2) could prepared statements have an adverse effect on performance? Thanks of all input :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
