我在建立数据集时报错:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'a.infomodid=b.infomodid and a.memberid=c.memberid and isuse=1 and infotitle=*a* and fatcatid=1 and subcatid=1 and infomodid=1 and datediff('d',postdate,02-7-15)>0' 中。
/searchtrad.asp, 行29
我的源文件中的语句为:
sql="select a.*,b.infomodname,c.company from info a,infomod b,member c where a.infomodid=b.infomodid and a.memberid=c.memberid and isuse=1 and infotitle=*"&infotitle&"* and fatcatid="&fatcatid&" and subcatid="&subcatid&" and infomodid="&infomodid&" and datediff('d',postdate,"&postdate&")>0 order by postdate desc"
set rs=conn.execute(sql)
呜呜,究竟有什么错阿,我看不出来,请大家帮忙阿:(