rs.eof rs.bof 一直为true
我把sql语句response.write出来直接运行都有数据,为什么这样就为空?而且好象rs确实没取到东西,因为rs.getrow也报错,请问是怎么回事?
Set conn = server.createobject( "adodb.connection ")
conn.open MM_inteheldb_STRING
Set rs = server.CreateObject( "adodb.recordset ")
sqlstr = "Select Exception_Desc.EXCEPTION_DESC,Exception_INFO.EXCEPTION_CAUSE,Exception_INFO.EXCEPTION_TIME from Exception_Desc,Exception_INFO where Exception_INFO.EXCEPTION_TIME between to_date( ' " & starttime & " ', 'YYYY-MM-DD HH24:MI:SS ') and to_date( ' " & endtime & " ', 'YYYY-MM-DD HH24:MI:SS ') and Exception_Desc.EXCEPTION_CODE = Exception_INFO.EXCEPTION_CODE "
rs.open sqlstr,conn,3,3
response.write rs.eof & "--- "& rs.bof
[解决办法]
sqlstr = "Select Exception_Desc.EXCEPTION_DESC,Exception_INFO.EXCEPTION_CAUSE,Exception_INFO.EXCEPTION_TIME from (Exception_Desc inner join Exception_INFO on Exception_Desc.EXCEPTION_CODE = Exception_INFO.EXCEPTION_CODE) where Exception_INFO.EXCEPTION_TIME between to_date( ' " & starttime & " ', 'YYYY-MM-DD HH24:MI:SS ') and to_date( ' " & endtime & " ', 'YYYY-MM-DD HH24:MI:SS ') "
