<%
set tigCON = Server.CreateObject("ADODB.Connection")
tigCON.Open(DSN)
'do it like to make sure we get the current count
query = "update q3a_hits set " & _
"hits = (SELECT hits as total_hits " & _
"FROM q3a_hits) + 1"
'Response.Write("Query = [" & query & "] ")
tigCON.Execute(query)
'now we want the page total, and as we can't get it
'from the above query (as far as i know) we need to
'make a second query :[
query = "SELECT hits as total_hits " & _
"FROM q3a_hits"
set tigRS = tigCON.Execute(query)
%>