dirt29
07-16-2006, 09:33 PM
I was wondering if someone could help me with a query...as I'm not really sure how to write it.
I'm working on a message board, and on this board I use a SQL statement to return the top 25 posts.
Here is the code.
set rs = db.execute("SELECT top 25 * FROM Messages WHERE Parent=0 AND DateDiff(d,TimeStamp, getDate())<60 ORDER BY timestamp desc, id desc")
On that page were adding a button to displayed archieved messages...I it to return the top 120 records, picking up the 26th message from the above query if that makes any sense. Can someone lend me a hand on how that might be accomplished?
Thanks in advance.
I'm working on a message board, and on this board I use a SQL statement to return the top 25 posts.
Here is the code.
set rs = db.execute("SELECT top 25 * FROM Messages WHERE Parent=0 AND DateDiff(d,TimeStamp, getDate())<60 ORDER BY timestamp desc, id desc")
On that page were adding a button to displayed archieved messages...I it to return the top 120 records, picking up the 26th message from the above query if that makes any sense. Can someone lend me a hand on how that might be accomplished?
Thanks in advance.