hi,

I'm new to mysql & vbscript and am trying to figure out why I can query so
far almost all the information in my mysql database but can't figure out why
I can't query and display the information for a text field that has a lot of
text in it (several lines)?

using:

MyODBC-standard-3.51.9-win.exe
mysql-4.0.20d-win.zip    (mysql 4.0.20d)  just upgraded to
mysql-4.1.4-gamma-win.zip
mysqlcc-0.9.4-win32.zip   (mysql control center)

Language="vbscript"

Software is of type varchar
Solution is of type text

if I write this, the information in Software is displayed on the web page
but if I try to do the same with the field Solution, nothing at all gets
displayed.

Response.Write "<TR><TD>Software: " & objRecSQL("Software") & "</TD></TR>"
Response.Write "<TR><TD>Solution: " & objRecSQL("Solution") & "</TD></TR>"

I think this one I get to see some of the information but not all of it as
if it's too long to fit, but I know it's there as I can see the entire
information directly in the mysql control center database.

Response.Write "<TR><TD>Solution: " & Request.QueryString("Solution") &
"</TD></TR>"

anyway I can see all of it or at least capture a line at a time so I can
display it on my webpage?

as you can see I'm extremly new at this and would appreciate any help at
all.

Thank You
France