diff options
| author | jeff <jeff> | 2008-08-25 05:53:14 +0000 |
|---|---|---|
| committer | jeff <jeff> | 2008-08-25 05:53:14 +0000 |
| commit | 4783789db90ba00a0e57077464c689bd082ffb0f (patch) | |
| tree | 6d975ba0bbbd6a66016c254b1dbc25e9f218b887 /httemplate/search/report_tax.cgi | |
| parent | 9698815f033fb517adb399dd437e6abc867a8528 (diff) | |
correct fallout from duplicate line items
Diffstat (limited to 'httemplate/search/report_tax.cgi')
| -rwxr-xr-x | httemplate/search/report_tax.cgi | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index 3d37c47e4..dd6779a61 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -188,7 +188,8 @@ my $join_pkg = " LEFT JOIN part_pkg USING ( pkgpart ) "; -my $where = "WHERE _date >= $beginning AND _date <= $ending "; +my $where = "WHERE _date >= $beginning AND _date <= $ending ". + "AND (duplicate IS NULL or duplicate = '')"; my @base_param = qw( county county state state country ); if ( $conf->exists('tax-ship_address') ) { |