Re: RV: [PEAR] Problem with DataObject and Update

Jose, You need to use the constant DB_DATAOBJECT_WHEREADD_ONLY as the argument to DB_DataObject::update(). This allows for multiple row updates by ignoring the primary key field set for your table. It is documented on http://pear.php.net/manual/en/package.database.db-dataobject.db-dataobject.update.php . This sample should get you going: $data = new DO_Inmuebles; $data->publicado = 1; $data->whereAdd( 'codpromocion = 1' );

if($data->update( DB_DATAOBJECT_WHEREADD_ONLY ) > 0)       // passes constant to update()

{ echo ‘It works!!!’; } Buena suerte! HTH, Nick On Apr 12, 2006, at 9:38 AM, Jose Manuel Zea wrote:

Hi Arnaud. Look at the example 33-3 at http://pear.php.net/manual/en/package.database.db-dataobject.db-dataobject.u pdate.php . It´s very similar to what I´m doing. -----Mensaje original----- De: arnaud sellenet bodin [mailto:demental@free.fr] Enviado el: miércoles, 12 de abril de 2006 15:01 Para: Jose Manuel Zea CC: pear-general@lists.php.net Asunto: Re: [PEAR] Problem with DataObject and Update Hi I've never used DB_DataObject this way, and I don't think it was designed for this. WhereAdd is only used in conjonction with find(). Then you have to loop thru the result set using fetch() and update each row. Otherwise you can use the query() method to send a raw query. Le 12 avr. 06 à 13:56, Jose Manuel Zea a écrit :

Hi: Under PHP5 and using the last stable package for DB_DataObject, I´m having a problem when I try to update several rows. Some of the fields in the table are: CREATE TABLE inmuebles ( codinmueble int(10) unsigned NOT NULL auto_increment, (…) codpromocion int(11) default NULL, publicado tinyint(1) NOT NULL default '0', (…) PRIMARY KEY (codinmueble) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 When I want to update the field ‘publicado’ (means published, it´s a boolean value for me) to value 1 or 0 querying by the codpromocion value, I do for example the next thing: $data = new DO_Inmuebles; $data->publicado=1; $data->whereAdd('codpromocion=1'); if ($data->update()>0){ echo ‘It works!!!’; } And nothing happens. But if I do the next, to update the value querying by the primary key: $data = new DO_Inmuebles; $data->publicado=1; $data ->do->get(1); if ($data->update()>0){ echo ‘It works!!!’; } It seems it´s not working when need to update several rows instead of just one. Can anyone help me? Regards, Jose Manuel Zea ______________________________________________ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

--No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.0/306 - Release Date: 09/04/2006 ______________________________________________ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php