% sear=request.form("searok") word=trim(request.form("word")) seartype=request.form("seartype") xileihao=trim(request("xiliehao")) if sear = "ok" and xileihao <> "" and word <> "" then if xileihao = "program1" then sql = "SELECT * FROM program where xilie = '原版程式' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program2" then sql = "SELECT * FROM program where xilie = '繪圖程式' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program3" then sql = "SELECT * FROM program where xilie = '影音程式' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program4" then sql = "SELECT * FROM program where xilie = '圖庫程式' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program5" then sql = "SELECT * FROM program where xilie = '微軟專區' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program6" then sql = "SELECT * FROM program where xilie = 'IBM 專區' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program7" then sql = "SELECT * FROM program where xilie = '程式合輯' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if if xileihao = "program8" then sql = "SELECT * FROM program where xilie = '字形程式' and "+ seartype + " like '%"& word &"%' ORDER BY bh " end if else if xileihao <> "" then if xileihao = "program1" then sql = "SELECT * FROM program where xilie = '原版程式' ORDER BY bh" end if if xileihao = "program2" then sql = "SELECT * FROM program where xilie = '繪圖程式' ORDER BY bh " end if if xileihao = "program3" then sql = "SELECT * FROM program where xilie = '影音程式' ORDER BY bh " end if if xileihao = "program4" then sql = "SELECT * FROM program where xilie = '圖庫程式' ORDER BY bh " end if if xileihao = "program5" then sql = "SELECT * FROM program where xilie = '微軟專區' ORDER BY bh " end if if xileihao = "program6" then sql = "SELECT * FROM program where xilie = 'IBM 專區' ORDER BY bh " end if if xileihao = "program7" then sql = "SELECT * FROM program where xilie = '程式合輯' ORDER BY bh " end if if xileihao = "program8" then sql = "SELECT * FROM program where xilie = '字形程式' ORDER BY bh " end if else xileihao = "program1" sql = "SELECT * FROM program where xilie = '原版程式' ORDER BY bh " end if end if 'rs.open sql, conn, 1, 1 set rs = conn.execute(sql) %>
|
||||||||||
|
||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||