Do you suppose this is a MyODBC issue or something deeper?
CFMX uses the Java connect thingy doesn't it? Do you know if the same
thing happens with that?
Tim Blair wrote:
>
> > This was where it started going wrong and needed casting to a
> > char type instead of a date. So long as you don't group on
> > the date field you should be ok.
>
> This seems to be an issue with MySQL - it also appears sometimes when
> you use the MySQL date functions. For some reason the query returns
> binary info instead of the usual text. You can just use
> toString(myQuery.binField) to get the proper value.
>
> Tim.
>
> --
> -------------------------------------------------------
> Badpen Tech - CF and web-tech: http://tech.badpen.com/
> -------------------------------------------------------
> RAWNET LTD - Internet, New Media and ebusiness Gurus.
> WE'VE MOVED - for our new address, please visit our
> website at http://www.rawnet.com/ or call us any time
> on 0800 294 24 24.
> -------------------------------------------------------
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of rawnet limited,
> unless otherwise explicitly and independently indicated
> by an authorised representative of rawnet limited.
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- gobbledegook returned from MySQL TEXT fields Richard Meredith-Hardy
- Re: gobbledegook returned from MySQL TEXT fiel... Jochem van Dieten
- Re: gobbledegook returned from MySQL TEXT ... Richard Meredith-Hardy
- RE: gobbledegook returned from MySQL TEXT fiel... James Smith
- RE: gobbledegook returned from MySQL TEXT fiel... Tim Blair
- RE: gobbledegook returned from MySQL TEXT ... Richard Meredith-Hardy
- RE: gobbledegook returned from MySQL TEXT fiel... Tim Blair