on the about us page there is a "pull quote" area that I want to randomize the quotes pulled from my db. I am using a CMS to enter this into the database and a sqldatalist to display it on the page. Right now I get ALL of the quotes from the db displayed,
so basically I want to limit it to one quote displayed and randomize the quote that is displayed every time the page is refreshed or revisited. Any help would be appreciated.
wadet
Member
23 Points
12 Posts
how do I randomize quotes in the "About Us" page of the SBSK using asp.
Aug 31, 2007 09:21 PM|LINK
on the about us page there is a "pull quote" area that I want to randomize the quotes pulled from my db. I am using a CMS to enter this into the database and a sqldatalist to display it on the page. Right now I get ALL of the quotes from the db displayed, so basically I want to limit it to one quote displayed and randomize the quote that is displayed every time the page is refreshed or revisited. Any help would be appreciated.
Wade
johram
All-Star
28531 Points
3567 Posts
Re: how do I randomize quotes in the "About Us" page of the SBSK using asp.
Aug 31, 2007 09:47 PM|LINK
SELECT TOP 1 column FROM table ORDER BY NEWID()
Source: http://www.petefreitag.com/item/466.cfm
wadet
Member
23 Points
12 Posts
Re: how do I randomize quotes in the "About Us" page of the SBSK using asp.
Sep 08, 2007 08:32 PM|LINK
Thank you very much...worked like a charm