Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 55387 invoked from network); 22 Mar 2004 14:56:21 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 22 Mar 2004 14:56:21 -0000 Received: (qmail 72564 invoked by uid 500); 22 Mar 2004 14:56:15 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 72322 invoked by uid 500); 22 Mar 2004 14:56:13 -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 72297 invoked from network); 22 Mar 2004 14:56:13 -0000 Received: from unknown (HELO hotmail.com) (64.4.49.4) by daedalus.apache.org with SMTP; 22 Mar 2004 14:56:13 -0000 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 22 Mar 2004 06:44:20 -0800 Received: from 61.11.79.202 by by14fd.bay14.hotmail.msn.com with HTTP; Mon, 22 Mar 2004 14:44:20 GMT X-Originating-IP: [61.11.79.202] X-Originating-Email: [newtonmn@hotmail.com] X-Sender: newtonmn@hotmail.com From: "newton mn" To: torque-user@db.apache.org Bcc: Subject: Doubt in Torque Update Date: Mon, 22 Mar 2004 20:14:20 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 22 Mar 2004 14:44:20.0591 (UTC) FILETIME=[28FB67F0:01C4101C] 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 hi > "update UserContentRating set Rating="+rating+ " ,ts='"+ts+"'"+" where >ContentItemId="+item_id+" and UserId='"+uid+"'"; > >The above query, i want to change to Torque , I did below like > >Criteria us2 = new Criteria(); >us2.add(UsercontentratingPeer.RATING,rating); >us2.add(UsercontentratingPeer.TS,ts); >Criteria.Criterion cri = us2.getNewCriterion(UsercontentratingPeer.USERID, >uid, Criteria.EQUAL); >Criteria.Criterion cri1 = >us2.getNewCriterion(UsercontentratingPeer.CONTENTITEMID,new >Integer(item_id),Criteria.EQUAL); >us2.add(cri.and(cri1)); >UsercontentratingPeer.doUpdate(us2,connection); > >In that condition valuesis not Updated what i given condition >properly. How can I check the condition in Torque?. any one please help me >as soon as possible. Thanks Newton > _________________________________________________________________ Join BharatMatrimony.com. http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?72 Unmarried? Join Free. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org