asp有关搜索的问题

[feifei5217319]

有没有人，有关于搜索的asp代码呀
根据多个关键字进行搜索并更新列表显示

[yangtututu]

  key1 = request("key1")
    key2 = request("key2")
    key3 = request("key3")
    key4 = request("key4")
    
    sql = "select * from table where 1 = 1"
    sql2 = "update table set "

    if key1 <> "" then
        sql = sql & " and key1 = '"&key1&"'"
        sql2 = sql2 & " key1 = '"&key1&"',"
    end if
    'key2雷同。。。

    sql = sql & " order by id desc"

[feifei5217319]

有没有人有这样的代码呀，帮帮忙吧。。

[挨踢直男]

http://www.mysuc.com/article/guanyu-ASP-fuhekexuanduotiaojianchaxun-SQL-chulidesilu.htm

[feifei5217319]

[Quote=引用 3 楼 的回复:]

http://www.mysuc.com/article/guanyu-ASP-fuhekexuanduotiaojianchaxun-SQL-chulidesilu.htm
[/Quote]

打不开呀

[001007009]

	key1 = request("key1")
	key2 = request("key2")
	key3 = request("key3")
	key4 = request("key4")
	
	sql = "select * from table where 1 = 1"
	if key1 <> "" then
		sql = sql & " and key1 = '"&key1&"'"
	end if
	'key2雷同。。。
	sql = sql & " order by id desc"

这个意思？

[feifei5217319]

[Quote=引用 5 楼 的回复:]

VBScript code

key1 = request("key1")
key2 = request("key2")
key3 = request("key3")
key4 = request("key4")

sql = "select * from table where 1 = 1"
if key1 <> "" then
……
[/Quote]

嗯嗯，差不多，但是搜索完后，必须还得更新一下列表。要怎么弄呀

[001007009]

更新列表是什么意思？

[feifei5217319]

[Quote=引用 7 楼 的回复:]

更新列表是什么意思？
[/Quote]

就是搜索后显示出来的列表

[feifei5217319]

就是搜索后显示出来结果的列表

[tyhjx]

更新列表

rs.open sqlstr,conn,1,1
 response.write("<table  ><tr>")
for each x in rs.fields
   response.write("<td>"&x.name&"</td>")   
next

 response.write("</tr>")
 do until rs.eof
 response.write("<tr>")

 for each x in rs.fields
  response.write("<td>"&x.value&"</td>")  
  next
   response.write("</tr>")
   
rs.movenext
loop
 response.write("</table>")