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

[Matt S Trout]

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 :)

-- 
     Matt S Trout        Need help with your Catalyst or DBIx::Class project?
  Technical Director     Want a managed development or deployment platform?
Shadowcat Systems Ltd.   Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/