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:andru..bjectstyle.org]
Sent: Tuesday, April 01, 2008 1:37 AM
To: use..ayenne.apache.org
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 : <dmorga..homefinder.com<mailto:dmorgan@ihomefinder.com>>
>
>
>
This archive was generated by hypermail 2.0.0 : Tue Apr 01 2008 - 10:10:13 EDT