急,(操作符丢失)在查询表达式???

[bobovivi2008]

急,(操作符丢失)在查询表达式???
<!--#include file="conn.asp"-->
<%
dim sj
sj=now()


dim b,t,a
b=request("usr")
t=replace(b," ","")
a=split(t,",")
for i=0 to ubound(a)
set rs=server.createobject("adodb.recordset")
sql="select * from tab1 where id="&a(i)
rs.open sql,cn,3,3
rs("content")=request("content")
rs("time")=sj
kk=rs("time")
rs.update
rs.close
next
response.write " <p align=center>信息发送成功"
%>
<%

set rs=server.createobject("adodb.recordset")
sql="select * from tab1 where datediff("&"s"&","&kk&","&sj&")=0"
rs.open sql,cn,1,1
do while not rs.eof
response.write "<p align=center>"&rs("name")&":"&rs("content")&"<br>"
rs.movenext
loop
%>




Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'datediff(s,2008-9-18 15:19:16,2008-9-18 15:19:16)=0' 中。
/2.asp, 第 27 行

[sy_binbin]

sql="select * from tab1 where datediff("&"s"&",'"&kk&"','"&sj&"')=0"

[gingerkang]

sql="select * from tab1 where datediff(s,'"& kk &"','"& sj &"')=0"

[sy_binbin]

SQL数据库:sql="select * from tab1 where datediff(s,'"&kk&"','"&sj&"')=0"
ACCESS数据库:sql="select * from tab1 where datediff('s','"&kk&"','"&sj&"')=0"

[不耐烦]

sql="select * from tab1 where datediff("&"s"&","&kk&","&sj&")=0"
里的&"s"&事什么？？？？ 直接s

[gingerkang]

access:
sql="select * from tab1 where datediff('s','"& kk &"','"& sj &"')=0"

[Anlige]

sql="select * from tab1 where datediff('s',#"&kk&"#,#"&sj&"#)=0"