% Dim strsql Dim rs set rs=server.CreateObject("adodb.recordset") rs.open "select vdate,ipadd,clicknum from R_VTOTAL where vdate=#"& date() &"# and ipadd='"&trim(Request.ServerVariables("REMOTE_ADDR")) &"'",conn,3,2 if rs.eof then rs.addnew rs("vdate")=date rs("ipadd")=trim(Request.ServerVariables("REMOTE_ADDR")) rs("clicknum")=1 rs.update else rs("clicknum")=rs("clicknum")+1 rs.update end if rs.close %>
|