Sql Statement help
I can't figure out how to do this.
SQLStr="SELECT TOP 10 * FROM ORArticles WHERE Featured= 0 ORDER by MagID DESC"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQLStr,Application("DBConn"),adOpenKeyset,adLockPe ssimistic,adCmdText
This is my current statement, which works fine. I have one featured article that stays ontop or the day with a picture. But the next day when a new featured article comes in the one from the day before is knocked off the list.
What I want to to is, keep the featured article from the day before in the top 10 list. But I also need to make sure I don't choose the featured article from today, that's why I have featured= 0. So is there a way to use the date and say from yesterday or today's date -1 or something like that, or do I just need another sql satament that choose the featured article from the day before?
I hope this is explained right.
Thanks
__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason
|