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 Re: pass a result (a String) of a query to another SQL
Date Wed, 08 Feb 2006 18:51:14 GMT
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" <tschrader@gmail.com>
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. <vijaisenthil.padmanabhan@kumaran.com> 
> 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.
>> 


Mime
View raw message