ASP向SQL中输入数据,出现了错误!高手帮忙!急~
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%><html><head><title>无标题文档</title></head><%name=trim(request.Form("name1"))submit=trim(request.Form("submit"))if submit=("提交") thenif name="" thenresponse.Write("为空!")end ifend ifset conn=server.CreateObject("adodb.connection")connstr="driver={sql server};server=WAIHUI1;UID=sa;PWD=sa;database=sun"conn.open connstrset rs=server.CreateObject("adodb.recordset")sql="select * from sjw where name='"&name1&"'"rs.open sql,connif not rs.bof and not rs.eof thenresponse.Write("有!")end ifrs.closeset rs=server.CreateObject("adodb.recordset")sql="select * from sjw"rs.open sql,conn,3,3rs.addnewrs("name")=name1rs.updaters.closeset rs=nothing%><body><table width="200" border="1"><form action="2.asp" method="post" name="form1"><tr><td>名</td><td><label><input name="name1" type="text" size="15" maxlength="20"></label></td></tr><tr><td colspan="2"><input type="submit" name="Submit" value="提交"></td></tr></form></table></body></html>
参考答案:具体哪里错了.数据库连上了吗,主键重复了吗,记录集 Rs 关闭后,如果没有清空,不用在定义一次,直接打开就行.
Rs.Close
这中间不用在定义一次
Rs.Open Sql,Conn,3,3