[求助]如何更改查询结果......急

[复制链接]

孤独与夜缠绵

电梯直达

1^#

发表于 2010-1-14 06:19:11 | 只看该作者回帖奖励

|倒序浏览 |阅读模式

请各位大侠帮帮忙：小弟我感激不尽！！

<select name="Solution">
<option>select Solution</option>
<%
if request("reason")<> "" then
dim rs5,sql5
sql5="select distinct solution.*,item.* from Solution,item where solution.reasonid="&cint(trim(request("reason")))&" and solution.itemid=item.itemid and solution.productid="&cint(trim(request("product")))&""
set rs5=server.CreateObject("adodb.recordset")
rs5.open sql5,conn,3,3
do while not rs5.eof%>
<option value="<%=rs5("Solutionid")%>" select <%
if rs5("reasonid")=cint(trim(request("reason"))) then
response.Write("select")
titem=rs5("itemid")
end if%>><%=trim(rs5("ino"))%></option>
<% rs5.movenext
loop
end if
%>
</select>
<% if request("reason")<>"" then %>
<input name="button" type="button" onClick="window.open('checkstore.asp?item=<%=titem%>','','width=600,height=150')" value="check store">
<% end if%> </td>

请问当"ino"出来两个结果的时候，按checkstore查询，出来的都是＂ino＂最后一个值的结果，更改ino值时也是同样结果..

我要怎么样改才能在选择不同＂ino＂时得到不同的结果呢？？？

小弟急啊....请各位大侠帮帮忙....在线等...

收藏0