On Fri, Jun 1, 2012 at 6:55 PM, Kenneth S Mclane <[email protected]> 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 _______________________________________________ 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/
