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: >

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
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-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($re