Re: pass a result (a String) of a query to another SQL

[VIJAISENTHIL, P. K.]

I have done it with SQL itself using DECODE function in oracle, but curious 
of whether this can be done through iBATIS

Thanks
Vijai
----- Original Message ----- 
From: "VIJAISENTHIL, P. K." <[EMAIL PROTECTED]>
To: <user-java@ibatis.apache.org>
Sent: Wednesday, February 08, 2006 1:51 PM
Subject: Re: pass a result (a String) of a query to another SQL

Yea, that would different as in my example, bcos the assessment would be 
associated with a subject.

The constraint is, based on the scoring level of the assessment
       either i need to score a subject directly
       or the outcomes of the subject.

Hope you got me.

Thanks
-Vijai

----- Original Message ----- 
From: "Ted Schrader" <[EMAIL PROTECTED]>
To: <user-java@ibatis.apache.org>
Sent: Wednesday, February 08, 2006 1:25 PM
Subject: Re: pass a result (a String) of a query to another SQL


Hi Vijai,

I have a question about your question:  Will Assessments.ID be the
same as Scores.subject_id and Subject.parent_subject_id?

They are different in your example (12 and 13), but I was wondering if
that was a typo.

Thanks,

Ted

On 08/02/06, VIJAISENTHIL, P. K. <[EMAIL PROTECTED]> 
wrote:

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.