< and > comparison in sql queries are not accepted by ibatis

Mon, 10 Dec 2007 04:54:08 -0800 

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.

Reply via email to