[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