Snitz Forums 2000 - Sorting display for David Rhode's Portal

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Sorting display for David Rhode's Portal

New Topic

Topic Locked

Printer Friendly

Author

Topic

Chris Yew
Junior Member

134 Posts

Posted - 03 June 2003 : 01:10:00

Hi David,
I've installed your mod sometime back on my snitz 3.4.03 and I believed you still remember. It's working well too.

I noticed that when I keyed in the last content (for example under the category Events), it will always displayed last at the bottom of the list.

You may see it at your own portal as well under the Upcoming Events; The South Coast Meet on June 29 is located at the bottom. Is there any way to sort it such that the last input in the posting will appear at the top.
http://www.uk-mkivs.net/forum/uk_home.asp?ContentID=31&ContentCategoryID=4

This is useful if we are displaying only 2 or 3 of the listings and it will always be showing the old content instead of the latest content in the portal default page.

Here's my portal site;
http://www.bettaclub.org.sg/forum/portal.asp

Oh, btw can your portal site work with the content display mod?

Thank you.
Chris Yew

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 03 June 2003 : 06:40:56

Chris,
It orders the content by the date it was last edited, line 161

strSql = strSql & "ORDER BY " & strTablePrefix & "CMS_CONTENT.CONT_LAST_EDIT ASC"

change this to

strSql = strSql & "ORDER BY " & strTablePrefix & "CMS_CONTENT.CONT_LAST_EDIT DESC"

The UK MkIVs Forum

Chris Yew
Junior Member

134 Posts

Posted - 03 June 2003 : 08:58:04

Thanks once again, it's done!

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.21 seconds.