ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: can IBATIS handle mysql "DATE" keyword?
Date Wed, 14 Oct 2009 10:50:28 GMT
Did you try it? Looks like it should work.

-----Original Message-----
From: jrhitokiri [mailto:jrhitokiri@gmail.com] 
Sent: Wednesday, October 14, 2009 12:11 PM
To: user-java@ibatis.apache.org
Subject: Re: can IBATIS handle mysql "DATE" keyword?


will this be okay:


CODE:
<select id="getPossibleConflicts"
parameterClass="iReserveClasses.Reservations"
resultClass="iReserveClasses.Reservations">
<![CDATA[ 

        select * from reservations where ((DATE(start) < DATE(#start#))
AND
(DATE(#start#) < DATE(end))) OR ((DATE(start) < DATE(#end#)) AND
(DATE(#end#) < DATE(end)))
]]>

</select> 


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 <n.beekman@wis.nl>
> 
> 

-- 
View this message in context:
http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp2588
7145p25888427.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message