[Catalyst] wrong generated SQL

[Matthias Zeichmann]

On Fri, Jun 1, 2012 at 6:55 PM, Kenneth S Mclane <ksmclane at us.ibm.com> wrote:
> Can someone tell me why this:
>
> my $rs1 = $c->model('ORANGES::File')->search({'report_id' => $rptcode}, {
>                 rows => 1,
>                 page => $page,
>         });
>
> Results in the following SQL?
>
> SELECT COUNT( * ) FROM HCDB_TEST.FILE me WHERE ( report_id = ? ): '541861'
>
> When it used to create SQL that actually pulled the fields. It was working
> and I have had to re-create several of my template files which is how I
> discovered this. I made no changes to this code and suddenly it is
> generating this count(*) instead of getting the columns.

you probably used something like .all, .first or a while loop with
.next on your resultset in your template.
unless you do so again, no actual results are going to be fetched from
your database

you might just as well use "find" instead of search if you are only
going for one row

https://metacpan.org/module/DBIx::Class::ResultSet

cheers m
-- 
siggen.pl: Segmentation Fault