Show BreadCrumbs on showsearchresults.asp

Hello,

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"

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.

cmason,