[Dbix-class] order_by problem with paged results - columnnamewithspaces...

[Michael Higgins]

> -----Original Message-----
> From: Matt S Trout [mailto:dbix-class at trout.me.uk] 
> Subject: Re: [Dbix-class] order_by problem with paged results 
> - columnnamewithspaces...
> 
> 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 :)
> 

Ah. That perhaps would explain why none of the listed maintainers have
replied.

If I thought I was even approaching a competence level where I could be of
help, I would jump right in. But I'm not. Not even close. I felt lucky even
to isolate the problem in that module.

With apologies for coming to programming way too late to be of much use,

-- 
Michael Higgins