Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: ocean10000
We have recently moved our site to a new server and are now using MySQL 5, ASP 3 and ODBC driver 5.1. I have just run into an issue today where the site doesn't seem to be able to read any data from a text field.
I tested this out by creating a varchar field and putting some data in and I was able to read it just fine with the website. I changed the field to a text field and now nothing is being returned.
Has anyone come across this problem or know of a possible solution?
If you call the data through a query don't use "select * from table_name"
Try stating the fields making the text field the last one.
e.g "select field1,field2,field3_text from table" then use the fields in order . I usually transfer them to variables making the text field (field3_text) the last one to transfer to a variable.
If you have more than one text field specify them last e.g. "select field1,field2,field3_text,field4_text from table_name"
there are other ways of doing it by streaming the data - but the above worked for me OK.
note: we use an older version of Mysql than you do