Results 1 to 2 of 2
Thread: text field display in mysql
Feb 26, 2005, 16:48 #1
- Join Date
- Feb 2005
- 0 Post(s)
- 0 Thread(s)
text field display in mysql
I'm new to mysql 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)?
mysql-4.0.20d-win.zip (mysql 4.0.20d) just upgraded to
mysqlcc-0.9.4-win32.zip (mysql control center)
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 conctrol center database.
Response.Write "<TR><TD>Solution: " & Request.QueryString("Solution") &
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.
France :'( :'(
Feb 26, 2005, 17:18 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)