Problem with ORDER BY clause in ejb 2.1

[Julien Martin]

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:

ORDER BY ?6

My app server complains.
Any help appreciated.
Julien Martin.

[Ade Barkah]

Input parameters can't be used to specify ORDER BY items. They can only be used in the WHERE clause.
Regards,
-Ade Barkah