Well , i think i found a problem with mysql and WHERE X IN Y, or maybe
im wrong
I have User (uid,username) and UserFriend (uid,frienduid)
and the query im trying to solve is:
give me the User objects of target uid user friends
I tried this query:
Criteria crit=new Criteria();
crit.addIn(UserPeer.UID,BasePeer.doSelect(new
Criteria().add(UserFriendPeer.UID,thisUser.getUID()).addSelectColumn(Use
rFriendPeer.FRIENDUID)));
out.println(UserPeer.doSelect(crit).size());
Well , the query seems to be good, it shows:
Select user.uid,user.username from user where user.uid in ({'100'})
Which is illegal in mysql, the right query for mysql is:
Select user.uid,user.username from user where user.uid in (100)
Anyone helps me with that? Maybe other way to solve my query?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
