[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