Hi ,
notice your last field in the Values section.
'query += "\"" + this.customerId + "\",";'
get rid of the comma at the end. end replace it with a close'n
bracket.
notice the last field, you have one extra field in the values bracket.
'xxxxxxxxxxxxxxxxxxx","ccccccccccccccccccccccccc","-1","-1",")' at line 1
cheers
Ken
----------------------------------------------------------------------------
reply to : [EMAIL PROTECTED]
www.mysqlwebring.com
----------------------------------------------------------------------------
>
>
> 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
>
---------------------------------------------------------------------
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
