[phplib] ODBC-DB_SQL-Problem From: Markus Wagner (markus-wagner <email protected>)
Date: 05/14/01

Hallo

I use the ODBC-DB_SQL from PHPLib:

  $q = new DBVT("DELETE FROM verfasser WHERE veroeffentlichung=$id");
  echo $q->Errno." ".$q->Error." ".$q->affected_rows()."<br>";
  $q = new DBVT("DELETE FROM veroeffentlichungen WHERE ID=$id");
  echo $q->Errno." ".$q->Error." ".$q->affected_rows()."<br>";

Output:
  0 3 (all ok. 3 Records are erased)
  0 1 (NO RECORD ERASED!!!)

The first DELETE works very well but the second says all is ok, but the
second DELETE has no effect and no Record get erased.

If you change the DELETE-Statement always only the first will affect to
the database.

Access 2000, Win 2k, PHP 4.0.6dev (www.php4win.de)

My Solution:

I changed in db_odbc.inc (from PHPLib) "odbc_pconnect" to
"odbc_connect"
Know all works, but I dont know why.

Do you know why this happens ?
Do I make a mistake or is there a bug ?

mfg 

-- 
Markus Wagner
  E-mail: markus-wagner <email protected>  
  Hobby: PHP, 747 Jumbo-Jet, Pontiac
  Fingerprint: C95A 4BE1 888E A0E8 FE42  D933 4D88 928D 8CBA 591C

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>