Please help with vbscript, Mysql, mysql control center & text field display on web page

Please help with vbscript, Mysql, mysql control center & text field display on web page

Post by Franc » Thu, 03 Mar 2005 04:37:00


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
 
 
 

Please help with vbscript, Mysql, mysql control center & text field display on web page

Post by Franc » Thu, 28 Apr 2005 22:26:27

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