Counting Clicks

[Keith]

Just looking for some ideas here.

What is the best way to count how many times an image has been clicked?

I have an image gallery on a site and want to count how many times each
image has been clicked (clicking pulls up the full size image in a window)
so that I know which are popular and which are not.

I though about wimply adding an extra field to the database which serves up
the image details, and incrementing a number by 1 each time a user clicks it
just before the image is served up. What are the chances of this falling
over if two people were to click the same image at the same time?

Any other ideas much appreciated.

[Keith]

"Steven Burn" <so*******@in-time.invalid> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...

You could always parse the server log's for the image's GET request?

I wanted something that I would be able to use in an admin section of the
site. So the admin people can log in and be able to see which pictures get
the most and which get the least hits.

Only automatic way I can think of is by updating the DBs.

[Steven Burn]

The DB is going to be the best way of doing it IMHO (just mentioned the site log's as an alternative)

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Keith" <@.> wrote in message news:OF**************@TK2MSFTNGP11.phx.gbl...
| "Steven Burn" <so*******@in-time.invalid> wrote in message
| news:u9**************@TK2MSFTNGP12.phx.gbl...
| > You could always parse the server log's for the image's GET request?
|
| I wanted something that I would be able to use in an admin section of the
| site. So the admin people can log in and be able to see which pictures get
| the most and which get the least hits.
|
| Only automatic way I can think of is by updating the DBs.
|
|

[Keith]

"Steven Burn" <so*******@in-time.invalid> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...

The DB is going to be the best way of doing it IMHO (just mentioned the
site log's as an alternative)

Thanks. What I suspected.

[Keith]

"Steven Burn" <so*******@in-time.invalid> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...

The DB is going to be the best way of doing it IMHO (just mentioned the
site log's as an alternative)

Drifting very slightly. I would like to use this same idea on an intranet
at work I developed.

We have a number of PDF documents launched from HTTP links. They don't open
in a popup, simply open in Adobe.

How could I catch the click and count it to the DB before it launches the
URL?

[Steven Burn]

No problem

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Keith" <@.> wrote in message news:ub**************@TK2MSFTNGP11.phx.gbl...
| "Steven Burn" <so*******@in-time.invalid> wrote in message
| news:O1**************@TK2MSFTNGP11.phx.gbl...
| > The DB is going to be the best way of doing it IMHO (just mentioned the
| > site log's as an alternative)
|
| Thanks. What I suspected.
|
|

[Curt_C [MVP]]

stream it to the client. This allows you to put in code to do whatever
http://www.darkfalz.com/1098

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message news:uO**************@TK2MSFTNGP12.phx.gbl...

Just looking for some ideas here.

What is the best way to count how many times an image has been clicked?

I have an image gallery on a site and want to count how many times each
image has been clicked (clicking pulls up the full size image in a window)
so that I know which are popular and which are not.

I though about wimply adding an extra field to the database which serves
up the image details, and incrementing a number by 1 each time a user
clicks it just before the image is served up. What are the chances of
this falling over if two people were to click the same image at the same
time?

Any other ideas much appreciated.

[Keith]

Thanks

I might be being dumb here, but:

When I place that code in an ASP document, all it does is list the raw file
contents in the browser. How can I modify it so it actually processes the
file based on it's type (ie. for a JPG/GIF drawm the image, for a PDF launch
the plugin etc.).

Thanks
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2*****************@tk2msftngp13.phx.gbl...

stream it to the client. This allows you to put in code to do whatever
http://www.darkfalz.com/1098

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:uO**************@TK2MSFTNGP12.phx.gbl...

Just looking for some ideas here.

What is the best way to count how many times an image has been clicked?

I have an image gallery on a site and want to count how many times each
image has been clicked (clicking pulls up the full size image in a
window) so that I know which are popular and which are not.

I though about wimply adding an extra field to the database which serves
up the image details, and incrementing a number by 1 each time a user
clicks it just before the image is served up. What are the chances of
this falling over if two people were to click the same image at the same
time?

Any other ideas much appreciated.

[Curt_C [MVP]]

you'll have to set the ContentType appropriately if you want the file to
"open"

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message news:Oq**************@TK2MSFTNGP12.phx.gbl...

Thanks

I might be being dumb here, but:

When I place that code in an ASP document, all it does is list the raw
file contents in the browser. How can I modify it so it actually
processes the file based on it's type (ie. for a JPG/GIF drawm the image,
for a PDF launch the plugin etc.).

Thanks
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2*****************@tk2msftngp13.phx.gbl...

stream it to the client. This allows you to put in code to do whatever
http://www.darkfalz.com/1098

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:uO**************@TK2MSFTNGP12.phx.gbl...

Just looking for some ideas here.

What is the best way to count how many times an image has been clicked?

I have an image gallery on a site and want to count how many times each
image has been clicked (clicking pulls up the full size image in a
window) so that I know which are popular and which are not.

I though about wimply adding an extra field to the database which serves
up the image details, and incrementing a number by 1 each time a user
clicks it just before the image is served up. What are the chances of
this falling over if two people were to click the same image at the same
time?

Any other ideas much appreciated.

[Keith]

Figured it out. Thanks. I thought I was being dumb :-)

How can I get this to work so that it doesn't need to be run as a new page?

Someone posted about using client-side script, but I'm faily new to ASP and
creating functions etc. is a little confusing to me right now.

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...

you'll have to set the ContentType appropriately if you want the file to
"open"

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:Oq**************@TK2MSFTNGP12.phx.gbl...

Thanks

I might be being dumb here, but:

When I place that code in an ASP document, all it does is list the raw
file contents in the browser. How can I modify it so it actually
processes the file based on it's type (ie. for a JPG/GIF drawm the image,
for a PDF launch the plugin etc.).

