Q1. What's the best way to dynamically alter ('=' or 'like') to ('!=' or 'not like') in a pre-constructed option ? e.g.
<isNotNull prepend="and" property="attribute1"> FIELD1 like #attribute1# </isNotNull> can become <isNotNull prepend="and" property="attribute1"> FIELD1 not like #attribute1# </isNotNull> or vice-versa. Q2. Is there a way to dynamically add fields to an SQL statement (select/update/insert/delete) ? e.g. A UI customization that indirectly allows adding a field to an existing table, could then have statements that operate on those new fields. Q3. Does Ibatis allow an API call to retrieve the constructed SQL right before the execution ? (Perhaps for achieving the problem above) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com