Can someone help me. I am trying to make calls to Mysql from VBscript via= 
=20ASP But I'm experiencing difficulties with passing host variables to my 
SQL=20 See example below


isbn =3D  717192=20
sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e 
where isbn=3D " &isbn

The above works  but the below doesn't return any thing


Dim pubname
Pubname =3D "Bantam Books"

sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e 
where publisher_name  =3D " &pubname=20
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to