Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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

4679 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
0 Item(s)
$0.00
  • Your Cart Is Empty