my $ncancelled_sth = dbh->prepare("SELECT COUNT(*) FROM cust_main
WHERE agentnum = ?
- AND $ncancelled ")
+ AND ( $ncancelled ) ")
or die dbh->errstr;
my $total_sth = dbh->prepare("SELECT COUNT(*) FROM cust_main
<BR><FONT COLOR="#FF0000"><B><%= $num_cancelled %></B></FONT>
cancelled
</TD>
- <TD>$hashref->{freq}</TD>
- <TD>$hashref->{prog}</TD>
+ <TD><%= $agent->freq %></TD>
+ <TD><%= $agent->prog %></TD>
</TR>
<% } %>