Re: ORDER BY ? PARAMETER ??

[cujo@xxxxxxxxxx]

The ORDER BY clause in a SELECT statement can't be a parameter.  This is a
requirement of the database, not a limitation of the JDBC driver.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




tmalin@hannasteel.com on 07/18/2000 12:09:06 PM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  ORDER BY ? PARAMETER ??




Is it possible to sort a database with an HTML form to select the sort
criteria value and then  passing the value as a parameter to a servlet? The
following code snippet from my servlet will not work with ? for ORDER BY:
Do you have any suggestions?

 String parameter = null;
            if ((request.getParameter("SORT")) == null)
                     stmt = conn.prepareStatement("SELECT * FROM LIB.CUST"
+
                   " ORDER BY cmgage "); // Execute the query
                else {
             parameter = request.getParameter("SORT");
         stmt = conn.prepareStatement("SELECT * FROM LIB.CUST " +
        " ORDER BY ? " ); // Execute the query
       stmt.setString(1, parameter);



Tom




+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---