救命啊,星期一就要用了,这么简单的功能都没搞出来

Set rs = conn.Execute("select * from ceocio where "&sort&"=search")

这个句子是想在表ceocio中找到所有变量sort所指的列的值为变量search的行,可是总是出错,说

错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
/driver/newsearch.asp, 第 52 行

我该如何修改?
Set rs = conn.Execute("select * from ceocio order by "&sort&" desc")
可以正常运行,我就是想提出sort变量所指列的值为变量search的内容,还有别的解决方法吗?

---------------------------------------------------------------

Sql="Select * from ceocio where " & sort & "="& Search
set rs=conn.execute(Sql)

Published At
Categories with Web编程
Tagged with
comments powered by Disqus