I have an access database that tracks hits on specific web pages on a web server.
I want to query out the information, and want to omit hits from people on the office LAN. The first three octets of the LAN is 10.0.0.
My sql statement looks like this:
If I cut and paste this sql query into an Access query, it works, but when I run it from my CGI, in includes IP's starting with 10.0.0.
Why?
PS: I'm using PBCC and SQLToolsPro.
I want to query out the information, and want to omit hits from people on the office LAN. The first three octets of the LAN is 10.0.0.
My sql statement looks like this:
Code:
select ipAddress,hTime,pageName,loginID from mainTable where ((hTime>=#01/01/1900# and hTime<=#01/01/2199#) AND (ipAddress not like '10.0.0.*')) order by hTime,pageName,loginID
Why?
PS: I'm using PBCC and SQLToolsPro.
Comment