What happens is that it never puts any where clause in at all, it will add bindings for the parameters, but no where.
Note that my example has a couple of paren's in the wrong place, but even with them in the right place it does the same thing. Dan -----Original Message----- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2008 1:37 AM To: [email protected] Subject: Re: Nested #chain directives Never tried this... So what SQL do you you in the logs for this statement? Andrus On Mar 31, 2008, at 8:56 PM, Dan Morgan wrote: > Can #chain directives be nested, as in: > > #chain( 'OR' 'WHERE' ) #chain( 'AND' ) (#chunk($someValue) someColumn > > #bind($someValue 'INTEGER') #end #chunk($someValue2) > someColumn2 <= #bind($someValue2 'INTEGER') #end) #end #chain( 'AND' ) > (#chunk($someValue3) someColumn3 > #bind($someValue3 > 'INTEGER') #end #chunk($someValue4) someColumn4 <= #bind($someValue4 > 'INTEGER') #end) #end #end > > Thanks, > > Daniel L. Morgan > EMail : <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> > > >
