| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 2.5.0b5 |
| Request #7671 | Problem with autoExecute statement - missing grave accent | ||
|---|---|---|---|
| Submitted: | 2006-05-19 12:47 UTC | ||
| From: | steve at overlee dot com | Assigned: | lsmith |
| Status: | Closed | Package: | MDB2 (version 1.7.6) |
| PHP Version: | 4.4.2 | OS: | Windows XP |
| Roadmaps: | (Not assigned) | ||
[2006-05-19 12:47 UTC] steve at overlee dot com
(Steve Oliveira)
Description:
------------
When using autoExecute with mysql 5.0.18 I get the following syntax error:
Error: INSERT INTO h_doors (name,type,handing,finish,manufacturer,condition,serial_no,comments,workorder_id,next_service,id) VALUES ('Door 1','Swing','LH Push','Clear','Hunter','Good','3weqwe','sdsa','3','2006-05-19',1) [nativecode=1064 ** 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 'condition,serial_no,comments,workorder_id,next_service,id) VALUE]
PHP CODE
$database->autoExecute($this->table, $data, DB_AUTOQUERY_INSERT);
autoExecute is not producing the correct syntax. It should surround the field names with grave accents (`)
Comments
[2006-05-19 12:52 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-19 13:16 UTC] steve at overlee dot com
Is is possible to specify the quote identifier on autoExecute? If so how is this done? Or will have I have to do manual execute?
[2006-05-19 13:18 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-19 16:26 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-20 10:34 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!