oi Critz!! uh yeah ok..... nevermind the cfc was cached in session scope and had not updated. Bah
-- ------------------------------------ Saturday, August 30, 2003, 10:30:02 PM, you wrote: C> oi CF-Talk,!! C> I've got a query: C> select * from newdir_log order by time desc limit 10; C> (time is a datetime field) C> this query, ruin EMS mySql Manager, returns the query in the correct order.... C> when i run it thru cfmx they are not ordered properly... and a dump of the time field is C> outputting dates like this: 2003-08-24 21:43:40.0 C> any ideas, suggestions as to how to get it to order by properly? C> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
