CodeAve.com/ASP - Impression Counter (With a db)

CodeAve.com - ASP - Read/Write

ASP
·Read/Write
·Script Writers
·Database Display
·Response Objects
·Server Variables
·Random Events
·Articles
·Miscellaneous
·Contents
·What's New?
JavaScript
CSS
HTML
Links
Mail List
Search
Sitemap

Impression Counter (With a db)

What's behind an image? Just about anything you there to be including a db. A typical image tag (<img src="any_name_you_want.jpg">) downloads an image to be processed by the browser an image tag that references an active server page (<img src="any_name_you_want.asp">) can do most anything and output an image to be displayed as the final output to the user. The following example will add one to an Access db (to count the number of impressions). The Access db will also add when the impression occurred automatically and redirect will send the user to an image to be displayed in the browser. Note the url in the output example. To view the current impression count from the Access db click here.

•Text View

•Print View

•Mail this Link

• View the Data

<%
' name of the db that will track the numbrer of impressions
accessdb="impressions.mdb"
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "insert into impressions (count) values(1)"
rs.Open sql, cn
' redirect to the image you want to display
response.redirect "images/codeave-logo.gif"
%>