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