I am retreiving a standard recordset with the following code:
<%
Set obj = nothing
set conn = server.CreateObject("ADODB.Connection")
set rs = server.CreateObject("ADODB.Recordset")
Conn.Open "DBQ=" & Server.Mappath("Lounge.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
SQL = "SELECT * FROM qrySessions WHERE ((LoginDate) Like '%" & Request.QueryString("LoginDate") & "%') AND ((LoginTime) Like '%" & Request.QueryString("LoginTime") & "%')"
set rs = conn.Execute (SQL)
%>
How do I add a field that keeps track of how many times the value in the [target] field is in the database?
Something like ?
SELECT RecordCount=count(*), * FROM tblWWWLog ..........
then <%=(rs.Fields("RecordCount").Value)%> in the body of the page?
Basicially I need to know if this is a new visitor hitting the web site, or a return visitor
I can't get it to work and need help.