MYSQL returns garbage in Cold Fusion

[manking]

I am using MYSQL with cold fusion 4.5. I put in the following query.


select *

where messageid > 5

order by messageid

One of the columns is messages, it is a text (longtext) colunm.

The message column returned is garbled garbage. In my MYSQL admin program I can see the text yet it returns *(^%*^%*(^(&*(((*$@@#@#.

ANy ideas


Manny

 

[csteinhilber]

You don't appear to specify a table in your query.

Is this intentional?


Also, I know in 5.0 and MX, in ColdFusion Administrator, when you're setting up the DSN, you need to expand the Advanced Settings for the datasource and check the "CLOB --Enable long text retrieval (CLOB)"... I can't remember if that's available in 4.5. It could be 4.5 doesn't have CLOB support.


-Carl

 

[MorganGreylock]

I was thinking the same thing... try something like this:

select *
from tablename
where messageid > 5
order by messageid

Even if 4.5 has CLOB support, try this first to see if thats
what is really causing the problem. Doing multiple things at
once without testing after each change never lets you know
which thing was causing the problem.

Hope that helps,
MG