Do not escape the single ticks. -----Original Message----- From: Jorge Infante Osorio. [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 8:32 AM To: [EMAIL PROTECTED] Subject: Problem whit DELETE
Hi, I new in this list and I have a problemand I hope that any of you can resolve or help me, When I try to delete anything of a table from my database, appear this error: ERROR: Unclosed quote @ 46 STR: ' SQL: DELETE FROM `usuarios` WHERE `Login` = \'Root\' AND `Password` = \'0f9190443d710f90275f66bb723ed6fd\' AND `Acceso` = \'1\' LIMIT 1 SQL-query : DELETE FROM `usuarios` WHERE `Login` = \'Root\' AND `Password` = \'0f9190443d710f90275f66bb723ed6fd\' AND `Acceso` = \'1\' LIMIT 1 MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Root\' AND `Password` = \'0f9190443d710f90275f66bb723ed6fd And I don't know what can I do to resolved that...... Any sugestion????? Jorge. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
