[求助]不知道是那裡錯了,看了半天還是沒有明白過來
<%dim oskey,nian,yue,nam,hehe
oskey=request.form("odkey")
nian=request.form("nian")
yue=request.form("yue")
nam=request.form("renyuan")
hehe=nian&yue
set cn1=server.createobject("adodb.connection")
cn1.open"driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dbsx\data\dbsx.mdb")
set rss=cn1.execute("select * from '"&hehe&"' where renyuan="&nam&" and thingtitle like '%"&oskey&"%'")
if rss.eof then
response.write"<tr><td>對不起。沒有你要找的內容,請重新搜索</td></tr>"
end if
response.write"<tr><td>代辦事項標題</td><td>完成時間</td><td>完成情況</td><td>代辦人員</td></tr>"
do while (not rss.eof)
response.write"<tr><td>"&rs("thingtitle")&"</td><td>"&rs("overtime")&"</td><td>"&rs("beizhu")&"</td><td>"&rs("renyuan")&"</td></tr>"
rss.movenext
loop
rss.close
set rss=nothing
cn1.close set cn1=nothing
%>
提示無說:第10行處少 ')' ,我看了,有後半邊括號啊。這到底是怎麼回來,請高手幫忙!!!