求教:如何修改数据库的纪录?急!!!!
cep50 2003-08-09 09:28:41 我要修改数据库的纪录,用 uploadid 字段定位指针,但没次修改都是第一条记录,请帮我解决这一问题. uploadid 字段类型:自动编号;
uploadid 在前一页中用下面语句取得。
<div><input type='hidden' name='uploadid' value=<%=rs("uploadid")%>></div>
存入数据库方法如下:
<%@ LANGUAGE="VBSCRIPT"%>
<%
Title=request("Title")
username=request("username")
Description=request("Description")
uploadid=request("uploadid")
dbpath=server.mappath("..\data\htgh.mdb")
set conn=server.createObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs=server.createobject("ADODB.Recordset")
rs.open "upload",conn,2,2
sql="select * from upload where uploadid='"&uploadid &"'"
rs("Title")=Title
rs("username")=username
rs("Description")=Description
rs.update
set conn=nothing
%>
将 rs.open sql,conn,1,3 或 rs.open sql,conn,2,2 改为 rs.open "upload",conn,2,2 或 rs.open "upload",conn,1,3 就不报错,但又是改的第一条记录。