|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2000-09-08 10:18 UTC] bruno dot de dot winter at advalvas dot 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.
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Jul 01 19:01:37 2025 UTC |
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); } } ----------------------------------------------------------