cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Morgan <dmor...@ihomefinder.com>
Subject RE: Nested #chain directives
Date Tue, 01 Apr 2008 14:09:31 GMT
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:andrus@objectstyle.org]
Sent: Tuesday, April 01, 2008 1:37 AM
To: user@cayenne.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      : <dmorgan@ihomefinder.com<mailto:dmorgan@ihomefinder.com>>
>
>
>


Mime
View raw message