[jifty-devel] Patch for allowing an array of values within limit

[Edward Funnekotter]

Thanks Jesse.  I have committed it to the Jifty-DBI trunk (r3923).  You can
now easily limit yourself to a known set of values.


On 8/20/07, Jesse Vincent <jesse at bestpractical.com> wrote:
>
> looks good. go for it.
> On Aug 15, 2007, at 10:01 AM, Edward Funnekotter wrote:
>
> > Hi all,
> >
> > Here is a patch for your perusal that contains fixes to Jifty-DBI
> > to allow a limit clause to contain an array ref.  This gets
> > converted to an 'IN' operator within the built SQL query.  The
> > operator can be either 'IN' or '='.
> >
> > E.g.
> >
> >         $users_obj->limit( column => 'login',
> >                            operator => 'IN',
> >                            value => ['cubic', 'obra', 'glasser',
> > 'audreyt'] );
> >
> > Could someone in the know, take a peek and ok the commit?
> >
> > Thanks,
> > Edward
> >
> >
> > <in_operator_patch.gz>
> > _______________________________________________
> > jifty-devel mailing list
> > jifty-devel at lists.jifty.org
> > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
>
>
> _______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bestpractical.com/pipermail/jifty-devel/attachments/20070820/bdf32c65/attachment.htm