一个价格范围的查询问题~![在线=,急急急!!]

vbnet 2005-11-21 07:23:18
有个表单提交价格是300 可产品的价格是400 我怎么才能在300到500的价格内把他查询出来呢


表单提交的价格变量是 jiage
产品的价格变量是 price
...全文
115 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
kouzhongling 2005-11-21
  • 打赏
  • 举报
 回复
else以下自己改！
kouzhongling 2005-11-21
  • 打赏
  • 举报
 回复
晕！
jiage=request("jiage")
if jiage=100 then
jiage1=300
elseif jiage=300 then
jiage1=500
elseif jiage=500 then
jiage1=700
elseif jiage=700
jiage1=1000
elseif jiage=1000
jiage1=1000
end if

select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where name like '%"&searchkey&"%' and price2<="&jiage1&"and prince2>"&jiage&" and categoryid="&categoryid,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2<="&jiage1&" and
prince2>"&jiage&" categoryid="&categoryid,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where introduce like '%"&searchkey&"%' and price2<="&jiage1&" and prince2>"&jiage&" categoryid="&categoryid,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,discount,detail,productdate from product where detail='"&searchkey&"' and price2<="&jiage1&" and prince2>"&jiage&" categoryid="&categoryid,conn,1,1
end select
else
'//分类为空。
select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where name like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where introduce like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,discount,detail,productdate from product where detail='"&searchkey&"' and price2<"&jiage,conn,1,1
end select

huguang 2005-11-21
  • 打赏
  • 举报
 回复
另外价格比较里边应该有等于的情况吧？
你自己参考吧
huguang 2005-11-21
  • 打赏
  • 举报
 回复
给个想法做参考，就是充分利用字符串连接简化代码

dim strSql
strSql = "select id,name,mark,introduce,price1,price2,discount,productdate from product"
select case action
case "1"
strSql = strSql&" where name like '%"&searchkey&"%'"
case "2"
strSql = strSql&" where mark like '%"&searchkey&"%'"
case "3"
strSql = strSql&" where introduce like '%"&searchkey&"%'"
case "4"
strSql = strSql&" where name detail '%"&searchkey&"%'"
end select

select case jiage
case "100"
strSql = strSql&" and price2>100 and price2<300"
case "300"
strSql = strSql&" and price2>300 and price2<500"
case "500"
strSql = strSql&" and price2>500 and price2<700"
case "700"
strSql = strSql&" and price2>700 and price2<1000"
case "1000"
strSql = strSql&" and price2>1000"
end select

strSql = strSql&" and categoryid="&categoryid

rs.open strSql,conn,1,1
vbnet 2005-11-21
  • 打赏
  • 举报
 回复
快崩溃了 大家帮我下吧~~~~~~~~~~~~~``
vbnet 2005-11-21
  • 打赏
  • 举报
 回复
我把查询的这样改 还是不行~
select case action
case "1"
select case jiage
case "100"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["100"] and ["300"] and categoryid="&categoryid,conn,1,1
case "300"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["300"] and ["500"] and categoryid="&categoryid,conn,1,1
case "500"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["500"] and ["700"] and categoryid="&categoryid,conn,1,1
case "700"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["700"] and ["1000"] and categoryid="&categoryid,conn,1,1
case "1000"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2>"1000" and categoryid="&categoryid,conn,1,1
end select
case "2"
select case jiage
case "100"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["100"] and ["300"] and categoryid="&categoryid,conn,1,1
case "300"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["300"] and ["500"] and categoryid="&categoryid,conn,1,1
case "500"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["500"] and ["700"] and categoryid="&categoryid,conn,1,1
case "700"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["700"] and ["1000"] and categoryid="&categoryid,conn,1,1
case "1000"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2>"1000" and categoryid="&categoryid,conn,1,1
end select
case "3"
select case jiage
case "100"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["100"] and ["300"] and categoryid="&categoryid,conn,1,1
case "300"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["300"] and ["500"] and categoryid="&categoryid,conn,1,1
case "500"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["500"] and ["700"] and categoryid="&categoryid,conn,1,1
case "700"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["700"] and ["1000"] and categoryid="&categoryid,conn,1,1
case "1000"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2>"1000" and categoryid="&categoryid,conn,1,1
end select
case "4"
select case jiage
case "100"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["100"] and ["300"] and categoryid="&categoryid,conn,1,1
case "300"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["300"] and ["500"] and categoryid="&categoryid,conn,1,1
case "500"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["500"] and ["700"] and categoryid="&categoryid,conn,1,1
case "700"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2 between ["700"] and ["1000"] and categoryid="&categoryid,conn,1,1
case "1000"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2>"1000" and categoryid="&categoryid,conn,1,1
end select
end select
else
vbnet 2005-11-21
  • 打赏
  • 举报
 回复
