Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / General DB Topics / April 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
France - 27 Apr 2005 14:32 GMT
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
Paul - 27 Apr 2005 16:05 GMT
Va chercher dans les groupes chez MySQL.

Paul...

>France

Signature

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.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.