Expanding menu code

Can you use the "Hide Category" feature?

The below code removed an item from the menu on my site. I’m using ProductCart v2.75g12a16. Without getting too deep into the matter, I would think that you might run into many other issues around your site. The menu item(s) would still appear on ‘generating a static site index’… the search results would still display items in the hidden categories.. etc etc. etc.

Find the file “inc_catsmenuA.asp” in the /pc/ folder

Go to line 109

I wanted to remove category 3 so I changed line 109 from this:

query="select idcategory,categorydesc from categories where idParentCategory=1 and idCategory>1 and iBTOhide=0 " & pcv_strTemp & " ORDER BY priority, categoryDesc ASC"

to this:

query="select idcategory,categorydesc from categories where idParentCategory=1 and idCategory<>3 and idCategory>1 and iBTOhide=0 " & pcv_strTemp & " ORDER BY priority, categoryDesc ASC"

to remove category 3 and 7 you could try:

query="select idcategory,categorydesc from categories where idParentCategory=1 and idCategory<>3 and idCategory<>7 and idCategory>1 and iBTOhide=0 " & pcv_strTemp & " ORDER BY priority, categoryDesc ASC"

you might also want to check the latest version of Product Cart. Maybe it addresses your issues? also, if any database techies can see a reason NOT to use the above code please speak up!

hope it helps

nothing