ID: 6628
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: ODBC related
Assigned To:
Comments:
works fine for me.
Previous Comments:
---------------------------------------------------------------------------
[2000-09-08 10:21:12] [EMAIL PROTECTED]
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); } }
----------------------------------------------------------
---------------------------------------------------------------------------
[2000-09-08 10:18:27] [EMAIL PROTECTED]
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.
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=6628&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
