You are right, sorry. Yes i have tried that : ORDER BY substr(refnumber,16,12) DESC, refnumber, begindate DESC
I get the following error message in my stacktrace. com.ibatis.dao.client.DaoException: Failed to queryForList - id [BEHEER.selectByBeheerList1], parameterObject [mode [EMAIL PROTECTED] Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the BEHEER.selectByBeheerList1-InlineParameterMap. --- Check the statement (query failed). --- Cause: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: where;DER BY ENDDATE;<space> Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: where;DER BY ENDDATE;<space> >----- Oorspronkelijk bericht ----- >Van: Richard Yee [mailto:[EMAIL PROTECTED] >Verzonden: maandag, augustus 6, 2007 03:36 PM >Aan: [email protected] >Onderwerp: Re: Question using order by > >Have you tried putting > >select refnumber, rownumber, begindate, enddate, officenumber > from ${schema1}.office ><isParameterPresent> > <include refid="office.abatorgenerated_Example_Where_Clause"/> > <isNotNull property="orderByClause"> > </isNotNull> > </isParameterPresent> >ORDER BY substr(refnumber,16,12) DESC, refnumber, begindate DESC > > </select> > >in your SQL map? You haven't really explained what error or problem you are >having. That is probably why no one is responding. Are you getting any errors? > >-Richard > > > > > >Jdev wrote: >> Is there really nobody who can help me using an order by? >> I have searched on the Internet but I can find nothing useful. >> I have post this question a couple of days ago, but I have got still no >> answer. >> >> -------------------------------------------- >> >> >> I have the following query which must be converted to Ibatis. >> But I don’t know how I must write the SUBSTR and DESC in Ibatis >> >> private final String select1 = >> "SELECT refnumber, rownumber, begindate, enddate, officenumber, " + >> FROM " + ConnectDB.schema1 + ".office " + >> "WHERE refnumber LIKE ? " + >> "ORDER BY substr(refnumber,16,12) DESC, refnumber, begindate DESC "; >> >> Abator has everything generated and everything works perfectly, except I >> don’t know how to write the query in the Ibatis xml file for SUBSTR and DESC. >> Below a small query what Abator has generated and the query mentioned below >> must be extended to what above stands. >> Can someone explain me how or what is the best way to process the above >> query to my new Ibatis query mentioned below. >> >> <select id="………etc…. >> select refnumber, rownumber, begindate, enddate, officenumber >> from ${schema1}.office >> <isParameterPresent> >> <include refid="office.abatorgenerated_Example_Where_Clause"/> >> <isNotNull property="orderByClause"> >> order by $orderByClause$ >> </isNotNull> >> </isParameterPresent> >> </select> >> >> >> Thank you in advance, >> Davy >> >> >> >> > > >
