db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: Doubt in Torque Update
Date Mon, 22 Mar 2004 15:03:31 GMT
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: 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


Mime
View raw message