Check the <isNull> element in users quide. Think that's exactly what you need,
On 5/4/07, Andrew B <[EMAIL PROTECTED]> wrote:
Hello, I am using iBATIS 2.3.0. I want to map a query for a report, that will have some optional selection criteria. If I map the query with these criteria as parameters, and then send null values for ones the user has not selected, will SQL Map leave them out of the query? Or, if not, is there a way to do this? (I want to avoid using a stored procedure if possible). Thanks, Andrew B ------------------------------ Ahhh...imagining that irresistible "new car" smell? Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
