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 protected]> wrote on 06/01/2012
01:25:23 PM:
> From:
>
> Matthias Zeichmann <[email protected]>
>
> To:
>
> The elegant MVC web framework <[email protected]>
>
> 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
<[email protected]> 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: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
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.
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
