Ahh the joys of XML.. :-)
Use a CDATA block as follows....be careful with CDATA blocks when you're using iBATIS dynamic SQL tags, sometimes it's easier to just use < and > Luckily for most people this is a rare problem.
<select id="doSelectUser"
parameterClass="java.util.Map resultClass="myClass">
<![CDATA[
select * from tableName where id >= #lower# and id <=
#higher#
]]>
</select>
Cheers,
Clinton
On 2/14/06, Christina Xu <[EMAIL PROTECTED]> wrote:
Hello,
I am new to iBatis. The query is simple but looks like
that iBatis doesn't like ">=" and "<=". Any ideas
about how to solve this problem. Am I doing anything
wrong? Very appreciate your help.
The query is:
<select id="doSelectUser"
parameterClass="java.util.Map resultClass="myClass">
select * from tableName where id >= #lower# and id <=
#higher#
</select>
Christina
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
