ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ed Stafford <walter.staff...@carbonsixty.co.uk>
Subject Re: can IBATIS handle mysql "DATE" keyword?
Date Wed, 14 Oct 2009 12:25:10 GMT
The required escape characters for xml are:

"   &quot;
'   &apos;
<   &lt;
>   &gt;
&   &amp;

Your problem isn't so much with iBatis xml config as it is with the general
requirements of well formed xml.

Cheers,
-Ed

2009/10/14 meindert <meindert@eduflex.com>

> 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