提示：提问和回答别人的问题均可赢得积分
此问题已经被浏览20次,收藏:0次. 所属类别:[
ASP]
问题:高分求救组合查询的问题?
表t_newgoods 通过三个字段 规格 型号 品牌 组合查询，三个查询条件值可以全有也可光有一个或两个，实现的语句怎么写啊。初始页面是把所有信息都查询出来.
<%
keyword = Request.Form("itemspec") ‘型号
keyword2 = Request.Form("itemtype")’规格
keyword3 = Request.Form("band") ‘品牌
if keyword = "" and keyword2="" and band=""then
SQLString = "select d.shopid,t.name,itemname,itemspec,itemtype,bandname,itemcolor,saleprice from t_newgoods d,s_shop t "
SQLString = SQLString & " where conflag='0' and d.shopid=t.shopid"
SQLString = SQLString & " order by t.name,bandname,itemtype"
end if
剩下的组合查询的语句怎么写啊？
提问时间：
2006-12-13 16:54:43 回答次数：
(2) 提问人：
软界网友 我来回答
回答（1）
keyword = Request.Form("itemspec") ‘型号
keyword2 = Request.Form("itemtype")’规格
keyword3 = Request.Form("band") ‘品牌
if keyword = "" and keyword2="" and band=""then
SQLString = "select d.shopid,t.name,itemname,itemspec,itemtype,bandname,itemcolor,saleprice from t_newgoods d,s_shop t "
SQLString = SQLString & " where conflag='0' and d.shopid=t.shopid"
if keyword<>"" then SQLString = SQLString & " and itemspec='" & keyword & "'"
if keyword2<>"" then SQLString = SQLString & " and itemtype='" & keyword2 & "'"
if keyword3<>"" then SQLString = SQLString & " and bandname='" & keyword3 & "'"
SQLString = SQLString & " order by t.name,bandname,itemtype"
SQLString = SQLString & "0分也算高分啊"
回答（2）
上面去掉if那句
keyword = Request.Form("itemspec") ‘型号
keyword2 = Request.Form("itemtype")’规格
keyword3 = Request.Form("band") ‘品牌
SQLString = "select d.shopid,t.name,itemname,itemspec,itemtype,bandname,itemcolor,saleprice from t_newgoods d,s_shop t "
SQLString = SQLString & " where conflag='0' and d.shopid=t.shopid"
if keyword<>"" then SQLString = SQLString & " and itemspec='" & keyword & "'"
if keyword2<>"" then SQLString = SQLString & " and itemtype='" & keyword2 & "'"
if keyword3<>"" then SQLString = SQLString & " and bandname='" & keyword3 & "'"
SQLString = SQLString & " order by t.name,bandname,itemtype"
SQLString = SQLString & "0分也算高分啊"
关键字：
br,
SQLString,
itemtype,
Request,
shopid,
组合查询,
Form,
_newgoods,
itemspec,
keyword2,
bandname,
语句怎么写啊,
amp,
三个,
型号,
规格