Displaying text from mySql DB

[JonathanG6SWJ]

I am having trouble displaying text from a mySql DB.

I have a field in a DB of type "medium text". I sucessfully diplay these on my asp page asigning them to a variable altText=RS("dbfield") and then outputting using response.write. All works ok. I have another field of "medium text" and use the same way to output field but if field conatins one two three i get
one
two
three
as though a carriage return has been placed on the end of each word

What am I doing wrong / overlooking

Many thanks in advance
Jonathan

 

[FesterSXS]

how was the text entered into the DB? Did you enter it manually or was it done through a form textarea?

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[JonathanG6SWJ]

Hi Tony
The working text was exported from an MS Access table. The text that does not work was typed straight into table using MySQL Control Center.
Jonathan

 

[FesterSXS]

were the line breaks added when the text was entered or was it simply a string of "one two three"

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[JonathanG6SWJ]

Hi Tony
Answer to 2nd question was - it's just a string one two three - no line breaks or other control characters lurking!

Your first question prompted me to recreate the table & data in Access, delete mySql table and export new access table to mySql. I've done that and it works all OK.

So I think inadvertantly your question solved my problem. When I've got more time I'll back track and try to recreate problem - never come across that before Possibly never again. I wonder if somehow the table in mySql got corrupted.

Thanks for your help
Jonathan

 

[FesterSXS]

glad you've got it sorted

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/