Hi there. I'm writing a forum program ( and I'm trying to figure out how to only display 100 posts on a page, and then have archived pages, for older posts... I have no clue where to begin, can anyone help me? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Forum Archiving
- Thread starter M4TT5T3R
- Start date
Mmmmmmm a simple way to get a limited amount of records is to inlude TOP XXX in your SQL.
eg
SELECT TOP 100 * FROM MyForumFile
In fact i even have a "TOP 1" in selects that will select only 1 record (like a where on a key field), because of performance reasons.
br
Gerard
(-:
Better a known bug then a new release.
eg
SELECT TOP 100 * FROM MyForumFile
In fact i even have a "TOP 1" in selects that will select only 1 record (like a where on a key field), because of performance reasons.
br
Gerard
(-:
Better a known bug then a new release.
- Status
Similar threads
- Locked
- Question
- Locked
- Question