Re: MDB2 : never ending story

And therefore how do you want to get the result set ? nothing is solved now... i still need a fetchrow or fetchOne.... On 11/13/06, Paul Scott <pscott@uwc.ac.za> wrote:

On Mon, 2006-11-13 at 17:49 +0100, Alain Roger wrote: Dear all, i still got the same error when i run this code : ==> Call to a member function fetchRow() on a non-object on line "while Then why not try something else? Try this: $db2 =& MDB2::connect($dsn, $options);

                        if (PEAR::isError($db2))
                        {
                            die("Error connection :

".$db2->getMessage()."<br><br>".$db2->getUserinfo());

                       }

$db2->setLimit($first, $count); //set the first row that you want and the number of rows after that that you want... $res = $db2->exec($stmt);

        if (PEAR::isError($res)) {
            $ret = false;
        } else {
                .............;

--Paul All Email originating from UWC is covered by disclaimer http://www.uwc.ac.za/portal/uwc2006/content/mail_disclaimer/index.htm

-- Alain ------------------------------------ Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5