0 Replies Latest reply on Feb 17, 2005 10:34 AM by Vicente Torrejon

    Problem using IN in a JBOSS-QL query

    Vicente Torrejon Newbie

      Hi to everyone! I have some problems with a query in a migration to JBOSS.

      THis is my ejb-ql query:
      SELECT Object(o) FROM gtable o, IN(o.infos) alias info where info = ?2 and o.config.gType = ?1

      o.infos = Cmr field, so its a collection of objects
      o.config.gType = cmr-field as well.

      The problem is the next one, so far as I know, you can not have this usage of "IN" with JBOSS-QL. So, what should be the new way???

      Any suggest would be welcome.
      Thanks in advance.