not sure if you are using mSsql or mYsql, but if MySQL, then you CAN do it using DATE() function:
ORDER BY DATE(viewed_date) DESC, viewed_total DESC DATE() works just fine on timestamp columns in MySQL... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 30/09/2009 09:44, Mike Little wrote: > thanks brad, the following still throws an error... > > ORDER BY convert(datetime, convert(varchar(10), viewed_last, 101)) DESC, > viewed_day DESC, viewed_total DESC > > am i doing something dumb? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326778 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
