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 <[EMAIL PROTECTED]> 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 <[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. > > > -- Eric Polino Campground Automated Systems
