ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "VIJAISENTHIL, P. K." <vijaisenthil.padmanab...@kumaran.com>
Subject pass a result (a String) of a query to another SQL
Date Wed, 08 Feb 2006 17:55:08 GMT
Hi,

    I have a situation like, I need to pass a result (a String) of a query to another SQL
as parameter.

    E.g. like this.

        SELECT SCORING_LEVEL FROM ASSESSMENTS WHERE ID = 12;

        IF SCORING_LEVEL="THIS"
            SELECT SUBJECT, MARK FROM SCORES WHERE SUBJECT_ID = 13;
        ELSE 
            SELECT SUBJECT, MARK FROM SCORES WHERE PARENT_SUBJECT_ID = 13;

    Is it possible to configure or achieve this withthe XML file itslef without coding it
in JAVA?


Thanks and Regards
Vijai Senthil, P. K.

Mime
View raw message