[PHP] MDB2 : never ending story

2006-11-13 Thread Alain Roger 

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
(( 
so it seems that package MDB2_Driver_pgsql is not loaded or something is
wrong...
i'm really lost...4 days that i work on it without any solution...


   $db2 = MDB2::connect($dsn, $options);
   if (PEAR::isError($db2))
   {
   die(Error connection :
.$db2-getMessage().brbr.$db2-getUserinfo());
  }

   $res = $db2-exec($query);
   if (PEAR::isError($res))
   {
   die(Error connection :
.$res-getMessage().brbr.$res-getUserinfo());
   }

   while (($row = $res-fetchRow()))
   {
   echo $row[0] . br;
   }

--
Alain

Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

Re: [PHP] MDB2 : never ending story

2006-11-13 Thread 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().brbr.$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

Re: [PHP] MDB2 : never ending story

2006-11-13 Thread 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().brbr.$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

2006-11-13 Thread 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??

rant warning

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.

/rant warning

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