ahh, stupid me. My fault, forgot I was in xml world Thanks to both for your help
have a splended day best regards Thomas Larry Meadors-2 wrote: > > Standard xml escaping: < and > > > Larry > > > On Dec 10, 2007 5:53 AM, Thomas Rene Vervik <[EMAIL PROTECTED]> > 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. >> >> > > -- View this message in context: http://www.nabble.com/%3C---and---%3E-comparison-in-sql-queries-are-not-accepted-by-ibatis-tp14252091p14253170.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
