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

bwalz
VP-CART 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-CART Expert

Argentina
779 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-CART 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-CART Expert

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