ASP菜鸟SQL提问,望各位前辈不吝赐教
我运用ASP操作SQL,编写以下代码,为什么SQL操作成功,但记录是空呢?
DEMO.ASP
<title>Manage</title>
<body>
<div align="center"><font size="+3" face="仿宋_GB2312"><strong>管理</strong></font></div>
<blockquote>
<form name="form" method="post" action="demoinput.asp">
<div align="center">
<p><br>
*Name:<br><input name="id" type="text" size=20 value="<%=request.form("id")%>"maxlength="20"
<br>
</p>
<%
session("id")=Request.Form("id")
%>
</p>
<input type="submit" name="submit" value="input">
</div>
</form>
</blockquote>
</body>
demoinput.asp
<HTML>
<HEAD>
<TITLE> sql</TITLE></HEAD>
<BODY>
<%Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "FILEDSN=c:\Program Files\Common Files\ODBC\Data Sources\demo.dsn"
MyConn.Execute "INSERT id (id) VALUES ('"&session("id")&"')"
MyConn.Close%>
</BODY>
</HTML>