On Mon, May 2, 2011 at 2:10 PM, <> wrote: > > >>cfqueryparam creates bound sql parameters, which improve query > performance. > > This is purely theoretical, in practice, the gain in performance is > neglectible. > I prefer have a query to take 11 ms and see the values submitted in case of > error, than having the same query take 10 ms, but no information in errors.
"no information in errors" -- Untrue. The error/catch object has one key "SQL" with the sql statement containing the "(param 1)" etc placeholders, and another key "where" with all the parameters, types, and values. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm