adrotator control using SQL.. how to know what add was displayed

[Aussie Rules]

Hi,

I have a few adrotators on a page, each bound to a sql dataset from my
database

The function works fine, but as we are going to charge for the advertising
impression and click throughs I would like to be able to capture details
about what add is displayed.

The image name the adrotator is using would be good enough, but what would
be better is a field that is in the Dataset called "ADD-ID"

I can't find any properties of the adrotator to tell me the add details
being used.

Thanks

 

[Mark Fitzpatrick]

You would actually be better to handle this within the database. If you're
using a stored procedure, you could fetch the ID of the add that is about to
be shown then record that using an insert into some sort of traffic table.
You may also want to pass more information to make this useful, such as the
IP address of the user viewing the add for geographic tracking, and maybe
even the browser information to help sort out if this ad is being seen by a
real user or by a search engine spider.

Keep in mind, the AdRotator is only meant to display the resulting ad, the
additional operations such as recording the impression must be done
seperately since it's not a function of rendering a displayed add but a
function of the data routine used to generate the displayed ad.