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

[sian_baldwin]

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 :)

[sian_baldwin]

Alternatively - I can just use '> 0' rather than not equal to?

But I am still interested to know the syntax for 'not equal to' in jboss-ql.

[fbiaggi]

Hi,
try (remove spaces) & l t ; & g t ;

Ciao