Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 69502 invoked from network); 11 Nov 2003 21:04:52 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 11 Nov 2003 21:04:52 -0000 Received: (qmail 90218 invoked by uid 500); 11 Nov 2003 21:04:39 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 90204 invoked by uid 500); 11 Nov 2003 21:04:39 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 90187 invoked from network); 11 Nov 2003 21:04:38 -0000 Received: from unknown (HELO smtp.geobot.com) (66.162.17.179) by daedalus.apache.org with SMTP; 11 Nov 2003 21:04:38 -0000 Received: from metatomix.com (wleng.geobot.com [10.1.7.250]) by smtp.geobot.com (8.9.3/8.9.3) with ESMTP id PAA06135; Tue, 11 Nov 2003 15:04:43 -0600 Message-ID: <3FB14EEB.5030802@metatomix.com> Date: Tue, 11 Nov 2003 15:04:43 -0600 From: Bill Leng User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en, zh-CN MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: How to update multiple rows References: <000b01c3a896$9ebc7ee0$800101df@rsccd.org> In-Reply-To: <000b01c3a896$9ebc7ee0$800101df@rsccd.org> Content-Type: multipart/alternative; boundary="------------050503040306090609000800" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --------------050503040306090609000800 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Without a primary key, I guess, you can not use the example to update. If the primary key contains multiple columns, you need to specify all of them. Hope this helps. Ramesh Sabeti wrote: >I understand that. I can't explain how the example works. Looking at >it, I'd say that both c.add(...) calls add the criteria to the WHERE >clause. How do you interpret it? > >Criteria c = new Criteria(); >c.add(BookPeer.BOOK_PRICE, 0); >c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN); >BasePeer.doUpdate(c); > > > >>-----Original Message----- >>From: Tulsi Das [mailto:quixote_arg@yahoo.com] >>Sent: Tuesday, November 11, 2003 12:53 PM >>To: Apache Torque Users List >>Subject: RE: How to update multiple rows >> >>The criteria is just a hashtable extension to store all the mappings, >>later on, when calling the methods, the SQL generator knows where to >>insert them ( if you are lucky ;) ) >> >>tulsi >> >> --- Ramesh Sabeti escribi�: >> >> >>>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 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 >>> >>> >>> >>------------ >>�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 --------------050503040306090609000800--