Re: [PHP] MDB2 : never ending story

[Paul Scott]

On Mon, 2006-11-13 at 18:07 +0100, Alain Roger wrote:
> And therefore how do you want to get the result set ?
> nothing is solved now... i still need a fetchrow or fetchOne

Have you read _any_ of the MDB2 docs??



As far as I can see you have decided not to even _try_ any of the
solutions that people on this list, and others, have given you...

My final advice to you is RTFM and google it.



--Paul

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MDB2 : never ending story

[Alain Roger]

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 <[EMAIL PROTECTED]> 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()."".$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

Re: [PHP] MDB2 : never ending story

[Paul Scott]

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()."".$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 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php