[Koha] Report coming up short?

Paul paul.a at aandc.org
Fri Apr 22 06:52:06 NZST 2011


At 01:29 PM 4/21/2011 -0500, Liz Rea wrote:
>Paul,
>Try adding a LIMIT <some number way over the top of what you expect for 
>reults> to the end of that report, and see if it works.

Thank you Liz and Ian -- now functional

Best regards - Paul


>Liz Rea
>NEKLS
>
>On Apr 21, 2011, at 12:57 PM, Paul wrote:
>
> > Would some kind librarian with more than 10,000 biblios please try running
> > the following Mysql report. I works as expected, except that the csv 
> output
> > truncates at 10,000.  If confirmed, I will attempt to post a bug.
> >
> > SELECT biblionumber,
> > CONCAT('<a
> > 
> href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') 
>
> > AS Title
> > FROM biblio
> > ORDER BY biblionumber
> >
> > Thanks,
> >
> > Paul
> > Tired old sys-admin
> >
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list