ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Nayak" <chetannay...@gmail.com>
Subject Re: < and > comparison in sql queries are not accepted by ibatis
Date Mon, 10 Dec 2007 13:40:24 GMT
Use CDATA

On 12/10/07, Thomas Rene Vervik <thomas.vervik@gmail.com> wrote:
>
>
> Hello
>
> I am doing a query like this:
>        <statement id="getTurnover" resultClass="dbBeans.TurnoverHolder">
>                SELECT SUM(STAT01_04.ST0104_ACC01)  as result
>                FROM STAT01_04
>                WHERE STAT01_04.ST0104_DIM04 > #fromDate#
>                AND STAT01_04.ST0104_DIM04 < #toDate#
>        </statement>
>
> but ibatis give me an error that it cant parse the sqlMap. Just to
> eliminate
> all misunderstandings: the query works if I replace the > signs with =, so
> the parse problems in not anywhere else in the document.
>
> So my question would be - how do you manage to make < and > comparisons in
> queries using ibatis ?
>
> Thanks for all suggestions
> Best regards
> Thomas Vervik
> --
> View this message in context:
> http://www.nabble.com/%3C---and---%3E-comparison-in-sql-queries-are-not-accepted-by-ibatis-tp14252091p14252091.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message