X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fbrowse%2Fpart_referral.cgi;h=3f59abcf58ed9e00905fa7142f4f56445e05313b;hb=eb54e94a13683132c91bfb33ab90339e88e465c2;hp=69bb95aa5fb5ccede7ec1bc9250f070b47658c43;hpb=8cb3d9ff1a0d7e82b603e0ce15e4a62c182537c4;p=freeside.git 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; %>