Re: check if one of two fields are null

2005-07-15 Thread Larry Meadors
I'd do it in Java, before the mapped statement is called. Larry On 7/15/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > I need to have a dynamic query that appends a where clause if one of > two fields are null. > > I could only come up with > > > DO THIS > > > > DO THIS >

check if one of two fields are null

2005-07-15 Thread Nathan Maves
I need to have a dynamic query that appends a where clause if one of two fields are null. I could only come up with DO THIS DO THIS This is obviously wrong since the code could be appended twice. I need to combine these two statement so that DO THIS is only executed if