Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sort only sorts current page???

5 posts in General Discussion (old) Last posting was on 2000-02-22 21:36:37.0Z
Tim Nesham Posted on 2000-02-18 16:04:57.0Z
Newsgroups: sybase.public.easerver
From: "Tim Nesham" <tim.nesham@born.com>
Subject: Sort only sorts current page???
Date: Fri, 18 Feb 2000 10:04:57 -0600
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Original-NNTP-Posting-Host: 161.49.6.89
Organization: Quad/Graphics,Inc.
NNTP-Posting-Host: dns2.qgraph.com 206.158.124.2
Message-ID: <347_38ad6dad@news.qgraph.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!news.qgraph.com!161.49.6.89
Xref: forums-1-dub sybase.public.easerver:28374
Article PK: 160399

If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort is
called the current page is sorted. Great, but when ScrollNextPage is called
the data reverts back to the original sort. Apparently the sort criteria is
not maintained in Jaguar. We did a describe anf the sort definition is lost
the next time the page is loaded.

How can we have the sort order maintained after SetSort() ScrollNextPage()?

TIA,

Tim


Carson Hager[Team Sybase] Posted on 2000-02-19 16:18:34.0Z
Newsgroups: sybase.public.easerver
From: chager@dyn-data.com (Carson Hager[Team Sybase])
Subject: Re: Sort only sorts current page???
Date: Sat, 19 Feb 2000 16:18:34 GMT
Organization: Dynamic Data Solutions, Inc.
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 35
NNTP-Posting-Host: 63.86.26.206
Message-ID: <347_38aec253.1623264@forums.sybase.com>
References: <347_38ad6dad@news.qgraph.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28324
Article PK: 160356

You have to call this each time.


Carson

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training
http://www.dyn-data.com

DDS is now hiring EAServer consultants
to support its exploding EAServer business!
Please submit your resume to
hr@dyn-data.com!


On Fri, 18 Feb 2000 10:04:57 -0600, "Tim Nesham" <tim.nesham@born.com>

wrote:

>If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort is
>called the current page is sorted. Great, but when ScrollNextPage is called
>the data reverts back to the original sort. Apparently the sort criteria is
>not maintained in Jaguar. We did a describe anf the sort definition is lost
>the next time the page is loaded.
>
>How can we have the sort order maintained after SetSort() ScrollNextPage()?
>
>TIA,
>
>Tim
>
>

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training

DDS Enterprise Application Framework
Available Now as Open Source!
http://www.dyn-data.com


Tim Nesham Posted on 2000-02-22 21:36:37.0Z
Newsgroups: sybase.public.easerver
From: "Tim Nesham" <tim.nesham@born.com>
Subject: Re: Sort only sorts current page???
Date: Tue, 22 Feb 2000 15:36:37 -0600
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Original-NNTP-Posting-Host: 161.49.6.89
Organization: Quad/Graphics,Inc.
NNTP-Posting-Host: dns2.qgraph.com 206.158.124.2
Message-ID: <347_38b30169@news.qgraph.com>
References: <347_38ad6dad@news.qgraph.com> <347_38aec253.1623264@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!news.qgraph.com!161.49.6.89
Xref: forums-1-dub sybase.public.easerver:28130
Article PK: 154629

Ok, I got this to work by not using sort at all. I call modify on the
server and change the sort criteria. Then when the user changes the sort
criteria on the client browser I do a document.location.href = "string with
new sort param".
The new sort param hits the server, does a modify and the data comes back
sorted without having to re-retrieve the data. Then PageNext, etc work
naturally.

Thanks for your help.

