|
| |
|
|
morrise
Posts: 2
Joined: 10/17/2007
Status: offline
 |
Top 10 most recent items - 10/17/2007 11:13:48
Can anybody tell me how do I get one central page in FP2003 to display top 10 most recently added items?
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Top 10 most recent items - 10/17/2007 13:32:17
Hi and Welcome to OutFront.
Are you using a DRW? How about a script like:
SELECT TOP 10 * FROM myTable ORDER BY myID
If myID is an Autonumber/Identity column in your database, you should get the 10 most recent records.
Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
morrise
Posts: 2
Joined: 10/17/2007
Status: offline
|
RE: Top 10 most recent items - 10/22/2007 4:31:11
Hi
Sorry, I ment to say that I am not using a database. Just straight forward FP 2003.
Can I somehow display the last 10 most recently updated pages on one page where the info is perhaps pulled from "modified date" column?
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
