• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB-QL problems

 
Stephen Lee
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic