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 _______________________________________________ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers