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

Michael Higgins mhiggins at banfieldgroup.com
Wed Apr 25 17:54:36 GMT 2007


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?

Cheers,

-- 
Michael Higgins





More information about the Dbix-class mailing list