Re: Random sort is not random at all.....
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27231
interpreted = N
texte = At 2:08 PM 2/8/00, Nicolas Verhaeghe wrote: ... >> You can also do it sequentially. >> >> First pick those with the least shows, and then do a random among them. >> ...You just gave me an idea! All I have to do is always pick the banner with the lowest count in the [views] field. That way, those who have the fewer views at this moment, will eventually catch-up until everyone is equal. Then one lucky banner is picked for the following time through the rotation and then that banner won't be picked again until at least every other one has been picked.So the search becomes:[Search db=MRNBannerAds/ads.db &StartDateType=date &EndDateType=date &leStartDated atarq=[date] &geEndDatedatarq=[date] &asVIEWSsort=1 &max=1] On my system, this would work because I am not reporting [views] and [clicks] to anyone, so I can reset the [views] in all records to zero anytime I add a new banner.However in a system where the [views] and [clicks] are reportable, you would have to add a [rotationweight] field to determine which banner was next to be viewed. When you add a new banner, you reset the [rotationweight] to zero on all banners and maintain your [views] and [clicks] data independently. Of course the above serach would be modified to search/sort on the [rotationweight] instead of the [views] field. ___Joe____________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
At 2:08 PM 2/8/00, Nicolas Verhaeghe wrote: ... >> You can also do it sequentially. >> >> First pick those with the least shows, and then do a random among them. >> ...You just gave me an idea! All I have to do is always pick the banner with the lowest count in the [views] field. That way, those who have the fewer views at this moment, will eventually catch-up until everyone is equal. Then one lucky banner is picked for the following time through the rotation and then that banner won't be picked again until at least every other one has been picked.So the search becomes:[Search db=MRNBannerAds/ads.db &StartDateType=date &EndDateType=date &leStartDated atarq=[date] &geEndDatedatarq=[date] &asVIEWSsort=1 &max=1] On my system, this would work because I am not reporting [views] and [clicks] to anyone, so I can reset the [views] in all records to zero anytime I add a new banner.However in a system where the [views] and [clicks] are reportable, you would have to add a [rotationweight] field to determine which banner was next to be viewed. When you add a new banner, you reset the [rotationweight] to zero on all banners and maintain your [views] and [clicks] data independently. Of course the above serach would be modified to search/sort on the [rotationweight] instead of the [views] field. ___Joe____________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Joseph D'Andrea
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
New WebCatalog Version !!! (1997)
[WebDNA] Add to cart (2014)
Faxing orders in place of email (1997)
Frames and WebCat (1997)
Am I going senile? (Price recalc based on quantity) (1997)
Quickie question on the email templates (1997)
reserved characters for field names? (1998)
[ModDate] & [ModTime] ? (1997)
is sku a REQUIRED field on NT (1997)
date tag not interpreted (2000)
Problems with [Applescript] (1997)
Calendar (1997)
List Last Word (2002)
Price characteristics? (1997)
Sitebuilder (2004)
quotes and truncating? (1997)
Was cart limit-- Limits (2002)
WCS Newbie question (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Show items based on login Password (2003)