Question

从字符串转换为 smalldatetime 数据类型时发生语法错误。

错误类型：
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
%>

各位高手，是哪里出错了？？？

Answer 1

http://zhidao.baidu.com/question/16725192.html?fr=qrl3
参考下