sorry, that should be DATE(viewed_last) i guess... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/
On 30/09/2009 20:22, Azadi Saryev wrote: > 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:326779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
