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?