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
