[Catalyst] wrong generated SQL

Kenneth S Mclane ksmclane at us.ibm.com
Fri Jun 1 16:55:47 GMT 2012


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120601/3003fa59/attachment.htm


More information about the Catalyst mailing list