[Zope] ZSQL Methods and +

[Bill Anderson]

Matt Miller wrote:
> 
> I have just joined this list, so forgive me as I break my cardinal rule
> of reaidng a list for a while before posting.
> 
> I am working on a banner ad rotation system for my Zope installation.
> To that end I am using a rather simple algorithm to determine which ad
> should be shown:

While not specifically solving your problem, have you looked at the
Advertsising Banner Folder product?
I am currently working on modifiying and extending it, but am running
into some issues.
 
> Each time an ad is selected, ads not shown have their "notshown" count
> incremented by 2.
> An ad is selected whenever the number of impressions remaining PLUS its
> "notshown" is the largest in the DB.

Hmmm sounds like that number could get quite large. Is this a method you
are using for 'weighting' various banners? IOW, give certain banners a
higher base notshown count?

This is part of where I am working on in a banner product.

 

-- 
In flying I have learned that carelessness and overconfidence are 
usually far more dangerous than deliberately accepted risks. 
          -- Wilbur Wright in a letter to his father, September 1900