ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nikesh, Kishlay" <kishlay.nik...@fidelity.co.in>
Subject sysdate comparison issue
Date Wed, 26 Jul 2006 04:50:41 GMT
Hi,

I am trying to execute the below query through iBatis -

 	<select id="getUserDetails" resultClass="valueObject"
parameterClass="valueObject">
	    SELECT 
	    column1, column2 
	    FROM  app_table_name 
	    WHERE 
	    (SYSDATE > #property1#) 
	    AND 
	    (SYSDATE < #property2#)  
	    AND 
	    TABLE_ID = #property3#
	</select>

It doesn't allow me using < and > in my queries and gives compilation
problems.
I tried using isLessThan and isGreaterThan as demonstrated in the
tutorial, but wasn't able to do so. 

Can anyone please help me on how to define the above query in my iBatis
sql mapping xml ?

Thanks in advance,
Nikesh


Mime
View raw message