All right, my mistake, > will not cause error. http://www.w3schools.com/XML/xml_cdata.asp
Kengkaj On Mon, Mar 16, 2009 at 4:17 PM, Ingmar Lötzsch < iloetz...@asci-systemhaus.de> wrote: > Kengkaj Sathianpantarit schrieb: > >> Hm, you still need to use CDATA anyway. >> AND EXPECTED_DAY <![CDATA[ >= ]]> ACTUAL_DAYS >> > > I don't believe. The following example works in our application: > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" " > http://ibatis.apache.org/dtd/sql-map-2.dtd";> > <sqlMap namespace="auftrag"> > > <select id="selectByZeitraum" parameterClass="map" > resultMap="result"> > SELECT > <include refid="auftrag.selectFragment"/> > FROM auftrag AS au > WHERE #bis:DATE# >= au.beginn > AND au.ende >= #von:DATE# > ORDER BY au.beginn, au.ende, au.bezeichnung > </select> > </sqlMap> > > Maybe that depends on the version of iBATIS or another component. We are > using > > - PostgreSQL 8.1.3 > - postgresql-8.1-404.jdbc3.jar > - ibatis-2.3.4.726.jar > - Java 1.5.0_11 > > Ingmar > > Kengkaj >> >> On Mon, Mar 16, 2009 at 3:56 PM, Ingmar Lötzsch < >> iloetz...@asci-systemhaus.de <mailto:iloetz...@asci-systemhaus.de>> >> wrote: >> >> I prefere to change the order of the operands, because then is no >> need to use CDATA sections or XML entities. >> >> AND EXPECTED_DAY >= ACTUAL_DAYS >> >> Kengkaj Sathianpantarit schrieb: >> >> Don't forget that you are using XML, use CDATA as follows. >> <![CDATA[ <= ]]> >> >> Kengkaj >> >> On Mon, Mar 16, 2009 at 7:38 AM, Tokajac <imre_to...@hotmail.com >> <mailto:imre_to...@hotmail.com> <mailto:imre_to...@hotmail.com >> <mailto:imre_to...@hotmail.com>>> wrote: >> >> >> Hello! >> >> >> I have a tricky error: in the query last row is AND >> ACTUAL_DAYS <= >> EXPECTED_DAY. For some reason iBatis doesn't want to parse >> "<=" (??). >> Exception: "only well-formed..." >> >> How to solve/work-around this? >> > >
