Select number of slides in slideshow

Aug 18, 2013 at 4:33 PM
I was wanting to ONLY get the top 4 news articles for the slideshow instead of all of them. How would I go about doing this?
Aug 18, 2013 at 10:28 PM
I figured it out. In the Providers/DataProviders/01.02.00.SqlDataProvider I altered the anm_showSlideshowNews.
Instead of:
SELECT * FROM anm_News Where date<GETDATE() and published = ''true'' and homeslide=''true'' ORDER BY date DESC
I added:
SELECT TOP 5 * FROM anm_News Where date<GETDATE() and published = ''true'' and homeslide=''true'' ORDER BY date DESC