PHP 4.0 Bug #6628 Updated: MS-Access: insert statement only exec'd once
| From: | Bug Database | Date: | Fri, 08 Sep 2000 14:21:12 +0000 |
| Subject: | PHP 4.0 Bug #6628 Updated: MS-Access: insert statement only exec'd once | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-32675@lists.php.net to get a copy of this message | ||
ID: 6628
User Update by: bruno.de.winter@advalvas.be
Status: Open
Bug Type: ODBC related
Description: MS-Access: insert statement only exec'd once
sorry forgot "
----------------------------------------------------------
if ($conws=odbc_pconnect("DB1","Admin","")) {
if ($result=odbc_exec($conws,"insert into MessageQueue (MsgType) values
('MESSAGEONE')") { if (odbc_commit($conws)) {
$result=odbc_exec($conws,"insert into MessageQueue (MsgType) values
('MESSAGETWO')"); odbc_commit($conws); } }
----------------------------------------------------------
Previous Comments:
---------------------------------------------------------------------------
[2000-09-08 10:18:27] bruno.de.winter@advalvas.be
An insert statement on a MS Access database table only works once in the same script:
----------------------------------------------------------
if ($conws=odbc_pconnect("DB1","Admin","")) {
if ($result=odbc_exec($conws,"insert into MessageQueue (MsgType) values
('MESSAGEONE')) {
if (odbc_commit($conws)) {
$result=odbc_exec($conws,"insert into MessageQueue (MsgType) values
('MESSAGETWO')");
odbc_commit($conws);
}
}
----------------------------------------------------------
MessageQueue is a table with one field: MsgType without an index or constraint.
The second insert is not done, although the 'odbc_commit's are succesfull and
'odbc_exec's do return a handle.
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=6628