Problem pointing to particular records - Thanks

[vivek]

probably you should implement it using database paging, see a small example
here:
[url]http://www.asp101.com/samples/db_paging.asp[/url]

Vivek

"John" <JohnNoSpam@ExplorerNet.com> wrote in message
news:#ONUkIRXDHA.2620@TK2MSFTNGP09.phx.gbl...

> Hi,
>
> I'm designing an asp catalog. I have a listing page with results of an sql
> query and a detail page for each individual item.
>
> When on the detail page, I would like to place a next and previous link

to

> the next item from the list.
>
> Any suggestions as to how to do this?
>
> I would guess that I would do another sql statement, the same as the one
> that was on my listing page and then somehow point to the record before

and

> after to come up with the next and previous record numbers. Not really

sure

> how to do this. Would anybody have an example? (using SQL 7 database)
>
> Thank you very much.
>
> John
>
>

[John Beschler]

Actually, I implemented virtually the same thing in a
pseudo newsgroup web site that I did. The way I did it was
to store the key for the previous and next message as part
of the link on the current page.

I wrote a function that would retrieve the Key of the
previous and next message from the table and then used
those values to create the links on the page.

HTH,
John

>-----Original Message-----
>probably you should implement it using database paging,

see a small example

>here:
>[url]http://www.asp101.com/samples/db_paging.asp[/url]
>
>Vivek
>
>"John" <JohnNoSpam@ExplorerNet.com> wrote in message
>news:#ONUkIRXDHA.2620@TK2MSFTNGP09.phx.gbl...

>> Hi,
>>
>> I'm designing an asp catalog. I have a listing page

with results of an sql

>> query and a detail page for each individual item.
>>
>> When on the detail page, I would like to place a next

and previous link

>to

>> the next item from the list.
>>
>> Any suggestions as to how to do this?
>>
>> I would guess that I would do another sql statement,

the same as the one

>> that was on my listing page and then somehow point to

the record before

>and

>> after to come up with the next and previous record

numbers. Not really

>sure

>> how to do this. Would anybody have an example? (using

SQL 7 database)

>>
>> Thank you very much.
>>
>> John
>>
>>

>
>
>.
>