Ashish,
Did you read the documentation? What have you tried so far?
-Richard
Ashish Kulkarni wrote:
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