RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
wrote: > > Did you try it? Looks like it should work. > > -Original Message- > From: jrhitokiri [mailto:jrhitok...@gmail.com] > Sent: Wednesday, October 14, 2009 12:11 PM > To: user-java@ibatis.apache.org > Subject: Re: can IBATIS handle mysql "DATE" keyword?

Re: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
will this be okay: CODE: Regards, JR Ed Stafford-3 wrote: > > You could also wrap it in CDATA block if you don't want to deal with > escaping everything (http://www.w3schools.com/xmL/xml_cdata.asp). > > -Ed > > 2009/10/14 Niels Beekman > > -- View this message in context: http:

can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
I have this query I tested in mysql. it works when I type it and use example input: CODE: select * from eservations where (DATE(start) < DATE(input_start) AND DATE(input_start) < DATE(END)) OR (DATE(start) < DATE(input_end) AND DATE(input_end) < DATE(end)) the thing is, ibatis throws an excep