RE: Nested #chain directives

From: Dan Morgan (dmorga..homefinder.com)
Date: Tue Apr 01 2008 - 10:09:31 EDT

  • Next message: John Emmanuel: "Paging in web application"

    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