"Carson Hager[Team Sybase]" <chager@dyn-data.com> wrote in message
news:38aec253.1623264@forums.sybase.com...
> You have to call this each time.
>
>
> Carson
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
> http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
> On Fri, 18 Feb 2000 10:04:57 -0600, "Tim Nesham" <tim.nesham@born.com>
> wrote:
>
> >If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort
is
> >called the current page is sorted. Great, but when ScrollNextPage is
called
> >the data reverts back to the original sort. Apparently the sort criteria
is
> >not maintained in Jaguar. We did a describe anf the sort definition is
lost
> >the next time the page is loaded.
> >
> >How can we have the sort order maintained after SetSort()
ScrollNextPage()?
> >
> >TIA,
> >
> >Tim
> >
> >
>
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Tim Nesham Posted on 2000-02-19 16:14:49.0Z
Newsgroups: sybase.public.easerver
From: "Tim Nesham" <tim.nesham@born.com>
Subject: Re: Sort only sorts current page???
Date: Sat, 19 Feb 2000 10:14:49 -0600
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 206.10.204.102
Message-ID: <347_ufkvSUve$GA.184@forums.sybase.com>
References: <347_38ad6dad@news.qgraph.com> <347_38aec253.1623264@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28319
Article PK: 154653

Thanks but not the best solution, I think.
For example, the first retrieve has a page of data sorted by column1.
Execute sort and page1 has a different set of data. Execute
ScrollToNextPage and the second page is sorted by the order of the original
retrieve because the server component does not remember the sort criteria.
Then, call Sort again and the second page is retrieved again. Not very
efficient. Moreover, the flashing of the data on the screen is quite
confusing to the user.

Page 1
1 Z
2 Y
3 X
Sort by col2
Page 1
4 A
5 B
6 C
ScrollToNextPage
Page2 (because server did not remember sort but did remember the page)
4 A
5 B
6 C
Sort by col2
Page2 (conveniently retrieves the same set of data because of the small
number of records
4 A
5 B
6 C


I think I have a solution, though. Put the sort criteria in a page param
and execute dwMine.Modify("datawindow.table.sort='"+psDocument.Param+"'").
Now the server component has the sort criteria BEFORE the scrolltonextpage
is executed.

Carson Hager[Team Sybase] <chager@dyn-data.com> wrote in message
news:38aec253.1623264@forums.sybase.com...
> You have to call this each time.
>
>
> Carson
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
> http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
> On Fri, 18 Feb 2000 10:04:57 -0600, "Tim Nesham" <tim.nesham@born.com>
> wrote:
>
> >If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort
is
> >called the current page is sorted. Great, but when ScrollNextPage is
called
> >the data reverts back to the original sort. Apparently the sort criteria
is
> >not maintained in Jaguar. We did a describe anf the sort definition is
lost
> >the next time the page is loaded.
> >
> >How can we have the sort order maintained after SetSort()
ScrollNextPage()?
> >
> >TIA,
> >
> >Tim
> >
> >
>
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Tim Nesham Posted on 2000-02-19 19:48:54.0Z
Newsgroups: sybase.public.easerver
From: "Tim Nesham" <tim.nesham@born.com>
Subject: Re: Sort only sorts current page???
Date: Sat, 19 Feb 2000 13:48:54 -0600
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Original-NNTP-Posting-Host: 161.49.6.89
Organization: Quad/Graphics,Inc.
NNTP-Posting-Host: dns2.qgraph.com 206.158.124.2
Message-ID: <347_38aef3a8@news.qgraph.com>
References: <347_38ad6dad@news.qgraph.com> <347_38aec253.1623264@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!news.qgraph.com!161.49.6.89
Xref: forums-1-dub sybase.public.easerver:28309
Article PK: 160343

Also, if you do a sort immediately after a ScrollToNextPage then it won't
scroll to the next page.

"Carson Hager[Team Sybase]" <chager@dyn-data.com> wrote in message
news:38aec253.1623264@forums.sybase.com...
> You have to call this each time.
>
>
> Carson
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
> http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
> On Fri, 18 Feb 2000 10:04:57 -0600, "Tim Nesham" <tim.nesham@born.com>
> wrote:
>
> >If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort
is
> >called the current page is sorted. Great, but when ScrollNextPage is
called
> >the data reverts back to the original sort. Apparently the sort criteria
is
> >not maintained in Jaguar. We did a describe anf the sort definition is
lost
> >the next time the page is loaded.
> >
> >How can we have the sort order maintained after SetSort()
ScrollNextPage()?
> >
> >TIA,
> >
> >Tim
> >
> >
>
>
> ___________________________________________________________
>
> Carson Hager
> Team Sybase
> Dynamic Data Solutions, Inc.
> Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>