Editing: add_ref_res.asp.bak

<!--#INCLUDE FILE="Connectdb.asp"--> <form name="form1" Action = "research_public.asp" method="post"> <% id=request.form("id") comment_res=request.form("comment_res") name_ref_res=request.form("name_ref_res") tel_ref_res = request.form("tel_ref_res") email_ref_res=request.form("email_ref_res") ref_res_detail = request.form("ref_res_detail") ipclient=request.servervariables("remote_addr") datetime_ref_res=now %> <% sql_data="select * from ref_res " set ors_data=server.createobject("adodb.recordset") ors_data.open sql_data,conn,1,3 if not ors_data.eof then ors_data.movelast id_comment_res=ors_data("id_comment_res") if id_comment_res="" then id_comment_res=1 else id_comment_res=id_comment_res+1 end if end if sqldata="insert into ref_res(id_comment_res,comment_res,name_ref_res,tel_ref_res,email_ref_res,ref_res_detail, datetime_ref_res,id_research,ipclient) values("&id_comment_res&",'"&comment_res&"','"&name_ref_res&"','"&tel_ref_res&"', '"&email_ref_res&"','"&ref_res_detail&"','"&datetime_ref_res&"',"&id&",'"&ipclient&"')" set orsdata = Server.CreateObject("adodb.recordset") 'orsdata.open sqldata,conn,1,3 response.write sqldata %> <SCRIPT LANGUAGE="JavaScript"> <% response.write"alert('Thank You for comment and Reference');" %> --> </SCRIPT> <% 'response.write "<meta http-equiv='refresh' content ='0;url=research_public.asp'>" set conn = nothing %> </FORM>