asp的错误，大家帮我看下
<%
dim a
a=[city4]
response.Write(a)
set cx=server.CreateObject( "adodb.recordset ")
chaxun=( "select * from ' "&a& " ' where cityid between ' " & request.Form( "fwq ")& " ' and ' "&request.Form( "fwz ")& " ' ")
cx.open chaxun,conn1,1,1
%>

chaxun=( "select * from ' "&a& " ' where cityid between ' " & request.Form
' "&a& " ' 该怎么写？错在哪？

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21 '
ODBC 驱动程序不支持所需的属性。


[解决办法]
chaxun=( "select * from ' "&a& " ' where cityid between ' " & request.Form
你这句根本就不正确,当然执行不过去你应该去掉a上的单引号，在sql语句里数据表名是不需要用单引号的。