oi CF-Talk,!! I've got a query:
select * from newdir_log order by time desc limit 10; (time is a datetime field) this query, ruin EMS mySql Manager, returns the query in the correct order.... when i run it thru cfmx they are not ordered properly... and a dump of the time field is outputting dates like this: 2003-08-24 21:43:40.0 any ideas, suggestions as to how to get it to order by properly? Crit -- --- [This E-mail scanned for viruses by Declude Virus] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
