再次请教!!
上次你给我一个代码,有两个问题想请教一下:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("员工管理.mdb")
%>
<%
exec="select * from a"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
</head>
<body> <form action="?action=save" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%do while not rs.eof%> <tr>
<td> <%=rs("id")%> </td>
<td> <%=rs("a")%> </td>
<td> <input name="a<%=rs("id")%>" type="text" value="<%=rs("a")%>"> </td>
<td> <input name="ID" type="checkbox" id="id" value="<%=rs("ID")%>" checked> </td>
</tr> <%
rs.movenext
loop
%>
<input name="" type="submit" value="提交">
</form>
</body>
<% if request("action")="save" then
for each id in request("id")
sql="update a set a="&request("a"&id&"")&" where id="
conn.execute(sql&id)
next
end if%>
我在“<input name="a<%=rs("id")%>" type="text" value="<%=rs("a")%>">”中输入文字就提示错误,输入数字就可以更新,再麻烦你一下,谢谢了