Filling
all parts of the form is compulsory. In case of any mistakes, you may
not be registered or will be withdrawn from your course.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/users/radio/icelvideo.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM tve WHERE ID = 1", conn
do while NOT rs.EOF
f= rs.Fields("visits") +1
rs.MoveNext
loop
rs.close
conn.close
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/users/radio/icelvideo.mdb"))
sql="UPDATE tve SET visits='" & f & "'"
conn.Execute sql
conn.close
%>