ASP菜鸟问题
小弟在做一个程序时,需要用到asp做几个网页以方便试验。
但是却遇到意想不到的问题。
按照名字查询某个人的信息时,第一次成功显示,如果立即回退到前页,重新查询,则会报错:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Provider 错误 '80004005'
未指定的错误
/patientquery/namequery.asp,行3
如果等待一会儿再查询,则正常。不知什么原因?(为了简单,我用的access数据库,ODBC连接,数据源名称设定为MIDPDB)
asp文件的全文如下,各位大虾帮忙。
<%
Set patientDB = Server.CreateObject("ADODB.Connection")
patientDB.Open "MIDPDB"
querySQL = "SELECT * FROM patients where name='" & request("txtName") & "'"
set records = Server.CreateObject("ADODB.Recordset")
records.Open querySQL,patientDB
if records.EOF then
Response.Write "Not found"
else
Response.Write "ID:"
Response.Write records("ID")
Response.Write "\n"
Response.Write "Name:"
Response.Write records("name")
Response.Write "\n"
Response.Write "Age:"
Response.Write records("age")
Response.Write "\n"
Response.Write "Disease:"
Response.Write records("disease")
Response.Write "\n"
Response.Write "Address:"
Response.Write records("address")
end if
records.Close
set records = nothing
patientDB.Close
set patientDB = nothing
%>