Hello,
I tried to insert a # as part of a field and got an error from the server
saying that I had an error in my SQL statement at line 1
"F:\\BL". The error number is (8000FFFF) and the value is supposed to be "F:\\BL#".
I understand that MySQL is interpretting that as a comment identifier. I
should note that the problem is also intermittent.
However, when I run the same query through the ODBC (via database =
explorer) driver it works well enough.
The statement is:
"INSERT INTO Xrefs Values ('base.dwg', 'F:\\accel\\rad\\', '1.dwg',
'F:\\else\\bl#\\');"
How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
sign? Add extra quotes or a backslash before the character? Use double
quotes? Some other method?
ZeosDBO is a set of components for talking to MySQL via the LibMySQL.dll.
Regards,
Robby Tanner B.Sc. (EE), B.Sc. (Cmpt. Sci)
Controls Engineer
Canadian Light Source
University of Saskatchewan
101 Perimeter Road
Saskatoon, Saskatchewan
Canada
S7N 0X4
Ph: (306) 657-3582
Fax: (306) 657-3535
http://www.lightsource.ca
---------------------------------------------------------------------
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
