Let's say in my sql statement I want to do:
WHERE numberOfCookies >= 10
How do I do this in iBatis?
views:
599answers:
3
A:
Is this what you want?
<isGreaterEqual prepend="AND"
property="numberOfCookies"
compareValue="10">
BIGFOOT = ‘TRUE'
</isGreaterEqual>
See Dynamic SQL at ibatis.apache.org.
Peter Lang
2010-01-07 20:31:30
Not quite, I made the rookie mistake of forgetting I was working in xml. But thanks :)
Stephane Grenier
2010-01-07 20:37:00
+2
A:
Because the SQL is written in xml, you cannot just use the symbol ">", you need to write it as:
WHERE numberOfCookies <= 10
Stephane Grenier
2010-01-07 20:36:07
+2
A:
Why does it not work?
The only thing I can think of is that the > character isn't playing nice with the XML. In which case, you can wrap the entire statement within <![CDATA[ ... ]]>
Tinister
2010-01-07 20:37:34
that's true unless you're also adding values for iBatis such as "WHERE numberOfCookies <= #value#"
Stephane Grenier
2010-01-07 21:22:13