News Articles - How do U Sort most recent first

Has anyone figured out how to sort the news article in date desending order?
Currently the news sort in ascending order.
Ken

Re: News Articles - How do U Sort most recent first

In the stored procedure 'PagedAnnouncementList' in your ClubSite Database you have to change the SQL statement from:

SELECT id, itemdate, title, description, photo FROM Announcements
WHERE (itemdate > @keydate OR
(itemdate = @keydate) AND (id > @keyid))
ORDER BY itemdate ASC, id ASC

To the following:

SELECT id, itemdate, title, description, photo FROM Announcements
WHERE (itemdate > @keydate OR
(itemdate = @keydate) AND (id > @keyid))
ORDER BY itemdate DESC, id DESC

Re: News Articles - How do U Sort most recent first

I figured it would be an order by clause.

But where do I find this. I have never worked with stored procedures before...
Have search for PagedAnnouncementList but the sql mentioned above does not appear.
So obviously I am missing something.

Re: News Articles - How do U Sort most recent first

Go to management studio open the clubstarter kit database and go to stored procedures and look for the above stored proc it has to be there. And here is how you change it with the database open right click on it in the object browser and click on ALTER, make the above changes to the last line relating to Order By and execute it in management studio. Hope this helps.

Re: News Articles - How do U Sort most recent first

Awesome - Many thanks
I was not aware that this code was here. (newbie learning [:$])

From your info, I was able to modify the sql and pull the right info.

Re: News Articles - How do U Sort most recent first

[quote user="ken240"]

Awesome - Many thanks
I was not aware that this code was here. (newbie learning [:$])

From your info, I was able to modify the sql and pull the right info.

I am glad I could be of help to you.

Re: News Articles - How do U Sort most recent first

I don't seem to be able to change this procedure in VB web Express, am I being stupid or can Express not do this?

Re: News Articles - How do U Sort most recent first

You are using the wrong tool, if you don't have it download SQL Server Express Advanced from the link below and you can use the management studio to do it. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx