Iphone

I plan to put a script (javascript?) on every .html or .aspx page i have. We have some .html
and somne .aspx pages. I like to have it such that when the page is loaded, the script
is called.. and the script has function like:

- connect to a access db
- check if URL exist in the db table
- if exist, increment the count
- if doesnt exist, add an entry of url to the table with count of 1
- disconnect from db

How is this possible?

Iphone

Using third parties stats, you could download the raw data as CSV (excel), even ready for import, but that would be manually.

If you really need to do it on your end, and you find implementing "AJAX" overkilled, you can use the following:

A1. For pages that are not in ASP, you can either add manually the IMG tags, or include a javascript code which would automatically detect the current URL and generate the IMG tag.
I would not call that Ajax, as there is no real interaction, except at page loading.

A2. For pages in ASP:
in each asp file, include a small portion of code that would:
1) automatically identify the unique file name (or URL, depending on what you want)
2) printout a tag to load a (fake) image, with the name gathered in 1), and any additional parameter you whish (like unique session id, ...). In fact, the image will be a script, in ASP in your case.

B. Build an ASP script, that will be called each time the IMG tag is handled by the browser. It would parse the parameters, run the database query, and redirect to a 1x1 transparent pixel (to keep the display nice).

With this, you would be capturing almost all of your human trafic, just missing the ones with image display disabled. For the few ones, you can call a remote javascript code, that would in fact, again, be an ASP code, sending out a dummy javascript function. You can still include the IMG tag in the <noscript> section, so you would capture any human visitor having IMG OR JSCRIPT enabled... thus almost everybody.

Of course, this may require a lot of thinking depending on what you want to achieve (how to count only once a visitor who refreshed the screen for instance...).
You will find free ASP / Jscript scripts that does this, but you will probably need to fine tune them.