2 Replies Latest reply on Nov 26, 2003 1:02 PM by Franco

    jboss-ql and not equal to (!= / <>)??

    sian_baldwin Newbie

      Hi all,

      I am using ORDER BY in my finder queries and so I am overriding the <ejb-ql> queries with <jboss-ql> queries.

      All of them are working perfectly, apart from the ones which include a 'not equal to' sign?

      I have tried:
      <jboss-ql>SELECT OBJECT(a) FROM projectSchema AS a WHERE a.projectOwner = ?1 AND a.projectStatus != 0 ORDER BY a.projectTitle ASC</jboss-ql>

      and:
      <jboss-ql>SELECT OBJECT(a) FROM projectSchema AS a WHERE a.projectOwner = ?1 AND a.projectStatus <> 0 ORDER BY a.projectTitle ASC</jboss-ql>

      Both throw an error?? How do you say 'not equal to' in jboss-ql?

      Many thanks for your help :)