Hello, We are using TDK 2.2B3 (w/ Torque 3.0b4) to access an Oracle database and we having a hard time trying to use the addAscendingOrderByColumn() and also the addOrderByColumn() criteria methods. It turns out that it works with a type INTEGER column and NOT with a VARCHAR column. All we get is an "ERROR" on the webpage and the Torque log files are not showing anything that can pinpoint the problem. When an INTEGER is used as the orderby column, everything works seems to be fine in the Torque log files and even the SELECT statement appears correctly.
Here is the line that doesn't work: Criteria stateselect = new Criteria(); stateselect.addAscendingOrderByColumn(StatesPeer.STATE_NAME); List statelist = StatesPeer.doSelect(stateselect); Here is the line that works: Criteria stateselect = new Criteria(); stateselect.addAscendingOrderByColumn(StatesPeer.STATE_ID); List statelist = StatesPeer.doSelect(stateselect); Here is the schema: <table name="SYN_STATES" idMethod="none" javaName="States"> <column name="STATE_ID" required="true" type="INTEGER" /> <column name="STATE_NAME" required="true" type="VARCHAR" /> </table> Any help or workarounds would be appreciated. Thanks! :) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
