Re: SelectQuery help

From: Jürgen Saar (jsaa..eb.de)
Date: Fri Jan 14 2005 - 08:10:33 EST

Next message: Andrus Adamchik: "Re: Cayenne newbe question"

Previous message: Bryan Lewis: "Re: SelectQuery help"
Maybe in reply to: Jin Lee: "SelectQuery help"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

you can use something like "PersonRoleArray.RoleArray.rolename"
as pathSpec in ExpressionFactory

Jin Lee <jinsle..mail.com> schrieb am 14.01.05 09:10:01:
>
> Hey all,
>
> I have these three tables:
>
> Person (personid, name)
> PersonRole (roleid, personid)
> Role (roleid, rolename)
>
> Where Person has 1-many PersonRole and PersonRole has 1-1 Role
>
> I used the modeler to establish the relationships. What is the proper
> SelectQuery for selecting Persons with rolename equal to a certain
> role (such as "employee")
>
> Any help is greatly appreciated.
>
> Thanks,
>
> Jin

__________________________________________________________
Mit WEB.DE FreePhone mit hoechster Qualitaet ab 0 Ct./Min.
weltweit telefonieren! http://freephone.web.de/?mc=021201

Next message: Andrus Adamchik: "Re: Cayenne newbe question"
Previous message: Bryan Lewis: "Re: SelectQuery help"
Maybe in reply to: Jin Lee: "SelectQuery help"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Jan 14 2005 - 08:10:36 EST