Customizing ProductCart - Show BreadCrumbs on showsearchresults.asp

Print Page | Close Window

Show BreadCrumbs on showsearchresults.asp

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=1690
Printed Date: 23-April-2025 at 12:49pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Show BreadCrumbs on showsearchresults.asp

Posted By: bkats
Subject: Show BreadCrumbs on showsearchresults.asp
Date Posted: 05-June-2008 at 10:49pm

Hello,

After performing a search, the results are displayed with a section at the top where you can narrow the search by category. We would like to display the entire category tree due to the fact we have many categories with the same name under different parent categories.

To give an example we have 2 categories as follows:

ROOT>Men's>Jackets

and

ROOT>Women's>Jackets

So when a search is performed the user may see 2 links name "Jackets" in the section at the top where they can narrow the search. However, as it is, they don't know which one to click on depending if they are looking for a Men's or Women's Jacket.

We would like to have it display as follows in the section at the top where they can narrow the search:

Men's>Jackets

Women's>Jackets

rather than:

Jackets

I hope this is making sense.

Can anyone out there help us?

Thank you!

Replies:

Posted By: Hamish
Date Posted: 06-June-2008 at 3:49am

Hi,
A good starting point may be the code for dynamic category navigation from the EA website.
I haven't looked at it in a while, but I reckon it would be fairly straight forward to extract a list of the "breadcrumbs" for each category which could then be used as you wish.
There may already be suitable code in the search for adapting as well.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: cmason
Date Posted: 17-July-2008 at 5:12pm

It's not exactly straightforward because the category display in showsearchresults.asp is very different than viewcategories.asp. Plus there are two queries involved on showsearchresults.asp, one for the details and one for the scrolling category list in the JavaScript window. We've removed the JavaScript scrolling window code so I can't give you line numbers. Also, we've standardized on linking products to categories only on tier 3 categories so this idea may not work for everyone.

Below is what I think should work but every time I add "categories.idParentCategory" to the first step it slows the query down so much it's unusable. I can't figure out why adding a field to the select is having that effect. Can anyone spot where I'm stinking thinking?

1. Go to inc_srcPrdQuery.asp and find the line "SELECT "& pcv_strLimitPhrase &" COUNT(categories.idcategory) AS ProductCount, categories.idcategory, categories.categoryDesc " and add categories.idParent so it looks like "SELECT "& pcv_strLimitPhrase &" COUNT(categories.idcategory) AS ProductCount, categories.idcategory, categories.categoryDesc, categories.idParentCategory "

2. Next go to inc_srcPrdsCAT.asp page find "<%Do while not rsCAT.eof" and under "tmp_CatName=rsCAT("categoryDesc")" add
cw_ParentID = rsCat("idParentCategory")
cwSQL="SELECT categoryDesc FROM categories WHERE (idCategory = "&cw_ParentID&""
set rsParent=conntemp.execute(cwSQL)
cw_ParentDesc = rsParent("categoryDesc")

Then find the link "<li><a href="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>';document.ajaxSearch.submit();" <%if scStoreUseToolTip="1" then%>onmouseover="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>'; sav_callxml='1'; runXML('cat_<%=tmp_CatID%>');" onmouseout="javascript: sav_callxml=''; hidetip();"<%end if%>><%=tmp_CatName%></a> (<%=tmp_CatCount & tmp_CatCountMessage%>)</li>"

and add the parent description by changing it to

<li><a href="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>';document.ajaxSearch.submit();" <%if scStoreUseToolTip="1" then%>onmouseover="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>'; sav_callxml='1'; runXML('cat_<%=tmp_CatID%>');" onmouseout="javascript: sav_callxml=''; hidetip();"<%end if%>><%=cwParentDesc%> / <%=tmp_CatName%></a> (<%=tmp_CatCount & tmp_CatCountMessage%>)</li>

then find "set rsCAT=nothing" and above it put "set rsParent=nothing"

Posted By: cmason
Date Posted: 17-July-2008 at 6:56pm

Small oops the link s/b cw_ParentDesc not cwParentDesc

Posted By: cmason
Date Posted: 18-July-2008 at 12:05am

Figured it out. the first query didn't have any error catching so it was trying to continue on an that's why it timed out. That query is a Group By query so in inc_srcPrdQuery.asp "query=query& "GROUP BY categories.idcategory, categories.categoryDesc" needs to have the idParentCategory added to become query=query& "GROUP BY categories.idcategory,categories.categoryDesc,categories.idParentCategory"

The other problem was the typo mentioned previously so the li in s/b
<li><a href="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>';document.ajaxSearch.submit();" <%if scStoreUseToolTip="1" then%>onmouseover="javascript:document.ajaxSearch.idcategory.value='<%=tmp_CatID%>'; sav_callxml='1'; runXML('cat_<%=tmp_CatID%>');" onmouseout="javascript: sav_callxml=''; hidetip();"<%end if%>><%=cw_ParentDesc%> / <%=tmp_CatName%></a> (<%=tmp_CatCount & tmp_CatCountMessage%>)</li>

This will give an output of "Parent Description / Category Description" as the link.

Posted By: cmason
Date Posted: 18-July-2008 at 1:11am

Note: to keep the categories grouped together under their parent category.

In inc_srcPrdQuery.asp near the bottom of the page add idParentCategory first in the Order By. It won't be alpha order but at least all the categories will appear under the same parent.

query=query& "ORDER BY categories.idParentCategory,categories.categoryDesc; "

Posted By: angel
Date Posted: 23-August-2008 at 12:19pm

cmason,

Can you please summarize your thoughts so that I can have the same?

-------------
Sultan Arefin
www.chorka.com

Posted By: cmason
Date Posted: 23-August-2008 at 12:33pm

1. In "inc_srcPrdQuery.asp" add "categories.idParentCategory" so the rsCat query results include the id for the parent category.

2. In "inc_srcPrdsCAT.asp" use the idParentCategory from rsCat to pull the parent category's description and add it to the link that displays the categories.

It's pretty simple, once you know where the code is located.