Forum Moderators: open
<script language="javascript">
document.write('<img border=0 hspace=0 vspace=0 width=1 height=1 src="http://208.21.162.221/gat-traffic-get.asp?table=trafficChilhowee&javaScript=yes">'); </script>
The ASP page stores the data in an Access database.
The code I have works intermittantly. Many hits are not getting recorded. Some people coming to the site (doing QA for me) didn't get any of their hits recorded. (The sites each only get about 1000 - 2000 hits per day.) Here is the very straightforward ASP code:
sub subGetHits()
dim dcnDB, rsData, strSQL
dim strTableForSite
strTableForSite = request.QueryString("table")
set dcnDB = funcOpenDatabase(gatdata)
strSQL = "SELECT * FROM " & strTableForSite & " WHERE 1 = 2;"
set rsData = server.createObject("ADODB.recordSet")
rsData.open strSQL, dcnDB, adOpenDynamic, adLockPessimistic
rsData.AddNew
rsData("whatBrowser") = request.ServerVariables("HTTP_USER_AGENT")
rsData("IP") = request.ServerVariables("REMOTE_ADDR")
rsData("referredBy") = request.ServerVariables( "HTTP_REFERER" )
rsData("javaScript") = request.QueryString("javaScript")
rsData("date") = date()
rsData.update
rsData.close
dcnDB.close
set dcnDB = nothing
end sub
Can someone tell me how to do this right?
Thanks