Eric,
I looked back at your original example, and it seems to me that the
only thing you need to do is to change it from Expression.fromString()
to SQLTemplate, and #result-ize the "select * from SA.Site s" part and
#bind-ize the parameter placeholders.
On 3/5/08, Michael Gentry <blacknex..mail.com> wrote:
> When you use an SQLTemplate, you are generating the SQL (except for
> the caveats of #result and friends), not Cayenne. You can issue
> whatever SQL you want to the DB.
>
> /dev/mrg
>
>
>
> On Wed, Mar 5, 2008 at 2:37 PM, Eric Polino
> <eri..ampgroundautomation.com> wrote:
> > But the SQL supported by cayenne doesn't support EXISTS subqueries.
>
This archive was generated by hypermail 2.0.0 : Wed Mar 05 2008 - 14:49:05 EST