Re: two queries on the same object (Help)

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: > > 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/package.database.db-dataobject.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'); > > > 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-- > > >