[Catalyst] wrong generated SQL

[Frank Schwach]

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 <matthias.zeichmann at gmail.com> wrote on 06/01/2012 
> 01:25:23 PM:
>
> > From:
> >
> > Matthias Zeichmann <matthias.zeichmann at gmail.com>
> >
> > To:
> >
> > The elegant MVC web framework <catalyst at lists.scsys.co.uk>
> >
> > 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 
> <ksmclane at us.ibm.com> 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 at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> 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.