Random record & date function?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3289
Printed Date: 29 March 2026 at 5:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Random record & date function?
Posted By: nicco
Subject: Random record & date function?
Date Posted: 05 June 2003 at 8:08am
|
I have a news page (news.asp) which displays ALL the records from a news db table (tblNews) which is fine. But what I want to do is display ONE random record (news item) from tblNews on my home page (default.asp) and this news item must change once daily (I'm guessing I need to use some sort of date function here?). Any ideas anyone?, I'm using SQL server and I assume IIS is running on the server. Any help would be much appreciated. |
Replies:
Posted By: MorningZ
Date Posted: 05 June 2003 at 8:17am
|
Retrun random record from SQL Server http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=173 - http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=173 ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: nicco
Date Posted: 05 June 2003 at 9:17am
|
---------------- |
---------------