<font size=2 face="sans-serif">Can someone tell me why this:</font>
<br>
<br><font size=2 face="sans-serif">my $rs1 = $c->model('ORANGES::File')->search({'report_id'
=> $rptcode}, {</font>
<br><font size=2 face="sans-serif">
rows => 1,</font>
<br><font size=2 face="sans-serif">
page => $page,</font>
<br><font size=2 face="sans-serif"> });</font>
<br>
<br><font size=2 face="sans-serif">Results in the following SQL?</font>
<br>
<br><font size=2 face="sans-serif">SELECT COUNT( * ) FROM HCDB_TEST.FILE
me WHERE ( report_id = ? ): '541861'</font>
<br>
<br><font size=2 face="sans-serif">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.<br>
</font>