join problem

[jmi <mi...@kepler.fmph.uniba.sk>]

i'm useing tdk 2.1 on mysql 2.3..

i want to join turbine_user with turbine_user_group_role and with turbine_group

what to call if i want as result something, where I can read, which user has some roles in which groups?
it means, i need to have in result fields of more than 1 table...

one sollution is to call doSelect(..) with this criteria on turbineuserpeer and on turibnegrouppeer
but, this will return 2 vectors, and i need some readlocks, and table locks are not what I want to use

any idea?

jmi

Re: join problem

[jmi <mi...@kepler.fmph.uniba.sk>]

finally i have found a solution:

use BasePeer.doSelect(criteria);
:-)
----- Original Message -----
From: "jmi" <mi...@kepler.fmph.uniba.sk>
To: <tu...@jakarta.apache.org>
Sent: Tuesday, August 13, 2002 11:20 AM
Subject: join problem


i'm useing tdk 2.1 on mysql 2.3..

i want to join turbine_user with turbine_user_group_role and with
turbine_group

what to call if i want as result something, where I can read, which user has
some roles in which groups?
it means, i need to have in result fields of more than 1 table...

one sollution is to call doSelect(..) with this criteria on turbineuserpeer
and on turibnegrouppeer
but, this will return 2 vectors, and i need some readlocks, and table locks
are not what I want to use

any idea?

jmi



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>