You can't use QueryParams for the order by (or dir) parts of SQL. It can only be used for values in WHERE clauses.
On Tue, Nov 3, 2009 at 5:30 AM, Glyn Jackson <glyn.jack...@newebia.co.uk> wrote: > > Found the issues on this line... > > ORDER BY <cfqueryparam cfsqltype="cf_sql_varchar" > value="#ARGUMENTS.gridsortcolumn#"> <cfqueryparam cfsqltype="cf_sql_varchar" > value="#ARGUMENTS.gridsortdir#"> > > it seems to work without the cfqueryparam. can anyone tell me why this is the > case? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4