大家看看在asp里面这样有错么 - 编程论坛

#2

恒天装饰网2008-02-29 17:42

用select case也是一样的吧

#3

madpbpl2008-02-29 18:18

回复 1# 的帖子

<%
    Set rc = Server.CreateObject("ADODB.Recordset")
    select case (request("action"))
    case "办公家具"
    sql = "select * from produce where News_Class = '办公家具' "
    case "宾馆客房家具"
    sql = "select * from produce where News_Class = '宾馆客房家具' "
    case "酒店家具"
    sql = "select * from produce where News_Class = '酒店家具' "
    case "民用家具"
    sql = "select * from produce where News_Class = '民用家具' "
    case "其他产品"
    sql = "select * from produce where News_Class = '其他产品' "
    case else
    sql = "select * from produce "
    end select
    set rc = conn.Execute(sql)
%>

#4

yms1232008-02-29 18:57

楼主
VBS中选择语句是使用select case