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

Question

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

WHERE numberOfCookies >= 10

How do I do this in iBatis?

The title is backwards, should be: 'how to implement the less than or equal SQL statement in iBatis?' — Adriano Varoli Piazza, Jan 07 '10 at 20:32
I'm confused, you ask for `less than or equal`, but ask for `>=`? — Peter Lang, Jan 07 '10 at 20:33
Thanks for the suggestions, I've made the adjustments. Much better. That's what I get for posting it when I was too tired. — Stephane Grenier, Jan 07 '10 at 21:26

score 60 · Accepted Answer · edited Jan 26 '16 at 09:47

60

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

WHERE numberOfCookies &gt;= 10

Update:

> for greater than

< for less than

edited Jan 26 '16 at 09:47

Green Lei

3,150
2
20
25

answered Jan 07 '10 at 20:36

Stephane Grenier

15,527
38
117
192

1

>= for greater that equal – Sameer Kazi Jul 09 '15 at 08:49

score 8 · Answer 2 · answered Jan 07 '10 at 20:37

8

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

answered Jan 07 '10 at 20:37

Tinister

11,097
6
35
36

that's true unless you're also adding values for iBatis such as "WHERE numberOfCookies <= #value#" – Stephane Grenier Jan 07 '10 at 21:22

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

2 Answers2