高考问答梦见自己抓到黄鳝:在ACCESS加入自动编号后：出现标准表达式中数据类型不匹配
来源：百度文库 编辑：高考问答 时间：2024/05/10 19:48:30
dim IID, sql, rs
IID=request("id")
if IID="" then Response.Redirect "index.asp"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("classmate.mdb")
Conn.Open
set rs=server.createobject("adodb.recordset")
sql="select * from classmate where 记录号= '" & IID & "'"
rs.Open sql,conn,1,1
IID=request("id")
if IID="" then Response.Redirect "index.asp"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("classmate.mdb")
Conn.Open
set rs=server.createobject("adodb.recordset")
sql="select * from classmate where 记录号= '" & IID & "'"
rs.Open sql,conn,1,1
记录号？