I run my own customized ad management system. Is there a way to count impressions of a certain banner? What kind of code should I use? I'm using ASP/VB with Access 2000.

Thanks everybody!

Rein
webmaster: www.abc-gratis.nl

You should create a DB table for banners. Among others, create a field where you'll store information about impressions. Whenever page loads, update that table by adding one more impression. Something like: impression = impression + 1. To update table without form use Command/Stored Procedure.

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 23 Feb 2002 21:35:09

Thanks vfarvic but I not really 'into' hand coding, just a little bit of knowledge of SQL. First, I read on the Macromedia site that Access does not support stored procedures, which suprised me. Should the code be looking like this?

<% rsBanners("Impressions" = rsBanners.Fields.item("Impressions" + 1
rsProdukten.Update %>

If this is correct will implementing the above code be enough or should I also insert a from?

Thanks again!

Rein
webmaster: www.abc-gratis.nl