# raf.news@xxxxxxxxx / 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
