Re: PEAR and MDB2

# raf.news@gmail.com / 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\')'; > > $db2 = & new MDB2_Driver_pgsql(); > $db2->connect($dsn); > if (PEAR::isError($db2)) > { > die("Error connection : ".$db2->getMessage()); > } > > $res = $db2->exec($query); > if (PEAR::isError($res)) > { > die("Error connection : ".$res->getMessage()); > } > > i get this error ==> "Error connection : MDB2 Error: unknown error" (from > $res control) http://pear.php.net/manual/en/package.database.mdb2.intro-query.php says: exec() should be used for manipulation queries. IOW, you should use query() for SELECTS, exec() for other statements. Perhaps that's your problem? -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991