Hi all,
Just have a query about how people generally go about using ISAPI apps (or
CGI for that matter) and dealing with a number of database records and
showing only a few at a time.
For example, say the user queries the DB and has a result set of say 100
records and you only want to show 10 records at a time...
Without knowing too much about this stuff, my first thought would be to have
a hidden field or a URL parameter that holds the current record or page, and
have this passed back to the CGI or ISAPI app when the user clicks forward
or back.
Now since ISAPI and CGI apps are stateless... do developers actually rerun
the previous query and, if looking at the 3rd page say, then go forward 21
recs and start showing the next 10 records from there???
My question is, first, is this how people do it, and secondly, what if a DB
user adds or deletes records in the mean time, the records shown from the
CGI or ISAPI app could then have duplicates or miss out records etc...
Any info appreciated
Regards
Colin
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
