% if request.form() <> "" then pname = request.form("pname") schoolname = request.form("schoolname") noofpeople= request.form("noofpeople") phone= request.form("phone") email= request.form("email") set conn=Server.CreateObject("ADODB.Connection") ' conn.Provider="Microsoft.Jet.OLEDB.4.0;" ' conn.Open "http://www.littleflowerschool.edu.hk/webapply/db1.mdb" ' conn.Open "db1" ' sql = "insert into apply values('"&pname&"','"&schoolname&"',"&noofpeople&",'"&phone&"','"&email&"')" ' response.write sql ' set rs= Server.CreateObject("ADODB.recordset") ' rs.Open sql, conn ' set fs = CreateObject("Scripting.FileSystemObject") set textfile =fs.OpenTextFile("http://www.littleflowerschool.edu.hk/webapply/apply.htm", 8, True) textfile.write "