Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
From: "newton mn" <newtonmn@hotmail.com>
To: torque-user@db.apache.org
Bcc: 
Subject: Re: Doubt in Torque Update
Date: Tue, 23 Mar 2004 20:40:28 +0530
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <BAY14-F3888bsUZjEGu000069cb@hotmail.com>

hi Andras

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 <andras@reea.net>
>Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
>To: Apache Torque Users List <torque-user@db.apache.org>
>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: 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
>

_________________________________________________________________
Post Classifieds on MSN classifieds. http://go.msnserver.com/IN/44045.asp 
Buy and Sell on MSN Classifieds.


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