I'm willing to convert the column if I can find a way. I'm running a 3.x version my MySQL and at the time an upgrade is out of the question since I don't have access to the machine..
So maybe the question I should be asking is how can I convert: 10-22-04 to 2004-10-22 I've been scratching my head trying to do this in coldfusion but I'm just spinning my wheels.. Still a bit of a noob.. :) -Mike On Tue, 14 Dec 2004 07:37:29 -0800, Rob <[EMAIL PROTECTED]> wrote: > > One way to hack this is to use the "old school date maneuver". Dates > will order correctly using text methods if they are in the format > yyyy-mm-dd. So if you can't find a way to convert that column (which I > highly recommend) you can do something like this (pseudo code) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
