On Wed, 21 Feb 2001, allen2k wrote: > > Statement: > Syntax error or access violation: You have an error in your SQL syntax near > 'xxxxxxxxxxxxxxxxxxx","ccccccccccccccccccccccccc","-1","-1",")' at line 1 > > > Was updating a log table in the database that has a message field. The message field >was > being updataed with: > > > query = "INSERT INTO passtbl(user,pass,employeeId,customerId) VALUES"; > query += "(\"" + this.getuserId() + "\","; > query += "\"" + this.getpass() + "\","; > query += "\"" + this.employeeId + "\","; > query += "\"" + this.customerId + "\","; drop the last comma, and add a close paranthesis. if you haven't already. also, you can use single quotes to separate values.. Atle --------------------------------------------------------------------- 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
