大家看看在asp里面这样有错么
<% Set rc = Server.CreateObject("ADODB.Recordset")
switch (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 = '其他产品' "
default:
sql = "select * from produce "
}
set rc = conn.Execute(sql)
%>