Sorting

Hi,
I'm not sure what exactly is happening here. Here is what you can do to investigate this problem: open /include/..._variables.asp file and set vDedug variable to true.
With this option enabled each SQL query will be printed at the top of page. You can copy and paste queries from the first and from the second page here.
Sergey Kornilov

I...Here is the query before showing all records:

SELECT [StatusID], [StatusDate], [StatusTitle], [StatusDesc], [DisplayFlag], [IStatusDesc], [IDisplayFlag] From [dbo].[tblNetworkStatus] where statusdate >= dateadd(dd,-30,getdate()) or statusdate is null order by [StatusDate] desc
II...Then I click the StatusDate column and resort:

SELECT [StatusID], [StatusDate], [StatusTitle], [StatusDesc], [DisplayFlag], [IStatusDesc], [IDisplayFlag] From [dbo].[tblNetworkStatus] where statusdate >= dateadd(dd,-30,getdate()) or statusdate is null order by StatusDate asc
III...Then I click go to page 2:

SELECT [StatusID], [StatusDate], [StatusTitle], [StatusDesc], [DisplayFlag], [IStatusDesc], [IDisplayFlag] From [dbo].[tblNetworkStatus] where statusdate >= dateadd(dd,-30,getdate()) or statusdate is null order by [StatusDate] desc
Notice how the query was reset in step 3. Why wasn't my asc sort kept from step 2?

I have a request concerning the sort order to.
I would like a sort order (orderby) and if there is a search set up, to maintane active after returning from the edit-page.
Is it possibly?
Regards

pskjo

Hi,
please download latest update here where this problem fixed:

http://www.xlinesoft.com/files/asprun23a.exe
Best regards,

Sergey Kornilov