0 Replies Latest reply on Jul 24, 2006 6:51 PM by flo thomas

    Collection - Depth Problem

    flo thomas Newbie

      Hi,
      I have some problems with a select query.

      I have the following classes

      Person {
      
      Set<Address> addresses;
      
      }
      
      Addresses {
      Set<AccessRight> accessRight;
      
      }
      
      AccessRight {
      Set<Person> members;
      }
      

      now I have a query that says:
      "select person.addresses from Person person where :user in (person.addresses.accessRight.members)"...

      However I get the output "could not resolve property: members of my.core.Addresses" - however, "members" is as you can see actually in accessRight...

      What's wrong with my syntax? I might have to use MySQL 4, so I might not have the option to go for subqueries...
      Any clues?

      Thanks,
      Joey