I know using cfqueryparam helps with hack attempts on your database and it helps performance for the execution of the queries.
Question, does using the cfqueryparam help with performance on the ORDER BY clause? One some of our pages we give the user the ability to change the sort order of the data being displayed. But, we do not use CFQUERYPARAM on the ORDER BY clauses. Thanks, Dave Hatz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:356262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm