Wrong data displayed when filter value selected

[vb89]

I have an ASP application with some java script coding in it(searchResults.asp), and the stored procs are being pulled from an oracle database.

I have a page called leadersIndex.asp which basically has a bunch of filters to choose from and redirects me to the page searchResults.asp. The page leaderindex.asp has a particular filter which allows you to show data for division 1 or divison 2. The problem that I'm currently having is that when im being redirected to searchResults.asp and I choose a different value in any of the filters available on that page (filters available: numPlayer, sortOrder, or changeStat) the data on the page shows data for both div 1 and div 2.

So to clarify, on leaderIndex page I select a bunch of values in the filters available, and then for the filter that lets you select division, i choose either 1 or 2. When it redirects me to the page searchResults.asp I select a different value in one of three filters on that page(any filter: numPlayer, sortOrder, or changeStat) the page displays data for both div 1 and div 2. Any suggestions to why this is happening would be appreciated

<form>
<table width="790" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="data"><font class="title"><%If calledBy = "leadersIndex" Then%>Season Leaders<%Else%>Advanced Search<%End If%> Results</font>
</td>
</td>
<td valign="top" align="right" class="data">
 <a class="data" href="searchResults.asp?print=1&<%=Request.ServerVariables("QUERY_STRING")%>" target="_blank">Print Page</a><br>
 <%If calledBy = "leadersIndex" Then%>
 <a class="data" href="leadersIndex.asp?sea=<%=iSeason%>">Return to Index</a>
 <%Else %>
 <a class="data" href="statsSearch.asp?<%=tLinkString%>&mode=<%=tmpMode%>">Modify Search Criteria</a>
 <%End If %>
</td>
</tr>
<tr><td colspan=3><hr size=1 width=100% noshade></td></tr>
</table>

<table cellPadding="0" cellSpacing="0" border="0">
<tr><td class="data" bgcolor="white"><b>Results:</b>
<select class="data" name="numPlayers" onchange="window.location.href=this.options[this.selectedIndex].value;">
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&ord=<%=tSortOrder%>&cnt=25" <%If iNumPlayers="25" Then%>selected<%End If%>>Top 25</option>
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&ord=<%=tSortOrder%>&cnt=50" <%If iNumPlayers="50" Then%>selected<%End If%>>Top 50</option>
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&ord=<%=tSortOrder%>&cnt=100" <%If iNumPlayers="100" Then%>selected<%End If%>>Top 100</option>
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&ord=<%=tSortOrder%>&cnt=all" <%If iNumPlayers="all" Then%>selected<%End If%>>All</option>
</select>
 -
  <select class="data" name="sortorder" onchange="window.location.href=this.options[this.selectedIndex].value;">
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&cnt=<%=iNumPlayers%>&ord=ASC" <%If tSortOrder="ASC" Then%>selected<%End If%>>
		<%If bPercentage Then%>Lowest<%Else%>Least<%End If%></option>
	<option value="searchResults.asp?<%=tLinkString%>&mode=<%=tmpMode%>&cnt=<%=iNumPlayers%>&ord=DESC" <%If tSortOrder="DESC" Then%>selected<%End If%>>
		<%If bPercentage Then%>Highest<%Else%>Most<%End If%></option>
  </select>
 -
  <select name="changestat" class="data" onchange="window.location.href=this.options[this.selectedIndex].value;">
		<option value="searchResults_test.asp?<%=tLinkString%>&cnt=<%=iNumPlayers%>&mode=<%=tmpMode%>">Select a Sort Column</option>
		<%tmpArray = Split(tCategoryList, ",")
		i=0
		Do While i <= UBound(tmpArray)
  	  	%><option value="searchResults_test.asp?<%=tLinkString%>&cnt=<%=iNumPlayers%>&mode=<%=tmpArray(i)%>" <%If tmpMode = tmpArray(i) Then%>selected<%End If%>><%=tmpArray(i+1)%></option><%
  	  	i=i+2
		Loop%>
	</select>
</td></tr>

</table>
</form>

 

[tsuji]

This may be more suitable to be asked in the (classic) asp forum

http://tek-tips.com/threadminder.cfm?pid=333,

though clear mental picture of client-side result is still needed. I can try to give you some preliminary help.

What is the (server-side) variable which will be determined which division's data will be sorted after? Is it tmpMode? In that case, make sure tCategoryList is something like:
[tt] "1,division 1,2,division 2"[/tt]
or variations. In any case, you have to disclose which variable determines division data selection.

Also take good care of the uriencoding need of those tLinkString, tmpMode etc, otherwise, the query string won't be properly formed.

And then there is a typo of duplicating closing tag of td.