Hi All, I'm finally getting around to trying query a query to order info I'm shoving into a WDDX packet. The packet contains three columns, a date, a string and a string. Is it possible to order by the date field? When I order by this column now is sorts the field but treats it like a string, so that 12/12/2002 is less then 12/9/2002. Is this possible?
Thanks, Duane ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com