Guess what.... Just this very second I decided to give the date_format() function a go to see whether that would fix it...
And WHAM!!! It did. Even though you can use the max() and min() function on dates, for some reason it then converts them to none date objects, which is not clear through MySQL-Front. HTH anyone else! > -----Original Message----- > From: Niklas Richardson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 01, 2003 1:51 PM > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX & MySQL - Dates becoming binary > objects!!!!! > > > From some more research, it seems that it happens only when I > use MySQL date > functions on a date column. > > If I just query the columns directly without any functions it > returns it > correctly. > > Weird. Still - if anyone knows the fix...that'd be great. > > > -----Original Message----- > > From: Niklas Richardson [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 01, 2003 1:10 PM > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] CFMX & MySQL - Dates becoming binary > objects!!!!! > > Importance: High > > > > > > Hi everyone, > > > > Anyone run into a problem of CFMX returning dates from MySQL > > record sets as > > binary objects? > > > > If so - how do you stop it happening? > > > > Thanks > > > > Niklas > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
