Welcome to WebmasterWorld Guest from 35.173.48.224

Forum Moderators: ocean10000

Message Too Old, No Replies

MySQL 5.0, ODBC 5.1 and text fields

data in text fields doesn't want to be displayed on the site

     
1:16 am on Dec 28, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 7, 2004
posts: 89
votes: 0


Hi,

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?

Harvs

1:00 pm on Jan 2, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:May 22, 2005
posts:657
votes: 20


Stumped me too once.

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