ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Kulkarni" <ashish.kulkarn...@gmail.com>
Subject Dynamic Mapped Statements and Iterate question
Date Sun, 16 Sep 2007 14:19:48 GMT
Hi
I have a question about using Dynamic Mapped Statements and Iterate tag

I have a table with columns,
view
code
color

I have an sql statement like below which i have to convert to dynamic mapped
statement

select color from table where view=? and code in (?,?,?)

But the code in must be dynamic, for example user may select 3 code, or 100
code from the jsp select page.

How do i convert the above statement into Dynamic Mapped Statement, ( There
are 2 input parameters, view and code)


Ashish

Mime
View raw message