Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with ORDER BY clause in ejb 2.1  RSS feed

 
Julien Martin
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I have a pretty straightforward problem with an ORDER BY clause. Here it is:
I have a number of parameters passed in argument; they all come from the web tier. One of them (the sixth parameter) is the sort order criterion.
I have my ejb ql ORDER BY clause as follows:

My app server complains.
Any help appreciated.
Julien Martin.
 
Ade Barkah
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Input parameters can't be used to specify ORDER BY items. They can only be used in the WHERE clause.
Regards,
-Ade Barkah
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!