# [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\')';
> 
>    $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

Reply via email to