ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jrhitokiri <jrhitok...@gmail.com>
Subject RE: can IBATIS handle mysql "DATE" keyword?
Date Wed, 14 Oct 2009 11:01:44 GMT

I tried it. It works now. Wow, and I was stumped on that for an hour before I
decided to post here. this helped a lot! Thanks!

But anyway, aside from the greater than and less than symbols, what other
symbols need escaping? so that I'll know when to use this again. 


Niels Beekman-2 wrote:
> 
> 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
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp25887145p25888996.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


Mime
View raw message