小问题(页 1) - ASP技术论坛

lili0610931 发表于 2008-6-3 16:30

小问题

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

tianyu123 发表于 2008-6-3 17:11

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

双引号换为单引号试试

lili0610931 发表于 2008-6-3 17:43

那样ASP中就会运行不了啦

hmhz 发表于 2008-6-3 18:02

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

lili0610931 发表于 2008-6-4 09:55

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

madpbpl 发表于 2008-6-4 10:18

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

zhangyao3287 发表于 2008-6-4 10:38

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

页: [1]