Hi

I have list of products listed from a search criteria, Now I wanna show the
client TOP VIEWED LIST OF PRODUCTS or number of hits for each product. So
the page hits using the counter component will give me the hits for the
entire which has all the products.

Perhaps I could catch it in the product DETAIL page, how do I list the
number of hits for each product. Secondly I have IIS 4.0 make sure you
recomend the right component.

Thanks much!

Store the clicks for each product in say product table. When user clicks on
the product detail page, update this count -- use a stored proc/method to do
this.

There are multiple ways of doing this, but my generic statement is because
of lack of details on your application. Hope that helps.

--
Manohar Kamath
Editor, .netBooks
www.dotnetbooks.com


"Girish" <girishkiss@yahoo.com> wrote in message
news:Owgqwjq6DHA.1636@TK2MSFTNGP12.phx.gbl...[color=blue]
> Hi
>
> I have list of products listed from a search criteria, Now I wanna show[/color]
the[color=blue]
> client TOP VIEWED LIST OF PRODUCTS or number of hits for each product. So
> the page hits using the counter component will give me the hits for the
> entire which has all the products.
>
> Perhaps I could catch it in the product DETAIL page, how do I list the
> number of hits for each product. Secondly I have IIS 4.0 make sure you
> recomend the right component.
>
> Thanks much!
>
>[/color]

I got the idea of updating once you get detail page by setting an increment
counter (say x) like Update table name set x=x+1 where
productid=request(id), how do I store the clicks? I guess I need to insert
one record for each unique product setting x = null or zero.... right?

Please tell me how would you do it, feel free to ask me specifics.

Appreciate it.



"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:%23E4gLAr6DHA.2472@TK2MSFTNGP10.phx.gbl...[color=blue]
> Store the clicks for each product in say product table. When user clicks[/color]
on[color=blue]
> the product detail page, update this count -- use a stored proc/method to[/color]
do[color=blue]
> this.
>
> There are multiple ways of doing this, but my generic statement is because
> of lack of details on your application. Hope that helps.
>
> --
> Manohar Kamath
> Editor, .netBooks
> www.dotnetbooks.com
>
>
> "Girish" <girishkiss@yahoo.com> wrote in message
> news:Owgqwjq6DHA.1636@TK2MSFTNGP12.phx.gbl...[color=green]
> > Hi
> >
> > I have list of products listed from a search criteria, Now I wanna show[/color]
> the[color=green]
> > client TOP VIEWED LIST OF PRODUCTS or number of hits for each product.[/color][/color]
So[color=blue][color=green]
> > the page hits using the counter component will give me the hits for the
> > entire which has all the products.
> >
> > Perhaps I could catch it in the product DETAIL page, how do I list the
> > number of hits for each product. Secondly I have IIS 4.0 make sure you
> > recomend the right component.
> >
> > Thanks much!
> >
> >[/color]
>
>[/color]