主题:修改问题
我要把数据库中的数据修改下,但是出现了标准数据类型不匹配,问题错在哪啊,请各位指教下
<%
dim conn
set conn=server.createobject("adodb.Connection")
conn.connectionString="Dbq=C:\Inetpub\wwwroot\canting.mdb;Driver={Microsoft Access Driver (*.mdb)}"
conn.mode=0
conn.open
dim comm
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from caipu where number='"&int(request("number"))&"'",conn,1,3 '这句是错的,我number的类型为自动编号
rs("name")=request("name")
rs("price")=request("price")
rs.update
rs.close
response.Write("修改成功!")
%>
<%
dim conn
set conn=server.createobject("adodb.Connection")
conn.connectionString="Dbq=C:\Inetpub\wwwroot\canting.mdb;Driver={Microsoft Access Driver (*.mdb)}"
conn.mode=0
conn.open
dim comm
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from caipu where number='"&int(request("number"))&"'",conn,1,3 '这句是错的,我number的类型为自动编号
rs("name")=request("name")
rs("price")=request("price")
rs.update
rs.close
response.Write("修改成功!")
%>