源代码如下:(我想生成的SQL语句为sql="select * from customers where 城市='北京' or 城市='武汉'" 其中北京、武汉为复选框中所选项)
sql="select * from customers where l<>l"
sqlwherepart=""
for each cs in request.form("cs")
sqlwherepart=sqlwherepart&"or 城市= '"&cs&"'"
next
sql=sql&sqlwherepart
response.write sql
SET RS=SERVER.CREATEOBJECT("ADODB.Recordset")
RS.open sql,DBCONNECTION,1,1,1
我改为RS.open sql,DBCONNECTION,1,1,1后说odbc不支持所需属性,改另一种连接方式SET DBCONNECTION=SERVER.CREATEOBJECT("ADODB.CONNECTION")
strCnn="Driver={Microsoft Access Driver (*.mdb)};dbq="Server.MapPath("/asptest/customers.mdb")
DBCONNECTION.open strcnn又提示说strcnn那行”语句未结束“
改为:rs.open sql,DBCONNECTION,1,1
下面两个问题都解决
-----------------------------------------
SET RS=DBCONNECTION.EXECUTE(sql)
又提示我:<% For i=0 to RS.FIELDS.COUNT - 1%> 此行”对象关闭时,不允许操作。“这又是什么意思?