dw变量默认值问题

来源：百度知道 编辑：UC知道 时间：2024/05/07 14:08:09
我用DW做了个搜索页面，在DW默认变量的值是1 这样在文本框不输入内容的时候只能按默认值来搜索了。请问把默认值改为多少，不输入内容的时候可以显示全部
代码是这样的<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "区名1"
If (Request.Form("select") <> "") Then
Recordset1__MMColParam = Request.Form("select")
End If
%>
<%
Dim Recordset1__abc
Recordset1__abc = "地址2"
If (Request.Form("select2") <> "") Then
Recordset1__abc = Request.Form("select2")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM sousuo WHERE dizi1 like '" + Replace(Recordset1__MMColParam, "'", "''") + "'and dizi2 like '%" + Replace(Recordset1__abc, "'&quo

如你的文本框是:text1,可以这样写:

text1=request.form("text1")
set rs=....
if text1="" then
sql="select * from table"
else
sql="select * from table where title='"&text1&"'"
end if
rs.open sql,conn,1,1
....