ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "meindert" <meind...@eduflex.com>
Subject RE: can IBATIS handle mysql "DATE" keyword?
Date Wed, 14 Oct 2009 11:59:28 GMT
Off the top of my head that would be <, # and $

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


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--tp25887145
p25888996.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


No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.421 / Virus Database: 270.14.15/2434 - Release Date: 10/13/09
19:11:00


---------------------------------------------------------------------
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