从字符串转换为 smalldatetime 数据类型时发生语法错误。 10
错误类型:MicrosoftOLEDBProviderforODBCDrivers(0x80040E07)[Microsoft][ODBCSQLServerDriver]...
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换为 smalldatetime 数据类型时发生语法错误。
/医药连锁店管理系统/activeuser.asp, 第 6 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)
网页:
GET /医药连锁店管理系统/index.asp
时间:
2007年6月9日, 下午 12:36:09
详细信息:
Microsoft 支持
源代码如下::
<!--#include virtual="manage/include/conn.asp"-->
<%
sessionID = session.SessionID
timeout = 5
time_temp = dateadd("n", -timeout, now())
conn.Execute ("delete from tb_Count where postdate < '" & time_temp & "'")
sql = "select sess from tb_Count where sess='" & sessionID & "'"
set rs_chk = conn.Execute (sql)
if rs_chk.eof then
sql = "insert into tb_Count (sess,postdate) values ('" & sessionID & "', '" & now() & "')"
conn.Execute (sql)
end if
rs_chk.close
set rs_chk = nothing
sql2 = "select count(sess) from tb_Count"
set rs = conn.Execute (sql2)
active_bbruser = rs(0)
rs.close
set rs = nothing
sql3 = "select * from tb_Count"
set rspredel = conn.Execute (sql3)
do until rspredel.eof
time_temp=DateDiff("n", rspredel("postdate"), now())
if time_temp > timeout then
active_bbruser = active_bbruser-1
end if
rspredel.movenext
loop
rspredel.close
set rspredel = nothing
conn.Close
set conn = nothing
if active_bbruser = 0 then
active_bbruser = 1
end if
%>
各位高手,是哪里出错了??? 展开
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换为 smalldatetime 数据类型时发生语法错误。
/医药连锁店管理系统/activeuser.asp, 第 6 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)
网页:
GET /医药连锁店管理系统/index.asp
时间:
2007年6月9日, 下午 12:36:09
详细信息:
Microsoft 支持
源代码如下::
<!--#include virtual="manage/include/conn.asp"-->
<%
sessionID = session.SessionID
timeout = 5
time_temp = dateadd("n", -timeout, now())
conn.Execute ("delete from tb_Count where postdate < '" & time_temp & "'")
sql = "select sess from tb_Count where sess='" & sessionID & "'"
set rs_chk = conn.Execute (sql)
if rs_chk.eof then
sql = "insert into tb_Count (sess,postdate) values ('" & sessionID & "', '" & now() & "')"
conn.Execute (sql)
end if
rs_chk.close
set rs_chk = nothing
sql2 = "select count(sess) from tb_Count"
set rs = conn.Execute (sql2)
active_bbruser = rs(0)
rs.close
set rs = nothing
sql3 = "select * from tb_Count"
set rspredel = conn.Execute (sql3)
do until rspredel.eof
time_temp=DateDiff("n", rspredel("postdate"), now())
if time_temp > timeout then
active_bbruser = active_bbruser-1
end if
rspredel.movenext
loop
rspredel.close
set rspredel = nothing
conn.Close
set conn = nothing
if active_bbruser = 0 then
active_bbruser = 1
end if
%>
各位高手,是哪里出错了??? 展开
1个回答
展开全部
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询