Thanks
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2*****************@tk2msftngp13.phx.gbl...

stream it to the client. This allows you to put in code to do whatever
http://www.darkfalz.com/1098

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:uO**************@TK2MSFTNGP12.phx.gbl...
Just looking for some ideas here.

What is the best way to count how many times an image has been clicked?

I have an image gallery on a site and want to count how many times each
image has been clicked (clicking pulls up the full size image in a
window) so that I know which are popular and which are not.

I though about wimply adding an extra field to the database which
serves up the image details, and incrementing a number by 1 each time a
user clicks it just before the image is served up. What are the
chances of this falling over if two people were to click the same image
at the same time?

Any other ideas much appreciated.

[Curt_C [MVP]]

you cant with this method, it requires the headers to be modified, which
means new page. You could still do this in the same window though..... if
that's what you mean, but yes it will require another trip to the server

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message news:OI**************@tk2msftngp13.phx.gbl...

Figured it out. Thanks. I thought I was being dumb :-)

How can I get this to work so that it doesn't need to be run as a new
page?

Someone posted about using client-side script, but I'm faily new to ASP
and creating functions etc. is a little confusing to me right now.

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...

you'll have to set the ContentType appropriately if you want the file to
"open"

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:Oq**************@TK2MSFTNGP12.phx.gbl...

Thanks

I might be being dumb here, but:

When I place that code in an ASP document, all it does is list the raw
file contents in the browser. How can I modify it so it actually
processes the file based on it's type (ie. for a JPG/GIF drawm the
image, for a PDF launch the plugin etc.).

Thanks
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2*****************@tk2msftngp13.phx.gbl...
stream it to the client. This allows you to put in code to do whatever
http://www.darkfalz.com/1098

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:uO**************@TK2MSFTNGP12.phx.gbl...
> Just looking for some ideas here.
>
> What is the best way to count how many times an image has been
> clicked?
>
> I have an image gallery on a site and want to count how many times
> each image has been clicked (clicking pulls up the full size image in
> a window) so that I know which are popular and which are not.
>
> I though about wimply adding an extra field to the database which
> serves up the image details, and incrementing a number by 1 each time
> a user clicks it just before the image is served up. What are the
> chances of this falling over if two people were to click the same
> image at the same time?
>
> Any other ideas much appreciated.
>

[Keith]

Thank you

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:ek**************@TK2MSFTNGP14.phx.gbl...

you cant with this method, it requires the headers to be modified, which
means new page. You could still do this in the same window though..... if
that's what you mean, but yes it will require another trip to the server

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:OI**************@tk2msftngp13.phx.gbl...

Figured it out. Thanks. I thought I was being dumb :-)

How can I get this to work so that it doesn't need to be run as a new
page?

Someone posted about using client-side script, but I'm faily new to ASP
and creating functions etc. is a little confusing to me right now.

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...

you'll have to set the ContentType appropriately if you want the file to
"open"

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Keith" <@.> wrote in message
news:Oq**************@TK2MSFTNGP12.phx.gbl...
Thanks

I might be being dumb here, but:

When I place that code in an ASP document, all it does is list the raw
file contents in the browser. How can I modify it so it actually
processes the file based on it's type (ie. for a JPG/GIF drawm the
image, for a PDF launch the plugin etc.).

Thanks
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2*****************@tk2msftngp13.phx.gbl...
> stream it to the client. This allows you to put in code to do whatever
> http://www.darkfalz.com/1098
>
> --
> Curt Christianson
> Site & Scripts: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>
> "Keith" <@.> wrote in message
> news:uO**************@TK2MSFTNGP12.phx.gbl...
>> Just looking for some ideas here.
>>
>> What is the best way to count how many times an image has been
>> clicked?
>>
>> I have an image gallery on a site and want to count how many times
>> each image has been clicked (clicking pulls up the full size image in
>> a window) so that I know which are popular and which are not.
>>
>> I though about wimply adding an extra field to the database which
>> serves up the image details, and incrementing a number by 1 each time
>> a user clicks it just before the image is served up. What are the
>> chances of this falling over if two people were to click the same
>> image at the same time?
>>
>> Any other ideas much appreciated.
>>
>
>

