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
 General help me questions
 Latest products
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bwalz
VP-ASP New User

USA
82 Posts

Posted - October 21 2011 :  17:11:34  Show Profile  Visit bwalz's Homepage  Reply with Quote
How can I keep a category from showing up in the latest products?

Edited by - bwalz on October 21 2011 17:11:59

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - October 22 2011 :  01:16:36  Show Profile  Reply with Quote
Edit your file shopnewproductsub.asp and find this code :

sqlstr = sqlstr & " AND (p.higherCatalogId is null)"

try to replacing the code to something like below :

sqlstr = sqlstr & " AND (p.higherCatalogId is null) AND c.categoryid=1 "

and please have a note that the 1 is the category id you want to display, you can change the 1 to any of cat id you want.

Diego.


Go to Top of Page

bwalz
VP-ASP New User

USA
82 Posts

Posted - October 24 2011 :  10:03:25  Show Profile  Visit bwalz's Homepage  Reply with Quote
Thank you for your reply. I just changed one thing and it works perfect.

I changed the = to <> to eliminate the category.

sqlstr = sqlstr & " AND (p.higherCatalogId is null) AND c.categoryid <> 14
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - October 28 2011 :  04:45:30  Show Profile  Reply with Quote
awesome bwalz and that is working logic.

Diego
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000