X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fbrowse%2Fpart_referral.cgi;h=3f59abcf58ed9e00905fa7142f4f56445e05313b;hp=69bb95aa5fb5ccede7ec1bc9250f070b47658c43;hb=cec266740d89b82ce9075954928c5b336d0ec18e;hpb=8cb3d9ff1a0d7e82b603e0ce15e4a62c182537c4 diff --git a/httemplate/browse/part_referral.cgi b/httemplate/browse/part_referral.cgi index 69bb95aa5..3f59abcf5 100755 --- a/httemplate/browse/part_referral.cgi +++ b/httemplate/browse/part_referral.cgi @@ -23,7 +23,8 @@ Where a customer heard about your service. Tracked for informational purposes. ; my $sth = dbh->prepare("SELECT COUNT(*) FROM h_cust_main - WHERE refnum = ? + WHERE history_action = 'insert' + AND refnum = ? AND history_date > ? ") or die dbh->errstr; %>