[求助]如何更改查询结果......急
请各位大侠帮帮忙:小弟我感激不尽!!<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"时得到不同的结果呢???
小弟急啊....请各位大侠帮帮忙....在线等...