<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("keyword") <> "") Then
Recordset1__MMColParam = Request.QueryString("keyword")
End If
%>
<%
Dim dbser'加了个变量，
Dim Recordset1
Dim Recordset1_numRows
dbser=request.querystring("select") '接受select的值，直接作为表单名
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cnhds_STRING
Recordset1.Source = "SELECT content, di, time, topic FROM
dbser WHERE ((topic LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%')or(content LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%')) ORDER BY di DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
无标题文档 <%= dbser %>
’变量付值正常
<%=(Recordset1.Fields.Item("di").value)%> <%=(Recordset1.Fields.Item("topic").value)%>
<%=(Recordset1.Fields.Item("content").value)%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
一个查询的例子，可以正常查询，只是加了dbser变量作为数据表名后就出错，
:confused:
Recordset1.Source = "SELECT content, di, time, topic FROM
dbser WHERE ((topic LIKE '%" + Replace==========里面不能付变量吗？
