At some point I'm going to write and ad redirector ASP page with click tracking. At that point I can just update the LinktoURL field and all my ads will now run through my ad redirector. The ImageURL , Height , Width and ALTText fields do just what you think they do. I don't use these at this point and really didn't need to put them in. The Weight and WeightScaled field are what drive the random selection of an ad.
Weight is just an integer weight assigned to each record.
WeightScaled is filled in by the stored procedure I'll describe below. WeightScaled has a non-unique index. In Part 2 we'll look at the banner administration ASP page. Copyright 2001 INT Media Group, Incorporated. All Rights Reserved.