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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> wrote: > > But the SQL supported by cayenne doesn't support EXISTS subqueries. >
