RE: [WEB400] Net.data START_ROW_NUM with SELECT WHERE clause

["Metz, Zak" <Zak_Metz@xxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
http://www.ignite400.com/html/macro_examples.htm has sample code for this
under "START_ROW Processing Example."

-----Original Message-----
From: Peter Dow [mailto:maillist@dowsoftware.com]
Sent: Monday, August 19, 2002 7:47 PM
To: WEB400@midrange.com
Subject: [WEB400] Net.data START_ROW_NUM with SELECT WHERE clause


I'm trying to implement PREVIOUS|NEXT processing for search results when
particular selection criteria return a large result set.  I used the example
in the "Net.Data Reference" manual under START_ROW_NUM; pretty much the only
difference is the SELECT (I use a WHERE and an ORDER BY) and how I format
the results.  The code for handling the PREVIOUS|NEXT processing was
copied/pasted.

The results are limited to RPT_MAX_ROWS as expected, and the NEXT href is
formed correctly, however, when clicked, the result is not the next set of
records, but the 1st set.

Any ideas what I'm doing wrong?  I'm on V4R5 using the classic HTTP server.
I can post code if that would help find the problem.

tia,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 522-3214 cellular
909 793-4480 fax



_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.
NOTICE:  This E-mail may contain confidential information.  If you are not
the addressee or the intended recipient please do not read this E-mail and
please immediately delete this e-mail message and any attachments from your
workstation or network mail system. If you are the addressee or the intended
recipient and you save or print a copy of this E-mail, please place it in an
appropriate file, depending on whether confidential information is contained
in the message.