操作符丢失,帮帮忙!
d_s=request("d_s")&" "&time
d_e=request("d_e")&" "&time
sql="select * from msg where post_time<"&d_e&" and post_time>"&d_s
response.Write(sql)
set rs2=conn.execute(sql)
执行后:
select * from msg where post_time<2005-9-9 16:53:16 and post_time>2005-9-5 16:53:16
Microsoft VBScript 编译器错误
错误 '800a03f6'缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'post_time<2005-9-9 16:53:16 and post_time>2005-9-5 16:53:16' 中。
/search.asp,行55