ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From HelpMePlz <supriyanaidupell...@gmail.com>
Subject Re: <= issues
Date Thu, 27 Aug 2009 10:12:11 GMT



HelpMePlz wrote:
> 
> hi to all
> 
> i  want one help in my requirement in ibatis query i have to use <= but is
> showing error my same code like this
> <isNotEmpty prepend="AND" property="createFromDt">
> 			TO_DATE(NnsManageGroupsPickerV.CREATION_DATE, 'MM/DD/YYYY')
> 			>= TO_DATE(#createFromDt#,'MM/DD/YYYY')
> 		</isNotEmpty>
> 		<isNotEmpty prepend="AND" property="createToDt">
> 			TO_DATE((TO_CHAR(NnsManageGroupsPickerV.CREATION_DATE,
> 'MM/DD/YYYY')),'MM/DD/YYYY')
> 			<= TO_DATE(#createToDt#,'MM/DD/YYYY')
> 		</isNotEmpty>
> 
> 
> please help me it is urgent requirement for me 
> 
> Thanks
> I got solution we have to add like this 
> <![CDATA[
> 			TO_DATE(NnsManageGroupsPickerV.CREATION_DATE, 'MM/DD/YYYY')
> 			<= TO_DATE(#createToDt#,'MM/DD/YYYY')
> 			]]>	
> 
> 

-- 
View this message in context: http://www.nabble.com/%3C%3D-issues-tp25167270p25167503.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


Mime
View raw message