aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes EJB-QL problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB-QL problems" Watch "EJB-QL problems" New topic
Author

EJB-QL problems

Stephen Lee
Ranch Hand

Joined: Dec 11, 2001
Posts: 74
Hello,
I want to know the details about the new function of EJB-QL. I have 2 problems in using EJB-QL, so I want to know whether they are supported in BES5.02:
1) Could I implement the ORDER BY part dynamically? so that it will be
SELECT OBJECT(e) FROM EmployeeSchema AS e
WHERE <somecondition>
ORDER BY <generated dynamically, depends on the input parameters>
2) Could I implement the WHERE part dynamically? as there are search function in my project.....
e.g. the user can search the employee by the sex, or by the age range........
How can I implement the above functions? Thanks!
Stephen
 
 
subject: EJB-QL problems