Long Text Retrieval and MySQL

[da644]

Hi Everyone.

I've got some data stored in a MySQL database in a mediumtext field. When I run a query to retrieve the data it only returns a small amount of it. I've checked in the database and the data is there. I've set the Long Text Retrieval setting in CF Server Admin but this has made no difference. I'm am on Win NT and using MyODBC 2.5 to connect to the database.

Anyone have any ideas...

Thanks

Andrew

http://www.clickitstudios.com

 

[da644]

Sorted it... Once the Long Text Retrieval setting box is ticked, you need to restart the CF Server before it takes effect...

Best Regards

Andrew

http://www.clickitstudios.com