Developer Forum

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

Va chercher dans les groupes chez MySQL.


Paul...




--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, As a courtesy to those who spend
time analyzing and attempting to help, please
do not top post.