麻烦你看一看！就几分钟！两个提交的判断，如果先使用那个另外一个就不能用了！怎么解决！谢谢！If (Request.form("seach") <> "") Then Recordset1__MMseach = Request.form("seach")Recordset1.Source = "SELECT * FROM 成绩 WHERE 学号 like \'%" + Replace(Recordset1__MMseach, "\'", "\'\'") + "%\'"elseRecordset1.Source = "SELECT * FROM 成绩"End Ifif (Request.form("name") <> "") Then Recordset1__MMname = Request.form("name")Recordset1.Source = "SELECT * FROM 成绩 WHERE 姓名 like \'%" + Replace(Recordset1__MMname, "\'", "\'\'") + "%\'"elseRecordset1.Source = "SELECT * FROM 成绩"End If
思路不对首先把 Request.form("seach") Request.form("那么")都换成Request.form("seach"),直接代搜索页面设置值Request.form("seach") 赋值1表示查询学号Request.form("seach") 赋值2表示查询姓名Request.form("seach") 赋值3表示查询...Request.form("seach") 赋值4表示查询..Request.form("seach") 赋值5表示查询..等等同样2个判断都有Recordset1.Source = "SELECT * FROM 成绩"那你就这么写<%action=Request.form("seach")select case actioncase "1"查询学好case "2"查询姓名case "3"case "4"else caseRecordset1.Source = "SELECT * FROM 成绩"end select
提问者对答案的评价：
If (Request.form("seach") <> "" and Request.form("name") <> "") Then Recordset1__MMseach = Request.form("seach")Recordset1__MMname = Request.form("name")Recordset1.Source = "SELECT * FROM 成绩 WHERE 学号 like \'%" + Replace(Recordset1__MMseach, "\'", "\'\'") + "%\' and 姓名 like \'%"+ Replace(Recordset1__MMname, "\'", "\'\'") + "%\'"elseRecordset1.Source = "SELECT * FROM 成绩"End If试试^_^ |
