主题:求助sql语句
<%
xuanxiang=request.form("xuanxiang")
neirong=request.form("neirong")
kecheng=request.form("kecheng")
if request.form("kecheng")="" then
kecheng="jpkecheng"
end if
[color=FF0000] strsql="select * from "&kecheng&" where "&xuanxiang&" like '%"&neirong&"%' order by did_time" [/color]
set rs=db.Execute(strsql)
%>
<table border="1" width="576">
<tr align="center"><td colspan=8><a href="jpkechengchaxunjieguo.asp?kecheng=jpkecheng&xuanxiang=<%=xuanxiang%>&neirong=<%=neirong%>">精品课程</a> <a href="jpkechengchaxunjieguo.asp?kecheng=wlkecheng&xuanxxiang=<%=xuanxiang%>&neirong=<%=neirong%>">网络课程</a></td></tr>
请帮我看看这几句哪儿有错误,错误类型是:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'like '%%'' 中。谢谢
xuanxiang=request.form("xuanxiang")
neirong=request.form("neirong")
kecheng=request.form("kecheng")
if request.form("kecheng")="" then
kecheng="jpkecheng"
end if
[color=FF0000] strsql="select * from "&kecheng&" where "&xuanxiang&" like '%"&neirong&"%' order by did_time" [/color]
set rs=db.Execute(strsql)
%>
<table border="1" width="576">
<tr align="center"><td colspan=8><a href="jpkechengchaxunjieguo.asp?kecheng=jpkecheng&xuanxiang=<%=xuanxiang%>&neirong=<%=neirong%>">精品课程</a> <a href="jpkechengchaxunjieguo.asp?kecheng=wlkecheng&xuanxxiang=<%=xuanxiang%>&neirong=<%=neirong%>">网络课程</a></td></tr>
请帮我看看这几句哪儿有错误,错误类型是:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'like '%%'' 中。谢谢