db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: How to update multiple rows
Date Tue, 11 Nov 2003 21:01:56 GMT
Ah, I see...  what if the the selection criteria is not by book_id?
E.g.

Update book set book_price = 10 where book_price < 10

> -----Original Message-----
> From: Bill Leng [mailto:wleng@metatomix.com]
> Sent: Tuesday, November 11, 2003 12:55 PM
> To: Apache Torque Users List
> Subject: Re: How to update multiple rows
> 
> that example assumes BOOK_ID is the primary key.
> 
> Ramesh Sabeti wrote:
> 
> >I meant in the example provided by Bill.  If you set the criteria as
> >suggested, Torque would use it in the WHERE clause and not in the SET
> >clause, right?
> >
> >
> >
> >>-----Original Message-----
> >>From: Tulsi Das [mailto:quixote_arg@yahoo.com]
> >>Sent: Tuesday, November 11, 2003 12:45 PM
> >>To: Apache Torque Users List
> >>Subject: RE: How to update multiple rows
> >>
> >>It doesn´t know untill you call
> >>
> >>doSelect()
> >>or
> >>doUpdate()
> >>or even
> >>doDelete() methods
> >>
> >>that´s why it´s only called "Criteria"
> >>
> >>regards
> >>
> >>Tulsi
> >>
> >> --- Ramesh Sabeti <rs@reazon.com> escribió:
> >>
> >>
> >>>How does torque know that c.add(BookPeer.BOOK_PRICE, 0) is to SET a
> >>>value and not for comparison purposes?
> >>>
> >>>
> >>>
> >>>>-----Original Message-----
> >>>>From: Bill Leng [mailto:wleng@metatomix.com]
> >>>>Sent: Tuesday, November 11, 2003 6:18 AM
> >>>>To: Apache Torque Users List
> >>>>Subject: Re: How to update multiple rows
> >>>>
> >>>>You can do something like this
> >>>>Criteria c = new Criteria();
> >>>>c.add(BookPeer.BOOK_PRICE, 0);
> >>>>c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN);
> >>>>BasePeer.doUpdate(c);
> >>>>
> >>>>Ramesh Sabeti wrote:
> >>>>
> >>>>
> >>>>
> >>>>>I have a very simple question: How do you do something like this
> >>>>>
> >>>>>
> >>>with
> >>>
> >>>
> >>>>>Torque?
> >>>>>
> >>>>>	Update book set book_price = 0 where book_id < 100
> >>>>>
> >>>>>Wish there were more online resources.
> >>>>>
> >>>>>Thanks,
> >>>>>
> >>>>>Ramesh.
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
>
>>>---------------------------------------------------------------------
> >>>
> >>>
> >>>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>>>>For additional commands, e-mail: torque-user-help@db.apache.org
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>--
> >>>>Bill Leng
> >>>>Sr. Software Engineer
> >>>>Metatomix, Inc.
> >>>>Tel: (901)261-8911
> >>>>Fax: (901)261-8901
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >---------------------------------------------------------------------
> >
> >
> >>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>>>For additional commands, e-mail: torque-user-help@db.apache.org
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >---------------------------------------------------------------------
> >
> >
> >>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>>For additional commands, e-mail: torque-user-help@db.apache.org
> >>>
> >>>
> >>>
> >>------------
> >>¡Ayudá a los chicos navegando!
> >>En noviembre, Yahoo! dona un plato de comida por cada nuevo usuario
> >>
> >>
> >que
> >
> >
> >>nevegue gratis con Yahoo! Conexión.
> >>Conectate ya en http://conexion.yahoo.com.ar
> >>
>
>>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>For additional commands, e-mail: torque-user-help@db.apache.org
> >>
> >>
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
> 
> --
> Bill Leng
> Sr. Software Engineer
> Metatomix, Inc.
> Tel: (901)261-8911
> Fax: (901)261-8901



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message