RE: sysdate comparison issue

Mkhitaryan, Aram Tue, 25 Jul 2006 22:07:05 -0700

Title: sysdate comparison issue

Use this way:

<![CDATA[
            SELECT
            column1, column2
            FROM app_table_name
            WHERE
            (SYSDATE > #property1#)
            AND
            (SYSDATE < #property2#)
            AND
            TABLE_ID = #property3#

]]>
</select>

< and > are xml characters. If you want to write this kind of letters user <![CDATA[ ]]> sections or just use < and >

Best,

Aram

From: Nikesh, Kishlay [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 26, 2006 9:51 AM
To: [email protected]
Subject: sysdate comparison issue

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

RE: sysdate comparison issue

Reply via email to