The count query is issued to get a total row count for the pager.
In your template, is it possible that you currently just display the
number of results from the pager instead of the actual resultset data?
As soon as you ask the resultset for data you should see another query
being issued for the row data. What does your template code look like?
On 01/06/12 19:30, Kenneth S Mclane wrote: > Matthias Zeichmann <email@example.com> wrote on 06/01/2012
> 01:25:23 PM:
> > From:
> > Matthias Zeichmann <firstname.lastname@example.org>
> > To:
> > The elegant MVC web framework <email@example.com>
> > Date:
> > 06/01/2012 01:26 PM
> > Subject:
> > Re: [Catalyst] wrong generated SQL
> > On Fri, Jun 1, 2012 at 8:10 PM, Kenneth S Mclane
> <firstname.lastname@example.org> wrote:
> > > I did use .next in my template, but this code should (and did)
> return 4
> > > rows. I am also using a pager on the resultset, which still shows
> 4 pages
> > > when I display the template, however I get no column data, just
> the count.
> > did make sure the block of your template with the while loop actually
> > gets to run?
> > --
> > siggen.pl: Segmentation Fault
> As far as I know it does, I did have to create the template page
> again, but I have been doing it all day with other pages. The only
> problem I see is the SQL is all of a sudden doing a count(*) instead
> of pulling the fields.
> List: Catalyst@lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://email@example.com/
> Dev site: http://dev.catalyst.perl.org/
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
Searchable archive: http://firstname.lastname@example.org/
Dev site: http://dev.catalyst.perl.org/