I'm experimenting with a patch I created to do just that. Hopefully it works :)
On 2/6/06, Andrus Adamchik <andru..bjectstyle.org> wrote:
> For now Velocity #foreach is your friend.
>
> Also I would happily commit a patch to the
> org.objectstyle.cayenne.access.jdbc.BindDirective that would
> internally expand a list of objects the the comma-separated syntax :-)
>
> So that you could write "WHERE field IN (#bind($list CHAR))"
>
> Andrus
>
>
> On Feb 6, 2006, at 3:43 PM, Cris Daniluk wrote:
>
> > Apologies if I've overlooked something simple, but for the life of me
> > I can't figure out how to bind a list to a query using something like
> > #bind().
> >
> > I'd basically like to do a simple IN query:
> >
> > SELECT * FROM table WHERE field IN ($list)
> >
> > It doesn't seem like SQLTemplateProcessor and BindDirective support it
> > now, but it seems like it could by simply detecting Collection and
> > making a few simple changes to the query output.
> >
> > Is there another way?
> >
> > Cris
> >
>
>
This archive was generated by hypermail 2.0.0 : Mon Feb 06 2006 - 18:18:16 EST