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--tp25887145p25888427.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]
