VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Latestnews box not showing the latest entries
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

doble_motorcycles
Starting Member

17 Posts

Posted - January 31 2010 :  23:37:40  Show Profile  Visit doble_motorcycles's Homepage  Reply with Quote
Hi all

My Latest News side box is only showing the my first 3 entries, rather then the latest 3. The News Highlights box in the middle of the page is displaying the items correctly.

I would like the latest news box to show the latest 3 items, starting with the newest.

See what I mean here: http://www.dobledirect.co.uk/

doble_motorcycles
Starting Member

17 Posts

Posted - February 04 2010 :  18:31:38  Show Profile  Visit doble_motorcycles's Homepage  Reply with Quote
Again, I hate to bump my own post, but its been a while and I would love a fix for this.

I assumed it would be a simple edit of the SQL statement to order the items by date DESC rather than ASC but I can't see where I would edit this.

Any ideas?

Thanks in advance

Edited by - doble_motorcycles on February 04 2010 18:33:13
Go to Top of Page

support
Administrator

4266 Posts

Posted - February 04 2010 :  18:43:55  Show Profile  Visit support's Homepage  Reply with Quote
Hi there

Can you post this in our helpdesk and it will go directly to the development team to look into for you.

https://helpdesk.vpasp.com

Thanks
Cam

VPASP Support
Go to Top of Page

doble_motorcycles
Starting Member

17 Posts

Posted - February 08 2010 :  13:41:56  Show Profile  Visit doble_motorcycles's Homepage  Reply with Quote
For anyone else that may have this problem, here is the solution I was provided with:

Please do the following changes to solve your issue related to Side News / Blog Box:

1. Open shopcms.asp

2. Locate around line 222:within routine sub ShowNewsBox

3. Below
strsql=strsql & getnewscustomersql(customerid,"news")

4. Add
strsql=strsql & " order by news.cdateadded desc"

5. Locate around line 744:within routine sub ShowBlogsBox

6. Below
strsql=strsql & getnewscustomersql(customerid,"blogs")

7. Add
strsql=strsql & " order by blogs.cdateadded desc"

8. Save and test.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000