Sam
|
| Posted: 03/14/2002, 9:59 AM |
|
Does anyone know how to code the Links application in ASP to track the number of hits. ie
click through's.
|
|
|
 |
Sam M
|
| Posted: 03/14/2002, 10:24 AM |
|
Hey Sam,
Here's an excert from a banner exchange I wrote. My prog is pretty complicated, but here's the jist of it.
Sub UpdateCredits()
Dim Rubber_Hose
Rubber_Hose = "update BANNERS set Credits = Credits - 1 " & _
" WHERE Bandaid = " & Session("Bandaid")
cn.execute Rubber_Hose
Rubber_Hose = "update BANNERS set Impressions=Impressions+1 " & _
" WHERE Bandaid = " & Session("Bandaid")
cn.execute Rubber_Hose
Rubber_Hose = "update BANNERS set Credits = Credits + 1 " & _
" WHERE AutoId = '" & Session("y") & "'"
cn.execute Rubber_Hose
End Sub
Most of this was session based, for example, the session of one user would be I and the other would be U credits would change hands from I to U when U's banner is loaded on I's site, or something like that.
The other way to do it is with a query or view where a physical entry is actually inserted, and comulated by the query or view within the database.
Good luck.
|
|
|
|
Sam
|
| Posted: 03/14/2002, 10:30 AM |
|
Thanks Sam M. Exactly what I was looking for.
|
|
|
|
feha
|
| Posted: 03/14/2002, 12:53 PM |
|
How to implement this on CC with PHP?
|
|
|
|
Sam M
|
| Posted: 03/14/2002, 1:05 PM |
|
Not a clue.
I'm an ASP and CFM guy.
|
|
|
|
|
