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]
