<% 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) %>
<%=tigRS("total_hits")%> pages viewed since 30th Jan 00
..::LvL © 1999-2001 Tigger-oN
<% tigRS.close tigCON.close %>