How to implement the greater than or equal SQL statement in iBatis?

Viewed 41094

Let's say in my sql statement I want to do:

WHERE numberOfCookies >= 10 

How do I do this in iBatis?

2 Answers

Because the SQL is written in xml, you cannot just use the symbol ">", you need to write it as:

WHERE numberOfCookies >= 10

Update:

> for greater than

< for less than

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[ ... ]]>

Related