7 Replies Latest reply on May 3, 2004 4:24 AM by albert_steed

    Problem with ORDER BY clause in ejb 2.1

    albert_steed Newbie

      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.