[Dbix-class] order_by problem with paged results - column namewithspaces...

[Matt LeBlanc]

On 5/8/07, Matt S Trout <dbix-class at trout.me.uk> wrote:
> On Wed, Apr 25, 2007 at 09:54:36AM -0700, Michael Higgins wrote:
> > Reply to myself again...
> >
> > > -----Original Message-----
> > > From: Michael Higgins [mailto:mhiggins at banfieldgroup.com]
> > > > -----Original Message-----
> > > > From: Michael Higgins [mailto:mhiggins at banfieldgroup.com]
> > >
> > > > SQL::Abstract::Limit _seems_ responsible for the errors. If
> > > I pass the
> > > > reference, it carps about ORDER BY SCALAR(0x85d842c) DESC and if I
> > > > don't, then it complains bad column order spec:
> > > > "Invoice #" DESC.
> > >
> > > [8<]
> > [8<]
> > >
> > > Obviously, this ain't a real patch. But, it got me around the
> > > problem... I think. At least, I believe I've isolated the glitch...
> > >
> > > Is there another way to honor the 'pass this sql through like
> > > it is' for order_by with paged results?
> >
> > Since no one replied with an approved workaround, I have to assume this, or
> > like this, is the fix. So, I've posted a bug report here:
> >
> >  http://rt.cpan.org/Ticket/Display.html?id=26558
> >
> >
> > Can anyone suggest a better approach to getting a new release that works as
> > expected with DBIC?
>
> Yah, give us a hand integrating the functionality down into SQL::Abstract in
> a cleaner manner, since the DBIC team is now maintaining that as well :)

What? Someone will respond to my patch submissions now? Time to go
through my old emails and stop feeling so bad for passing around a
long ago bastardized copy of SQL::Abstract to my clients.