RE: [JBoss-user] EJB QL: is this possible?

[Alexey Loubyansky]

It's legal.

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ed banfa
Sent: Friday, January 16, 2004 12:30 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] EJB QL: is this possible?

Hello,

 

Assuming I have a CMPBean with an abstract schema name of MyCMPBean and this bean has three cmp managed fields of type int and lets say this field are named x,y and z respectively.

 

No is it possible/legal to execute an EJBQL statement as follows

 

SELECT OBJECT (m)

FROM MyCMPBean m

WHERE (m.x BETWEEN  1 AND 10) AND

             (m.y BETWEEN  100 AND 1000) AND

             (m.z BETWEEN   10000 AND 100000 )

 

My aim is to be able to simultaneously test each of the 3 cmp fields to see if each field is within a given range.

 

Any help wll be apreciated.

 

Thanks

 

Edward

EDWARD BANFA

NETPLAY TECHNOLOGIES INC.
JOS, PLATEAU STATE
NIGERIA.

---

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes