Hi, I'm working on an e-commerce site.  We need a counter, but not just to 

count pages and track users.  This site is to be interactive with numerous 

exercises and articles to view by clicking links.  We need an ASP way of 

counting the number of times a user or users click any given link so that 

we know the number of hits for an article or exercise.  Then we were 

thinking we would want to store that information in the database 

(currently using and Access database through the prototype testing phase 

but we will ultimately have to transfer it to oracle).  An administrator 

type would review the number of hits for the various activities and figure 

out which ones are the most popular or not.



We've been using the beginning ASP 3.0 book, and I tracked down that a 

counter component exists, but I'm not clear whether this is what we need, 

and besides it seems that it is beyond the scope of that book.



Any ideas?  Anyone??



Thanks in advance.

Chris in Canada

Yaiks... this you musn't underestimate, since what you (or your boss)

want(s) is a sitetrackingtool. This you can achieve in multiple ways. The

most simple is by using the webserver logs and a program like Webtrends.

This lets you track all the pages that are requested and even (though I'm

not entirely sure) path's through the site that users follow. If you however

have a lot of data in a database and want to track how that is accessed than

maybe you want to build your own trackertool. This however is quite a big

job since it puts a lot of strain on a databaseserver. You want to track

every movement from a page to another page by a given user. Since you're

willing to use Oracle I suggest that you develop a number of stored

procedures that do the bulk of the work. In every ASP-page you develop you

have to access these SP's and pass on the necessary variables like the

sessionid of the user (to track the user), the page where he/she comes from

(referer) and where he/she now is (pagename) and the time on which this

occurred. This however is only for pagetracking. The scheme becomes more

complex when you also want to do databasetracking. Then you also have to

place loggingpoints in your code to write some trackinginformation to your

database.



All in all, first ask yourself want you or your boss want(s) to view. If

it's simple, keep it simple.. use a webtrackingtool. If you want more

information you develop your own tool.



Regards,

Richard



----- Original Message -----

From: "Christina Barbon" <chrisbarbon@h...>

To: "ASP components" <asp_components@p...>

Sent: Tuesday, March 20, 2001 12:11 AM

Subject: [asp_components] counters for links





> Hi, I'm working on an e-commerce site.  We need a counter, but not just to

> count pages and track users.  This site is to be interactive with numerous

> exercises and articles to view by clicking links.  We need an ASP way of

> counting the number of times a user or users click any given link so that

> we know the number of hits for an article or exercise.  Then we were

> thinking we would want to store that information in the database

> (currently using and Access database through the prototype testing phase

> but we will ultimately have to transfer it to oracle).  An administrator

> type would review the number of hits for the various activities and figure

> out which ones are the most popular or not.

>

> We've been using the beginning ASP 3.0 book, and I tracked down that a

> counter component exists, but I'm not clear whether this is what we need,

> and besides it seems that it is beyond the scope of that book.

>

> Any ideas?  Anyone??

>

> Thanks in advance.

> Chris in Canada

> ---

> SoftArtisans helps developers build robust, scalable Web applications!

> Excel Web reports, charts: http://www.softartisans.com/excelwriter.html

> File uploads: http://www.softartisans.com/saf.html

> Transactional file management: http://www.softartisans.com/saf1.html

> Scalability: http://www.softartisans.com/saxsession.html

> ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html




$subst('Email.Unsub')

>

Well obviously I don't know everything about your problem, but at first

glance it seems to me that you need to have 'virtual' links to your articles

rather than straightforward ones. These virtual links would actually be

links to an ASP page and would pass the 'real' URL as a parameter - then the

ASP page could increment the counter for that link before redirecting to the

real link.

Hope this is intelligible...I have had a similar (though not identical)

problem.

Andy



-----Original Message-----

From: Christina Barbon [mailto:chrisbarbon@h...]

Sent: 20 March 2001 00:12

To: ASP components

Subject: [asp_components] counters for links





Hi, I'm working on an e-commerce site.  We need a counter, but not just to 

count pages and track users.  This site is to be interactive with numerous 

exercises and articles to view by clicking links.  We need an ASP way of 

counting the number of times a user or users click any given link so that 

we know the number of hits for an article or exercise.  Then we were 

thinking we would want to store that information in the database 

(currently using and Access database through the prototype testing phase 

but we will ultimately have to transfer it to oracle).  An administrator 

type would review the number of hits for the various activities and figure 

out which ones are the most popular or not.



We've been using the beginning ASP 3.0 book, and I tracked down that a 

counter component exists, but I'm not clear whether this is what we need, 

and besides it seems that it is beyond the scope of that book.



Any ideas?  Anyone??



Thanks in advance.

Chris in Canada

Why not just update a stored counter in the dB each time the page is

requested.

Another idea could be to update an application variable,

A generic approach,  include file with sub("Linklokation",)

C



-----Original Message-----

From: Christina Barbon [mailto:chrisbarbon@h...]

Sent: 20. mars 2001 01:12

To: ASP components

Subject: [asp_components] counters for links





Hi, I'm working on an e-commerce site.  We need a counter, but not just

to

count pages and track users.  This site is to be interactive with

numerous

exercises and articles to view by clicking links.  We need an ASP way of



counting the number of times a user or users click any given link so

that

we know the number of hits for an article or exercise.  Then we were

thinking we would want to store that information in the database

(currently using and Access database through the prototype testing phase



but we will ultimately have to transfer it to oracle).  An administrator



type would review the number of hits for the various activities and

figure

out which ones are the most popular or not.



We've been using the beginning ASP 3.0 book, and I tracked down that a

counter component exists, but I'm not clear whether this is what we

need,

and besides it seems that it is beyond the scope of that book.



Any ideas?  Anyone??



Thanks in advance.

Chris in Canada

---

SoftArtisans helps developers build robust, scalable Web applications!

Excel Web reports, charts: http://www.softartisans.com/excelwriter.html

File uploads: http://www.softartisans.com/saf.html

Transactional file management: http://www.softartisans.com/saf1.html

Scalability: http://www.softartisans.com/saxsession.html

ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html



christer.hantveit@o...


$subst('Email.Unsub')