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 + "\","; mysql> explain applog -> ; +------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+----------------+ | applogid | int(10) | | PRI | NULL | auto_increment | | logMessage | varchar(255) | YES | | NULL | | | timedate | timestamp(14) | YES | | NULL | | +------------+---------------+------+-----+---------+----------------+ --------------------------------------------------------------------- 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