RV: [PEAR] Problem with DataObject and Update

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