Re: Help with a design issue that I'm stumped by....

On Thu, 08 May 2003 13:03:59 -0400, Vic Cekvenich wrote:

> You need 2 beeans.
> One is a search bean, that will capture the submit of the search screen. 
> (deartment, name, etc.)
> After submit, you pass values to employeeBean.populate(v_dept, 
> v_firstName, etc.). This then display a list of employees.
> Also, the select statment needs to be dynamic.
> 

Vic, after you call employeeBean.populate( v_dept, v_fisrtName, etc), you,
at some point, need to put these properties back into bean or HashMap
again in order for IBatis to use them for building the query (don't you) ?
So, although I like calling employeeBean.populate( ..) like you have
above, I end up having to build a new bean all over again? I'm wondering
if maybe there is a better way to do this?

Also, what is the best way for IBatis to do a search based on "IN (var1,
var2, var3)" Do I just build a comma-delimeted String of parameters and
pass that into IBatis such that...

unitNumbers = "101,102,103,210"

Put the above String unitNumbers into my bean and pass to IBatis...

then in Ibatis...

WHERE unit_number IN #unitNumbers# ??


Thanks again


-- 
Rick