3 Replies Latest reply on Dec 3, 2001 1:40 PM by Dain Sundstrom

    Help with EJBQL

    HunterHillegas Newbie

      I am having trouble with an EJBQL query... I'm sure I'm making a dumb
      mistake but my brain is fried and I can't see it.

      Here's the query:

      SELECT OBJECT(p) FROM ProductGroup as c, IN(c.products) AS p WHERE c.name =
      ?1

      The point is to find all products from the productgroup named in the
      parameter.

      I get this upon deployment:

      Path element with identifier is not an instance of AbstractSchema:
      identifier=p, pathElement=[CMRField: name=products]

      ?????

      Thanks,
      Hunter