Hi there, I have a bound control <TABLE> on my screen. When the user edits a row on the list, I open up a window for user to edit. Then user will hit OK, and the edit window closes. The list will then refresh so that the user's change will be viewable. However, when the list refreshes, the list goes back to the very first row. If the user has scrolled through a few pages and say edits the 5th row on the 7th page (those scroll butons are also bound so all it does is calling NextPage), how can the screen go back to the 7th page automatically after it refreshes?

Thanks.
CC

I thought it's a really simple thing and yet I couldn't do it... Anyone that can help at all? Thanks

Is this a Classic ASP question??? It sounds like a .NET question.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi dparsons, definitely not .net - I haven't even used .net before. I'm using classic asp technology, no .net at work at all.

Im guessing you could send a hidden variable (using a form) when they click update, telling the opened page what page they were on, then when they press ok, the hidden variable is sent back telling the table to go to page 7.

If it uses a querystring then this method could work, because you could request.querystring("pageno") = ASPVariable
then when they press ok, its a form, that has this init, <input name="postback" type="hidden" value="1"> and <input name="pagenumber" type="hidden" value=" & ASPVariable & ">
then you could place at the top of the main tables page you could have something like this..

<% if request.form("postback")= 1 then
request.form("pagenumber") = ASPVariable2
Response.Redirect "?page=table&pageno= & ASPVariable2 & "
end if %>

Im not sure if that would work, but its an idea... im not a very advanced asp coder my self, so im not even sure if that would work to be honest, but if it does them gives a email at ,
thanks

Banksie

Hi Banksie,
Actually the asp page contains the bound table, so the table cannot be manipulated the way you mentioned I believe.

Even if I accept your parameters such as
dim a
a = request.querystring("pageno")

it is what I do with this variable a that is the problem. I have to tell the ADO record set to go to page "x" (as defined by the variable a), and I don't know if that means I have to call table.nextPage() x times or if there is simply one ADO method call that would do the trick.

The thing is if I do a for loop for x times of NextPage(), there may be some flickering on the screen - not to imagine if the user is on page 987 - then I would have to call NextPage() 987 times and I am worried the user will faint from watching all the cell refresh on the screen.....

Thanks
CC