Cann't use criteria two times.

[Vinod_Thapliyal]

 Hi all,

I have created a criteria to query on one of my table. It involves join on tables. The 
first time I query on a table the results are returned. But, next time when I try to 
use the same criteria on the other table. It retunrs me an error. I tried a query on 
the second table by commenting the query for first table then I get the results. But, 
the two queries don't work together.

The criteria is:

criteria.addJoin(TurbineProjectsPeer.GROUP_ID,TurbineUserGroupRolePeer.GROUP_ID);

                        
criteria.addJoin(TurbineUserGroupRolePeer.GROUP_ID,TurbineGroupPeer.GROUP_ID);

                        
criteria.addJoin(TurbineUserGroupRolePeer.USER_ID,TurbineUserPeer.USER_ID);

 

                        criteria.add(TurbineUserGroupRolePeer.ROLE_ID,10);


                       Iterator = Projects;

 

Projects = TurbineProjectsPeer.doSelect(criteria).iterator();

 

                                    Projects = 
TurbineUserGroupRolePeer.doSelect(criteria).iterator();

I get the following error:

Error: org.apache.torqueException: Bad Conversion: java.lang.numberformatexception: 
silent


Any clue why its behaving like this?

vinod

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]