diff options
| author | ivan <ivan> | 2006-05-03 09:47:32 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2006-05-03 09:47:32 +0000 |
| commit | e4bb183391faadea2cfca3ba8d75e323f3f96e2e (patch) | |
| tree | 5ae7038947b11489807a843b6eb6e3005fd9d338 | |
| parent | 6ec96b1f3300543268ac49e2f97af1d0524195ab (diff) | |
pg 8.1 fix from Chris Cappuccio
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index d675346f0..1dd0fee86 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -110,7 +110,7 @@ END $owed_cols =~ s/cust_bill\.custnum/cust_bill.custnum AND cust_main.agentnum = '$agentnum'/g; } - my $total_sql = "select $owed_cols"; + my $total_sql = "select $owed_cols from cust_main"; my $total_sth = dbh->prepare($total_sql) or die dbh->errstr; $total_sth->execute or die $total_sth->errstr; my $row = $total_sth->fetchrow_hashref(); |