userID = Session("userID")
strsql = "select * from student where ID = '"& userID &"'"
set rs =conn.execute(strsql)
我这个语句在别的表里执行的时候一点问题都没有,偏偏到student 表里面就出问题。
最好用recordset,如:
userID = Session("userID")
strsql = "select * from student where ID = '"& userID &"'"
set rs = Server.CreateObject("Adodb.Recordset")
rs.open strsql,conn,1,1
If Not rs.eof then
response.write rs.recordcount
end if