Re: Banner Rotation
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28030
interpreted = N
texte = Is MostViews a field in your database ads.db? You will have to do alookup on ads.db to grab MostViews....i.e.leViewsdatarq=[lookupdb/BannerAds/ads.db&value=[SKU]&lookinfiled=sku&returnfiled=MostViews]Technical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Andy MowreySent: Thursday, February 24, 2000 1:13 PMTo: WebCatalog TalkSubject: Banner RotationHey!I've been working with the Typhoon Banner Ads demo and trying to modify itto fit my needs. I've got it to work, but want to set it up so that bannersaren't displayed after they've had a certain number of views. Can anyonetell me what I'm missing in the following code?[Search db=/BannerAds/ads.db&allhit=1&StartDateType=date&EndDateType=date&ViewsType=num&MostViewsType=num&leViewsdatarq=MostViews&leStartDatedatarq=[date]&geEndDatedatarq=[date]&SKUsort=1&SKUsdir=ra&max=1][FoundItems]
![]()
[Replacedb=/BannerAds/ads.db&eqSKUdatarq=[SKU]]Views=[math][Views]+1[/math][/Replace][/FoundItems][/Search]Views is the number of hits a graphic has receivedMostViews is the maximum number of hits a graphic can receive and still bedisplayed.I'm running WebCat 2.1.3 on Web*.Thanks in advance,andy mowrey-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant MessagingServer.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-------------------------------------------------------------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:
Is MostViews a field in your database ads.db? You will have to do alookup on ads.db to grab MostViews....i.e.leViewsdatarq=[lookupdb/BannerAds/ads.db&value=[SKU]&lookinfiled=sku&returnfiled=MostViews]Technical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Andy MowreySent: Thursday, February 24, 2000 1:13 PMTo: WebCatalog TalkSubject: Banner RotationHey!I've been working with the Typhoon Banner Ads demo and trying to modify itto fit my needs. I've got it to work, but want to set it up so that bannersaren't displayed after they've had a certain number of views. Can anyonetell me what I'm missing in the following code?[Search db=/BannerAds/ads.db&allhit=1&StartDateType=date&EndDateType=date&ViewsType=num&MostViewsType=num&leViewsdatarq=MostViews&leStartDatedatarq=[date]&geEndDatedatarq=[date]&SKUsort=1&SKUsdir=ra&max=1][founditems][url][sku][/url]>
[url][Picture][/url]>[Replacedb=/BannerAds/ads.db&eqSKUdatarq=[SKU]]Views=[math][Views]+1[/math][/Replace][/FoundItems][/Search]Views is the number of hits a graphic has receivedMostViews is the maximum number of hits a graphic can receive and still bedisplayed.I'm running WebCat 2.1.3 on Web*.Thanks in advance,andy mowrey-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant MessagingServer.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-------------------------------------------------------------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
WebDNA Support
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:
Doesn't change (WebCat 4.0) (2000)
Date Calulation (1997)
WC2.0 Memory Requirements (1997)
Emailer setup (1997)
WCS Newbie question (1997)
RE: [redirect] w/o showing args? (1999)
WebCatalog2 Feature Feedback (1996)
WebCatalog 2.0 b 15 mac (1997)
RAW=T..Strange behaviour (2000)
FYI: virus alert (1996)
I'm new be kind (1997)
Which GUI HTML editors work with WC ? (1997)
Maybe off topic but how to charge (1997)
emailer error -108 (1997)
OT: Amazon Patents (2000)
WebCatalog for Postcards ? (1997)
How fast is your server? (2002)
Error Messages Returned to User (1997)
WebCatalog NT beta 18 problem (1997)
Can't find templaes (1997)