<%@ Language=VBScript %> <% set cn = Server.CreateObject("ADODB.Connection") cn.ConnectionTimeout = 6000000 cn.CommandTimeout = 6000000 cn.Open "DSN=Kidsnet_Parent;uid=sa;PWD=sgmkj;APP=ASP Script;DATABASE=Kidsnet" Set rs = Server.CreateObject("ADODB.Recordset") sql = "update kids set home = '" & request("home") & "' where kidid like '" & request("kid") & "'" rs.Open sql,cn Response.Redirect "main.asp"%> <%=sql%>