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 19:39:00 GMT
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." <vijaisenthil.padmanabhan@kumaran.com>
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" <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