上面2位兄弟的答案合二为一是正确的答案。 name=Request.QueryString("name")
age=Request.QueryString("age")
addr=Request.QueryString("addr")
应该是name=Request.form("name")
age=Request.form("age")
addr=Request.form("addr") Sql= Sql & "and name like ’%"& name &"%’"Sql= Sql & "and age = ’"& age &"’" Sql= Sql & "and addr like ’%"& addr &"%’"sql语句少了空格 ,应该是Sql= Sql & " and name like ’%"& name &"%’"Sql= Sql & " and age = ’"& age &"’" Sql= Sql & " and addr like ’%"& addr &"%’"
Sql= Sql & "and name like ’%"& name &"%’"Sql= Sql & "and age = ’"& age &"’" Sql= Sql & "and addr like ’%"& addr &"%’"sql语句少了空格 ,应该是Sql= Sql & " and name like ’%"& name &"%’"Sql= Sql & " and age = ’"& age &"’" Sql= Sql & " and addr like ’%"& addr &"%’"