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.
posted 12 years ago
Input parameters can't be used to specify ORDER BY items. They can only be used in the WHERE clause. Regards, -Ade Barkah