关于SQL 语句的问题 郁闷!!???/
if time1="all" then
sql="select * from pnews where h_gyxx like '%"&key&"%' order by id desc"
elseif time1="one" then
sql="select * from pnews where h_gyxx like '%"&key&"%'and h_fbtime=date() order by id desc"
elseif time1="two" then
sql="select * from pnews where h_gyxx like '%"&key&"%'and datediff('d',h_fbtime,"&date()&")<3"
为什么这句总是搜索不对呢??/??
ACCESS 数据库 h_fbtime类型是日期
高手帮我看看
