| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #12673 | Return error when execute statement INSERT INTO [TABLE1] SELECT FROM [TABLE2] | ||
|---|---|---|---|
| Submitted: | 2007-12-12 14:37 UTC | ||
| From: | amusarra | Assigned: | |
| Status: | Wont fix | Package: | DB (version 1.7.13) |
| PHP Version: | 4.4.7 | OS: | SUSE Enterprise Linux Server 10 |
| Roadmaps: | (Not assigned) | ||
[2007-12-12 14:37 UTC] amusarra
(Antonio Musarra)
Description:
------------
Running query type INSERT INTO [Customers] SELECT * FROM [New Customers] on the Informix database (Driver IFX.php) back error SQLCODE = 0. The query syntax is correct and supported by Informix.
Test script:
---------------
// Connect to db
...
// Prepared query
$stm = $db->prepare("INSERT INTO import_sap_log_old SELECT * FROM import_sap_log WHERE id=?");
$data = array($MAX_ID);
$res = $db->execute($s, $data);
....
Comments
[2010-01-08 10:21 UTC] danielc
(Daniel Convissor)
-Status: Open
+Status: Wont fix
Please use MDB2, which properly uses separate methods for select queries (query()) and data manipulation queries (exec()). [2010-01-08 18:22 UTC] amusarra
(Antonio Musarra)
Thanks for your quick response!
I solved the bug almost immediately after opening.
Bye,
Antonio M.