<%
Dim Admin, UPwd,Rs,v_logdate,logSqlv_logdate = Date()Admin = Trim(Request.Form("admin"))
UPwd = Trim(Request.Form("UserPassword"))Set Rs=server.CreateObject("adodb.recordset")
logSql = "select * from Tb_Operlog where OperType='用户登录' and OperRen = '"&Admin&"' and OperRes =0 and (regtime Between '"&v_logdate&"' and '"&v_logdate&" 23:59:59')"
Response.Write(logSql)
Rs1.Open logSql,conn,1,1
%>这段代码,运行的时候,提示
select * from Tb_Operlog where OperType='用户登录' and OperRen = 'litao' and OperRes =0 and (regtime Between '2009-4-30' and '2009-4-30 23:59:59')
Microsoft VBScript 运行时错误 错误 '800a01a8' 缺少对象: '' /RootSystem/checkadmin.asp,行 (最后这个,Rs1.Open logSql,conn,1,1)
Dim Admin, UPwd,Rs,v_logdate,logSqlv_logdate = Date()Admin = Trim(Request.Form("admin"))
UPwd = Trim(Request.Form("UserPassword"))Set Rs=server.CreateObject("adodb.recordset")
logSql = "select * from Tb_Operlog where OperType='用户登录' and OperRen = '"&Admin&"' and OperRes =0 and (regtime Between '"&v_logdate&"' and '"&v_logdate&" 23:59:59')"
Response.Write(logSql)
Rs1.Open logSql,conn,1,1
%>这段代码,运行的时候,提示
select * from Tb_Operlog where OperType='用户登录' and OperRen = 'litao' and OperRes =0 and (regtime Between '2009-4-30' and '2009-4-30 23:59:59')
Microsoft VBScript 运行时错误 错误 '800a01a8' 缺少对象: '' /RootSystem/checkadmin.asp,行 (最后这个,Rs1.Open logSql,conn,1,1)
解决方案 »
- jquery高手进!
- 使用EXT中的TabPanel无法填充整个画面~~求解~~
- javascript:1.收藏此文,2.推荐本文给好友
- form里同时存在action和onsubmit会产生2次提交?
- js media播放器控制
- 调用flash问题
- 大哥求救!!!!变量名称是由字符串+递增数字该怎么写,谢谢!!
- 一个有关操作XML的权限问题,一个有关客户端和服务器端权限的问题
- file控件的浏览按钮时,如何让文件名立刻在其他text控件中显示出来
- 求救:请问如何在JavaScript中获得数据库的数据,并将该数据画出曲线图,就象是股市的K线,万分感谢!!!!!!
- checkbox中 已选中 未选中的都有 我现在要把已选中的checkbox改成未选中的同时也要根据这个把该行的数据变更
- 一段特殊的js代码
而后面用Rs1.Open
Rs1改为Rs
conn.open "打开数据库的字符串"Set Rs1=server.CreateObject("adodb.recordset") Rs1.Open logSql,conn,1,1
改成
regtime Between #2009-4-30# and #2009-4-30 23:59:59#