你好 能加下你QQ 仔细说下吗 不好意思 我的QQ:5813551
kouzhongling 2005-11-21
  • 打赏
  • 举报
 回复
应该是
if request("jiage")=300 then
jiage1=500
end if

sql: ..........where price2 >=jiage and price2<=jiage1
kouzhongling 2005-11-21
  • 打赏
  • 举报
 回复
if request("jiage")=300 then
jiage1=500
end if

sql: ..........where jiage >=jiage and jiage<=jiage1
vbnet 2005-11-21
  • 打赏
  • 举报
 回复
表单是这样的
<form name="form2" method="post" action="research.asp">
<tr BGCOLOR=ffffff> <td width="20%" style="padding-left:6px">关 健 字：</td>
<td width="80%" style="padding-left:6px"><input name="searchkey" type="text" id="searchkey"></td></tr>
<tr BGCOLOR=ffffff> <td style="padding-left:6px">查找方式：</td>
<td style="padding-left:6px"><select name="action" id="action">
<option value="1" selected>商品名称</option>
<option value="2">商品简介</option>
<option value="3">详细说明</option>
<option value="4">商品厂商</option> </select></td></tr>
<tr BGCOLOR=ffffff>
<td style="padding-left:6px">价格范围：</td>
<td style="padding-left:6px">
<select name="jiage" id="jiage">
<OPTION VALUE="1000">1000元以上</OPTION>
<OPTION VALUE="700">700-1000</OPTION>
<OPTION VALUE="500">500-700</OPTION>
<OPTION VALUE="300">300-500</OPTION>
<OPTION VALUE="100">100-300</OPTION>
</select></td></tr>


可查询的 该怎么改呢

select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where name like '%"&searchkey&"%' and price2<"&jiage&" and categoryid="&categoryid,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2<"&jiage&" and categoryid="&categoryid,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where introduce like '%"&searchkey&"%' and price2<"&jiage&" and categoryid="&categoryid,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,discount,detail,productdate from product where detail='"&searchkey&"' and price2<"&jiage&" and categoryid="&categoryid,conn,1,1
end select
else
'//分类为空。
select case action
case "1"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where name like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "2"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where mark like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "3"
rs.open "select id,name,mark,introduce,price1,price2,discount,productdate from product where introduce like '%"&searchkey&"%' and price2<"&jiage,conn,1,1
case "4"
rs.open "select id,name,mark,introduce,price1,price2,discount,detail,productdate from product where detail='"&searchkey&"' and price2<"&jiage,conn,1,1
end select
英语词根词缀记忆大全
英语词根词缀记忆大全 第一部分 通过词缀认识单词 (常用前缀一) 1､a- ① 加在单词或词根前面,表示”不,无,非” acentric 无中心的(a+centric中心的) asocial 不好社交的(a+social好社交的) amoral 非道德性的(a+...
户用储能争斗：华宝新能“稳”、正浩科技“快”、安克创新“急”
信安世纪很垃圾，劝大家别去，让你去北京培训，然后培训一个星期把你开了，给的工资也是一个范围，当初拒绝深圳16k的，选择在武汉的信安，结果搞这个恶心的东西，害得我。这个公司，连续两年签了我们学校的人，offer...
品优购-01分布式框架-Dubbox
　第一个BUSINESS，并不仅仅局限于品牌供应商、影视制作公司和图书出版商，任何的商品供应商或服务供应商都能可以成为第一个BUSINESS；第二B是B2B2C模式的电子商务企业，通过统一的经营管理对商品和服务、消费者终端...
阿里国际Lazada Buyer Tech 25届实习生！
破二本，第一次面试，一个小时多一点，面试官感觉没睡醒，但是还是问了不少问题，基本上都是我一个人在说，写在前面：前端后端的同学都需要哈，前端的技术栈我不太懂，后端的话卡Java方向~苍穹外卖，牛客论坛，
自己编辑的英语stem课程
Lesson 1 Excuse me! 对不起！ Listen to the tape then answer this question.... 听录音，然后回答问题，这是谁的手袋？ Excuse me! Yes? Is this your handbag? Pardon? Is this your handbag? ...
ASP

28,391

社区成员

357,060

社区内容

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages，是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章