Thanks for your help, Jeff!
=)
With Regards,
Terry
Jeff Butler <[EMAIL PROTECTED]> wrote: As you've seen, iBATIS won't do this
(there's only a single pass through resolving the SQL statement). You could
write your statement like this:
select * from $TABLES$ $where_clause$ #abc#
HashMap map = new HashMap();
map.put("TABLES", "USER_FORMS");
map.put("where_clause", "where FormName like");
map.put("abc", "%edit%");
List list = userSvc.dynamicSearch(map);
If you want to be completely general, then you'll need to account for many
different possibilities. Take a look at the code generated by Abator - it is
an example of how to code any arbitray where clause with dynamic SQL.
Jeff Butler
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.
