× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I would think it would need to be something on the SQL command itself
since it would be only for specific applications that this would want to
be done.

So, maybe asking it to "cache" the result set. But the issue of course is
we're dealing with web requests so 2 subsequent requests may be totally
different and from different users.

Bradley V. Stone
BVSTools, Inc.
[1]www.BVSTools.com
[2]www.eRPGSDK.com

Jim Essinger wrote:

I know that with STRSQL interactive, I can tell it not to refresh the data
on page up, where page down will get the next page of results. This leaves
out any new record or changes to records, but would preserver the paging.

Is there some way to do that with system settings for SQL?

Jim

On Thu, Jul 30, 2009 at 9:30 AM, Bradley V. Stone [3]<bvstone@xxxxxxxxxxxx>wrote:



For years I've written Web Applications using dynamic SQL to build result
sets.

For example, if a user wants to search a transaction history, I give them
a bunch of fields that they can use to select records, and also options
to
sort by any of the columns. Pretty simple when using dynamic SQL.

For paging I store the RRN of the result set so when they click
"previous"
or "next" I use relative positioning with my SQL. Works great.

Now in this particular case where we're querying a transaction file it
gets updated very often. Lets say a few records every minute. So lets
say they view page one, click next so they're on page 2. Then next so
they're on page 3. During this time, 10 new records were added. So
they
go back which should be page 2, but it's really (for lack of a better
term) page 2.5 since more records have been added. :) So it loses the
positioning.

So, without using persistance, temp files, etc.. anyone have any ideas
here? Or is this a case where "that's just how it will work".

Thanks!
--

Bradley V. Stone
BVSTools, Inc.
[1]www.BVSTools.com
[2]www.eRPGSDK.com

References

Visible links
1. [4]http://www.bvstools.com/
2. [5]http://www.erpgsdk.com/
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: [6]WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [7]http://lists.midrange.com/mailman/listinfo/web400
or email: [8]WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [9]http://archive.midrange.com/web400.




References

Visible links
1. http://www.bvstools.com/
2. http://www.erpgsdk.com/
3. mailto:bvstone@xxxxxxxxxxxx
4. http://www.bvstools.com/
5. http://www.erpgsdk.com/
6. mailto:WEB400@xxxxxxxxxxxx
7. http://lists.midrange.com/mailman/listinfo/web400
8. mailto:WEB400-request@xxxxxxxxxxxx
9. http://archive.midrange.com/web400

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.