PHP Pear - Re: [PEAR] two queries on the same object (Help)

Author

Re: [PEAR] two queries on the same object (Help)

Justin Patrin

2004-08-26, 4:00 pm

On Thu, 26 Aug 2004 15:55:32 +0700, Yuan N Yudistira
<yuan@sabukhitam.net> wrote:
> Hi,..
> My name is Yuan,..
> I am new to Pear
>
> I get this error code :
> MESSAGE: You cannot do two queries on the same object (copy it before
> finding)
> TYPE: PEAR
> DEBUG INFO:
> CODE: -1
>
> What does it mean?
>
> Where to go to find meaning of error code lika this ?
>
> Thanks
>
> YUAN
>
> Ps. I use Pear on Seagull Frame work and
>
> here is a piece of code i am trying to do :
>
> // Generate select box of Client specific to entity
> $oClient = & new DataObjects_Client();

<generatRant>
<quote movie="Zoolander" character="Mugatu">
I feel like I'm taking crazy pills!
</quote>
*WHY* does nearly every DataObject question have their dataobjects
instantiated in this way?

Ok, I suppose I understand...people aren't reading the full manual.
The first page shows direct object instantiation. If you keep reading,
however, you get to:
http://pear.php.net/manual/en/packa...ect.factory.php
which shows you how to use DB_DataObject::factory(). I'll ask the
maintainers to change the intro page.
</generalRant>

The preferred method is:
$oClient =& DataObject::factory('client');

> if($output->isJSO != 1) $oRateType->whereAdd("entity_id =
> $iEntityID");
> $oClient->orderBy('organization_name');
> $result = $oClient->find();
> if ($result > 0) {
> $aClient = array();
> while ($oClient->fetch()) {
> $aClient[ $oClient->client_id ] =
> $oClient->organization_name;
> }
> }
> $output->Client = SGL_Output::generateSelect($aClient);
>

I don't see anywhere in your code that should generate this error.
What line is it happening on? Perhaps it's on the $oRateType object?
This error means that you're using the same DataObject for two
different queries.

--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder

paperCrane --Justin Patrin--

Yuan N Yudistira

2004-08-27, 8:57 am

Dear Mr.Justin

I have fixed the error.

Thanks

YUAN
----- Original Message -----
From: "Justin Patrin" <papercrane@gmail.com>
To: "Yuan N Yudistira" <yuan@sabukhitam.net>
Cc: <pear-general@lists.php.net>
Sent: Friday, August 27, 2004 12:48 AM
Subject: Re: [PEAR] two queries on the same object (Help)

> On Thu, 26 Aug 2004 15:55:32 +0700, Yuan N Yudistira
> <yuan@sabukhitam.net> wrote:
>
> <generatRant>
> <quote movie="Zoolander" character="Mugatu">
> I feel like I'm taking crazy pills!
> </quote>
> *WHY* does nearly every DataObject question have their dataobjects
> instantiated in this way?
>
> Ok, I suppose I understand...people aren't reading the full manual.
> The first page shows direct object instantiation. If you keep reading,
> however, you get to:
>
http://pear.php.net/manual/en/packa...db-dataobject.f
actory.php
> which shows you how to use DB_DataObject::factory(). I'll ask the
> maintainers to change the intro page.
> </generalRant>
>
> The preferred method is:
> $oClient =& DataObject::factory('client');
>
>
> I don't see anywhere in your code that should generate this error.
> What line is it happening on? Perhaps it's on the $oRateType object?
> This error means that you're using the same DataObject for two
> different queries.
>
> --
> DB_DataObject_FormBuilder - The database at your fingertips
> http://pear.php.net/package/DB_DataObject_FormBuilder
>
> paperCrane --Justin Patrin--
>
>
>

Sponsored Links