小问题

lili0610931 发布于 2008-06-03 16:30， 845 次点击

DELETE FROM iXs_OnLine WHERE (NOT OL_UserSession='663272101') AND DATEDIFF("n", OL_LastTime ,'2008-6-3 16:28:11')>=40
这句代码在数据库里可以执行,但是在ASP程序中就不可以,为什么,什么地方错了.有谁知道帮我看看.

6 回复

tianyu1232008-06-03 17:11

DELETE FROM iXs_OnLine WHERE (NOT OL_UserSession='663272101') AND DATEDIFF("n", OL_LastTime ,'2008-6-3 16:28:11')>=40

双引号换为单引号试试

lili06109312008-06-03 17:43

那样ASP中就会运行不了啦

hmhz2008-06-03 18:02

DELETE iXs_OnLine WHERE OL_UserSession='663272101' AND DATEDIFF(n,OL_LastTime,'2008-6-3 16:28:11')>=40

lili06109312008-06-04 09:55

DATEDIFF(n,OL_LastTime,'2008-6-3 16:28:11')
这是一个时间差函数,不能你说的这样.

madpbpl2008-06-04 10:18

DELETE FROM iXs_OnLine WHERE (OL_UserSession<>'663272101') AND DATEDIFF(minute, OL_LastTime ,'2008-6-3 16:28:11')>=40
这样呢?

zhangyao32872008-06-04 10:38

DELETE FROM iXs_OnLine WHERE (NOT OL_UserSession='663272101') AND DATEDIFF(""n"", OL_LastTime ,'2008-6-3 16:28:11')>=40