Re: 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.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--