Re: BannerAds example
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19542
interpreted = N
texte = On 8/21/98 4:20 AM, Kevin Mueller wrote:>I've been trying to modify the BannerAds example to use a MaxViews>field in the ads.db to stop displaying an ad when it has been viewed a>pre-set number of times.>>The example currently uses the [DATE] tag to compare with the endDate>field in the database and stops displaying the ad at the date specified.>The only problem with this is that most advertisers are used to paying>for a blocks of say, 5000 ad impressions rather than placing an ad for a>time period like 30 days.>>The only thing that has come close to working is a [HIDEIF] that looks>in the MaxViews field. But when it finds an ad that has reached its>maximum number of impressions, it displays nothing rather than another>ad that is still valid.One quick thought is to put a flag in the database that is a 0 until the max times is reached then it is clocked to a 1. Something in the clocking routine that does this:[showif [maxviews]=[math][views]+1[/math]][replace db=bannerads.db&eqskudata=[sku]]flag=1[/replace][/showif]This could actually be in your replace function instead.In the search for the ad make one of the search criteria eqflagdatarq=0 then any ads that aren't a 0 are not shown.That's one way. Robert Minor__________________________________________________________CyberMill Website Designers & Publishers8616 Joseph AveSt. Louis, MO 63144voice 314-962-4024email: webmaster@cybermill.comhttp://www.cybermill.com/__________________________________________________________We are not responsible for any misspelling or misinformationplease check with your internet provider for defects.
Associated Messages, from the most recent to the oldest:
On 8/21/98 4:20 AM, Kevin Mueller wrote:>I've been trying to modify the BannerAds example to use a MaxViews>field in the ads.db to stop displaying an ad when it has been viewed a>pre-set number of times.>>The example currently uses the
[date] tag to compare with the endDate>field in the database and stops displaying the ad at the date specified.>The only problem with this is that most advertisers are used to paying>for a blocks of say, 5000 ad impressions rather than placing an ad for a>time period like 30 days.>>The only thing that has come close to working is a
[hideif] that looks>in the MaxViews field. But when it finds an ad that has reached its>maximum number of impressions, it displays nothing rather than another>ad that is still valid.One quick thought is to put a flag in the database that is a 0 until the max times is reached then it is clocked to a 1. Something in the clocking routine that does this:[showif [maxviews]=
[math][views]+1[/math]][replace db=bannerads.db&eqskudata=[sku]]flag=1[/replace][/showif]This could actually be in your replace function instead.In the search for the ad make one of the search criteria eqflagdatarq=0 then any ads that aren't a 0 are not shown.That's one way. Robert Minor__________________________________________________________CyberMill Website Designers & Publishers8616 Joseph AveSt. Louis, MO 63144voice 314-962-4024email: webmaster@cybermill.comhttp://www.cybermill.com/__________________________________________________________We are not responsible for any misspelling or misinformationplease check with your internet provider for defects.
Bob Minor
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:
[WebDNA] table comma field delimiter bug? (2012)
Listserver problem (1997)
Re:Can this be done? (1997)
ReturnRaw and redirect (1997)
Include error (2000)
9 digit zip (2002)
Email Problems - more (2002)
Formatting dates stored in db (2003)
For you Unix gurus [OT] (2002)
Timer Values on [redirect] (1998)
Followup question re: checksum for credit cards? (1997)
WebMerchant 3.0? (1998)
WebDNA novelties (was: WebDNA Video Poker) (2007)
Textarea Breaks (2000)
2.0Beta Command Ref (can't find this instruction) (1997)
WebMerchant 1.6 and https (1997)
Follow-up to listfiles bug report ... (2003)
[sendmail] sending twice... (Update) (2003)
Emailer (WebCat2) (1997)
Calculating Shipping (1997)