Ah yes - now I remember. Convert does fix that for you - but was only available in 4.0+.
At leats now I remember, even tho' I was no help ;o) Mark On Tue, 17 Aug 2004 14:51:08 +1000, Steve Onnis <[EMAIL PROTECTED]> wrote: > Found one > > CONVERT(date_format(repeat_end_date,'%Y%m'), CHAR) as dateGroup > > It has to come out of mySQL as a string, not a date > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel > Sent: Tuesday, August 17, 2004 2:25 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: mySQL headache > > Yeah, I remember that happening to me when I was using 3.* of mySQL. > > I thought it was fixed in 4.*, but I guess I was wrong. > > No solution as far as I could see. > > Mark > > On Tue, 17 Aug 2004 14:14:00 +1000, Steve Onnis <[EMAIL PROTECTED]> wrote: > > Can someone tell me why when I use a date function in mySQL, coldfusion looks at > > the value as a binary value? Its driving me > mental > > > > Something as simple as > > > > date_format(repeat_end_date,'%Y%m') as dateGroup > > > > returns a binary value and as such I cant use it as a date > > > > any ideas? > > > > Am running CFMX6.1 and mySQL 4.0.15 > > > > Regards > > Steve Onnis > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > ICQ: 3094740 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
