I solved my problem, thanks your kind response.
Criteria us2 = new Criteria();
us2.add(UsercontentratingPeer.USERID,uid);
us2.add(UsercontentratingPeer.CONTENTITEMID,item_id);
List vv=UsercontentratingPeer.doSelect(us2,connection);
Iterator ii=vv.iterator();
Usercontentrating use=new Usercontentrating();
if(ii.hasNext())
{
use=(Usercontentrating)ii.next();
}
use.setRating(ratin);
use.setTs(ts);
UsercontentratingPeer.doUpdate(use,connection);
use.save();Thanks
Newton.
From: Andras Balogh <[EMAIL PROTECTED]> Reply-To: "Apache Torque Users List" <[EMAIL PROTECTED]> To: Apache Torque Users List <[EMAIL PROTECTED]> Subject: Re: Doubt in Torque Update Date: Mon, 22 Mar 2004 17:03:31 +0200
Hello,
I think you have to create 2 Criteria objects and use this method: BasePeer.doUpdate(selectCriteria, criteria, con);
Best wishes, Andras
newton mn wrote:
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Post Classifieds on MSN classifieds. http://go.msnserver.com/IN/44045.asp Buy and Sell on MSN Classifieds.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
