#12002/6/26 0:10:21
我想做一个单行文本框,然后后面是一个下拉菜单,可以选择是以标题查询还是以作者查询,一个递交按钮,请问我该怎么做啊
我自己对这别的ASP程序改的
<%
Select case request("ss2")
case "1"
Dim rs__temp
rs__temp = "1"
if (Request.Form("ss") <> "") then rs__temp = Request.Form("ss")
case "2"
Dim rs__temp2
rs__temp2 = "1"
if (Request.Form("ss") <> "") then rs__temp2 = Request.Form("ss")
end select
%>
<%
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_martdsn_STRING
Select case request("ss2")
case "1"
rs.Source = "SELECT mtitle, mdata ,mcontent FROM mart WHERE mtitle LIKE '%" + Replace(rs__temp, "'", "''") + "%'"
case "2"
rs.Source = "SELECT mtitle, mdata ,mcontent FROM mart WHERE mtitle LIKE '%" + Replace(rs__temp2, "'", "''") + "%'"
end select
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
%>
其中 ss 是单行文本框的 名称 ss2是下拉菜单的名称 1和2是下拉菜单value属性的两个名字,我这样做,用标题搜索,也就是value 的值为1,时搜索是正常的,但是用姓名搜索的时候总是为空。请问我该怎么办啊,多谢赐教