PHP 4.0 Bug #6628: MS-Access: insert statement only exec'd once
| From: | bruno dot de dot winter at advalvas dot be | Date: | Fri, 08 Sep 2000 14:18:27 +0000 |
| Subject: | PHP 4.0 Bug #6628: MS-Access: insert statement only exec'd once | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-32671@lists.php.net to get a copy of this message | ||
From: bruno.de.winter@advalvas.be
Operating system: Win98
PHP version: 4.0.2
PHP Bug Type: *General Issues
Bug description: MS-Access: insert statement only exec'd once
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.