[Adrienne]

Gazing into my crystal ball I observed "Keith" <@.> writing in
news:OD**************@tk2msftngp13.phx.gbl:

"Steven Burn" <so*******@in-time.invalid> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...

The DB is going to be the best way of doing it IMHO (just mentioned
the site log's as an alternative)

Drifting very slightly. I would like to use this same idea on an
intranet at work I developed.

We have a number of PDF documents launched from HTTP links. They don't
open in a popup, simply open in Adobe.

How could I catch the click and count it to the DB before it launches
the URL?

This is what I do:

<a href="rspdf.asp?id=123">Open 123 PDF</a>

In rspdf.asp I have something like

<%
dim id
id = request.querystring("id")

update = "update table set counter = counter + 1 where id = " & id
connectionstring.Execute update
response.redirect id & ".pdf"
%>

By the way, it's also a great way to count how many times someone has
clicked on an outside link, so you can go to the owner and say "Hey, I gave
you X amount of referrals"

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[Curt_C [MVP]]

correct. If you put the file, directly on the site, and the user points
directly to it, you can't catch the click with code. Only the IIS logs will
have the hit.,

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Steven Burn" <so*******@in-time.invalid> wrote in message
news:uE**************@TK2MSFTNGP12.phx.gbl...

Unfortunately this also assumes the "clicker" doesn't use the link once
then the direct link that is shown to them, from there on (which unless
you've also allowed for that and secured the document, is whats going to
happen in most cases).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Adrienne" <ar********@sbcglobal.net> wrote in message
news:Xn****************************@207.115.63.158 ...
| Gazing into my crystal ball I observed "Keith" <@.> writing in
| news:OD**************@tk2msftngp13.phx.gbl:
|
| > "Steven Burn" <so*******@in-time.invalid> wrote in message
| > news:O1**************@TK2MSFTNGP11.phx.gbl...
| >> The DB is going to be the best way of doing it IMHO (just mentioned
| >> the site log's as an alternative)
| >
| > Drifting very slightly. I would like to use this same idea on an
| > intranet at work I developed.
| >
| > We have a number of PDF documents launched from HTTP links. They
don't
| > open in a popup, simply open in Adobe.
| >
| > How could I catch the click and count it to the DB before it launches
| > the URL?
| >
| >
|
| This is what I do:
|
| <a href="rspdf.asp?id=123">Open 123 PDF</a>
|
| In rspdf.asp I have something like
|
| <%
| dim id
| id = request.querystring("id")
|
| update = "update table set counter = counter + 1 where id = " & id
| connectionstring.Execute update
| response.redirect id & ".pdf"
| %>
|
| By the way, it's also a great way to count how many times someone has
| clicked on an outside link, so you can go to the owner and say "Hey, I
gave
| you X amount of referrals"
|
| --
| Adrienne Boswell
| http://www.cavalcade-of-coding.info
| Please respond to the group so others can share

[Curt_C [MVP]]

ok, let me rephrase, without a custom ISAPI handler you cant.....

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:u9**************@TK2MSFTNGP15.phx.gbl...

correct. If you put the file, directly on the site, and the user points
directly to it, you can't catch the click with code. Only the IIS logs
will have the hit.,

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Steven Burn" <so*******@in-time.invalid> wrote in message
news:uE**************@TK2MSFTNGP12.phx.gbl...

Unfortunately this also assumes the "clicker" doesn't use the link once
then the direct link that is shown to them, from there on (which unless
you've also allowed for that and secured the document, is whats going to
happen in most cases).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Adrienne" <ar********@sbcglobal.net> wrote in message
news:Xn****************************@207.115.63.158 ...
| Gazing into my crystal ball I observed "Keith" <@.> writing in
| news:OD**************@tk2msftngp13.phx.gbl:
|
| > "Steven Burn" <so*******@in-time.invalid> wrote in message
| > news:O1**************@TK2MSFTNGP11.phx.gbl...
| >> The DB is going to be the best way of doing it IMHO (just mentioned
| >> the site log's as an alternative)
| >
| > Drifting very slightly. I would like to use this same idea on an
| > intranet at work I developed.
| >
| > We have a number of PDF documents launched from HTTP links. They
don't
| > open in a popup, simply open in Adobe.
| >
| > How could I catch the click and count it to the DB before it launches
| > the URL?
| >
| >
|
| This is what I do:
|
| <a href="rspdf.asp?id=123">Open 123 PDF</a>
|
| In rspdf.asp I have something like
|
| <%
| dim id
| id = request.querystring("id")
|
| update = "update table set counter = counter + 1 where id = " & id
| connectionstring.Execute update
| response.redirect id & ".pdf"
| %>
|
| By the way, it's also a great way to count how many times someone has
| clicked on an outside link, so you can go to the owner and say "Hey, I
gave
| you X amount of referrals"
|
| --
| Adrienne Boswell
| http://www.cavalcade-of-coding.info
| Please respond to the group so others can share