Question

帮检查ASP读取数据库代码

<!--#include file="conn.asp"-->
<%
Dim rs
Set rs=server.CreateObject("ADODB.recordset")
Dim strSQL
strSQL="select * from T where m_id=1"
rs.Open strSQL,objConnection,3,1
a_gjl=rs("m_gjl")
response.write "&a_gjl="&a_gjl&"&"
rs.close
Set rs=Nothing
objConnection.close
Set objConnection=Nothing
response.write "&ok=1&"
%>

为什么还是加载失败？
是不是读的那里有错误？

Answer 1

<!--#include file="conn.asp"-->
<%
Dim rs
Set rs=server.CreateObject("ADODB.recordset")
Dim strSQL
strSQL="select * from T where m_id=1"
rs.Open strSQL,objConnection,3,1
if not rs.eof then
a_gjl=rs("m_gjl")
response.write "&a_gjl="&a_gjl&"&"
else
response.write("没有数据")
end if
rs.close
Set rs=Nothing
objConnection.close
Set objConnection=Nothing
response.write "&ok=1&"
%>
注意，记录集提取数据的时候，要判断一下，记录集是否是空的！！

Answer 2

response.write "&a_gjl="&a_gjl&"&"
是什么啊？是不是应该写
response.write ("a_gjl="&a_gjl&"")
或
response.write "a_gjl="&a_gjl&""