I am loosing a Var that I need to show my database orderby

First i Dim the Var

  Dim orderSTR

Then pick the order in a drop down

  <option>Builder</option>
  <option>Last Shed</option>
  <option>Year Wdrn</option>
  </select>
  <input type="submit" value="Submit" />
  </form>

Then I have a case statement to get my Var and set my Orderby clause

  strOrderBy = trim(Request.QueryString("order"))
  Select Case strOrderBy
  Case "Builder"
     strOrderBy = "builder"
     orderSTR = "Builder"
  Case "Last Shed"
     strOrderBy = "last_shed"
     orderSTR = "Last Shed"
  Case "Year Wdrn"
     strOrderBy = "yy_wdn"
     orderSTR = "Year Withdrawn"
  End Select

I then use the Var orderSTR to show the orderby

Searched for Class <%= strSearch %> sorted by <%=orderSTR%> &nbsp;&nbsp;Found <%= irecordcount %> from <%= record_size %>&nbsp;&nbsp;Records.

This all works fine on the first page, BUT on the subsequent pages the var orderSTR just dissappears although strOrderBy and everything else works

I cannot see where i could be loosing it, if its there on the first page it made it thru, so why after a loop does it dissapear

If this is not enough code I will post the whole script but it is pretty large

Thanks Topshed

Looks like you are missing to pass that as a querystring for each page. That should be where you would be missing. With the posted information, I can't think of anything else.

May be for the first page, when you submit from the form it works fine, but from there on you should be passing the needed information with the querystring to get that work. That is how it should be.

Let us know if that is where you go wrong.

_________________________
- Vijay G
Strive for Perfection

Your right of course I do pass the stuff in a querystring and somehow forgot to add this one when I added the Variable

I use

  <a href="lnclass.asp?page=<%= I %>&amp;search=<% =Server.URLEncode(strSearch) %>&amp;order=<%= Server.URLEncode(strOrderBy) %>"><%= I %></a>

I am struggling with how to include it however I assume something like
&amp;orderSTR=<% =Server.URLEncode(orderSTR) %>

but that fell over (sigh)
any assistance would be great

Topshed

Post here, what you see in the address bar as URL, when you click on that link that shows up for the <a href...> you posted in your previous post.

_________________________
- Vijay G
Strive for Perfection

Fisrt page gives me this
http://britishsteam.com/up/lnclass.a...rder=Last+Shed

but page 2 and subsequent pages show this with correct page number

http://britishsteam.com/up/lnclass.a...er=last%5Fshed

Topshed

I checked both your urls, it looks like in the first you are referring it as ORDER=LAST+SHED

But in the second, you are referring it as orderSTR=LAST+SHED

Thats what you are missing here. You got to keep it same in both places to get that work. Not sure if you are referring to the other one with in your code for other than 1st page.

_________________________
- Vijay G
Strive for Perfection