I have added this code to
rpt_stats.aspx.cs
for all of the queries (7 of them)
C#/VB.NET Code:
int NumCustomers = DB.GetSqlN("select count(CustomerID) as N from customer with (NOLOCK) where " + WhereClause.Replace("OrderDate", "CreatedOn") + CommonLogic.IIF(AffiliateID.Length != 0, " and affiliateid=" + AffiliateID + " and LastIPAddress <> '81.134.8.182'", ""));
however I have had no luck it does not exclude our IP (81.134.8.182) I have tried the query in SQL and it works any ideas?
Thanks in advance.