[ic] How do I include a product count for menus

Tim Good tim.g at edsd.com
Thu Jul 27 13:10:01 EDT 2006


I would like to use the flyout menu and have the count of 
Products within parentheses next to each main category.
For example: Dairy Products (5)

I have a component written which achieves this:

[page href="search" 
         extra="class='barlink'"
 
form="fi=products&st=db&co=1&sf=prod_group&se=Dairy%20Produc
ts&op=rm&nu=0&sf=auctionend&se=today&op=auctionends&nu=0&sf=
itemstart&se=today&op=auctionstart&nu=0&su=1&ml=10&tf=catego
ry&to=x&tf=auctionend&to=x"]Dairy Products</a> <font
color="#191970"> ( [category-count category="Dairy
Products"] )</font>

The category-count tag is my doing with the query below in
it.
But I would like to have this feature be dynamic and within
The flyout menu. If I could merely add [query sql="select
count(sku) from products where ended = 0"][/query]
To somewhere in the in the menu code or menu component I
would be rock'n.

Any ideas?

Tim Good



More information about the interchange-users mailing list