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@xxxxxxxxx> 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