Re: [PHP] PEAR and MDB2

2006-11-12 Thread Alain Roger
so when i have this code : $options = array('debug' = 2, 'portability' = MDB2_PORTABILITY_ALL, ); $query = 'SELECT * from sp_u_001(\'all\')'; $db2 = new MDB2_Driver_pgsql(); $db2-connect($dsn);

Re: [PHP] PEAR and MDB2

2006-11-12 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-11-12 09:46:34 +0100: so when i have this code : $options = array('debug' = 2, 'portability' = MDB2_PORTABILITY_ALL, ); $query = 'SELECT * from sp_u_001(\'all\')';

Re: [PHP] PEAR and MDB2

2006-11-12 Thread Alain Roger
it does not matter, query or exec produce the same error message : Error connection : MDB2 Error: not found connect: [Error message: extension pgsql is not compiled into PHP] :-( On 11/12/06, Roman Neuhauser [EMAIL PROTECTED] wrote: # [EMAIL PROTECTED] / 2006-11-12 09:46:34 +0100: so

Re: [PHP] PEAR and MDB2

2006-11-11 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-11-11 12:02:37 +0100: require_once 'Pear/MDB2.php'; $dsn = 'pgsql://login:[EMAIL PROTECTED]'; $mdb2 = MDB2::connect($dsn); if (PEAR::isError($mdb2)) { die($mdb2-getMessage()); } $res = $mdb2-query('SELECT * FROM articles'); if (PEAR::isError($res)) {