ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Schrader <tschra...@gmail.com>
Subject Re: pass a result (a String) of a query to another SQL
Date Wed, 08 Feb 2006 18:25:09 GMT
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