以下是引用zacom在2007-11-6 22:45:14的发言:
set rss=cn1.execute("select * from '"&hehe&"' where
renyuan="&nam&" and thingtitle like '%"&oskey&"%'")
改为
set rss=col.execute "select *from" &hehe&"where renyuan="&nam&"andthingtitle like '%"&oskey
看看
set rss=cn1.execute("select * from '"&hehe&"' where
renyuan="&nam&" and thingtitle like '%"&oskey&"%'")
改为
set rss=col.execute "select *from" &hehe&"where renyuan="&nam&"andthingtitle like '%"&oskey
看看
注意一下sql语句的缩进
可能是&h的问题
set rss=cn1.execute("select * from '" & hehe & "' where renyuan="& nam &" and thingtitle like '%"& oskey &"%'")
问题应该出在红色部分,改成以上试试,或者把hehe改问试试,这里不方便调试,没有测试。