Last post Sep 08, 2007 04:32 PM by wadet
Aug 31, 2007 05:21 PM|wadet|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.
Aug 31, 2007 05:47 PM|johram|LINK
SELECT TOP 1 column FROM table ORDER BY NEWID()
Sep 08, 2007 04:32 PM|wadet|LINK
Thank you very much...worked like a charm