The required escape characters for xml are: " " ' ' < < > > & &
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 <[email protected]> > Off the top of my head that would be <, # and $ > > -----Original Message----- > From: jrhitokiri [mailto:[email protected]] > Sent: 14 October 2009 01:02 PM > To: [email protected] > 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:[email protected]] > > Sent: Wednesday, October 14, 2009 12:11 PM > > To: [email protected] > > 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 <[email protected]> > >> > >> > > > > -- > > 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: [email protected] > > For additional commands, e-mail: [email protected] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > > > > > -- > 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: [email protected] > For additional commands, e-mail: [email protected] > > > 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: [email protected] > For additional commands, e-mail: [email protected] > >
