%' Set Conn=Server.CreateObject("ADODB.Connection") Conn.Open dsn Dim activeme activeme =2 SQL = "UPDATE guests SET active='" & activeme & "' WHERE ID="& request.querystring("ID") & "" Set RS = Conn.Execute(SQL) %>
Links