Yeah, I'm trying that now. I hope that works. Wish someone could
have pointed that out earlier, would have saved me about 6hrs of work!
Thanks,
Eric
On 3/5/08, Mike Kienenberger <mkienen..mail.com> wrote:
> 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.
> >
>
-- Eric Polino Campground Automated Systems
This archive was generated by hypermail 2.0.0 : Wed Mar 05 2008 - 14:52:02 EST