Adam,
Friday, November 08, 2002, 5:06:47 AM, you wrote:
AY> Ok, I tried using the QUOTE() function exactly how they have it on the string page
in the online manual. Needless to say, this has not worked at all...I get an sql
syntax error every time. If
AY> anyone else has had this problem or knows how to write a sql statement using a
different function that handles special characters like apostrophe's, it would be
GREATLY appreciated. I am using
AY> asp on a w2k server platform. To run the statement, i've tried going through
adodb, mysqlgui, and just plain mysql. Ideas?
What is the version of MySQL server? QUOTE() was implemented in 4.0.3:
http://www.mysql.com/doc/en/News-4.0.3.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
