Re: two unique banners on one page
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13364
interpreted = N
texte = At 11:42 AM 9/9/97 -0900, you wrote:>>I think Grant meant putting half the banners in one db and the rest>>in the other db, so the same two could never appear on the same page.>>But I think there's a better way ...>>The problem is similar sku'ed pairs always showing up together. What >we'll do is just assign the found sku to a variable on the first search >then find all records in the second search that are NOT equal to the >first found sku. This will stop any duplicative banners showing up as >well as stop the pairs that are always showing up together. We just have >to seed identical banners in each database with the same sku.>Well, just for those of you interested heres the final code I used, onlyone database necessary:[search db=dbs/ad1.db&eqlivedatarq=Y&skusort=1&skusdir=ra&max=1] [founditems] [showif [website]!]
[/showif][showif [website]!] [/showif] [/foundItems][/search][searchdb=dbs/ad1.db&eqlivedatarq=Y&neskudata=[math]donotuse[/math]&skusort=1&skusdir=ra&max=1] [founditems] [showif [website]!]
[/showif][showif [website]!] [/showif] [/foundItems][/search].....................................................................W O R L D P O I N T I N T E R A C T I V E DANIEL CAMERON web engineerHonolulu San Francisco 2800 woodlawn drive 222 sutter street dcameron@worldpoint.com suite 170 sixth floor www.worldpoint.com honolulu, hi 96822 san francisco, ca 94108 voice.808.539.3932 fax.808.539.3943 page.808.598.8640.....................................................................
Associated Messages, from the most recent to the oldest:
At 11:42 AM 9/9/97 -0900, you wrote:>>I think Grant meant putting half the banners in one db and the rest>>in the other db, so the same two could never appear on the same page.>>But I think there's a better way ...>>The problem is similar sku'ed pairs always showing up together. What >we'll do is just assign the found sku to a variable on the first search >then find all records in the second search that are NOT equal to the >first found sku. This will stop any duplicative banners showing up as >well as stop the pairs that are always showing up together. We just have >to seed identical banners in each database with the same sku.>Well, just for those of you interested heres the final code I used, onlyone database necessary:[search db=dbs/ad1.db&eqlivedatarq=Y&skusort=1&skusdir=ra&max=1]
[founditems] [math]donotuse=[sku][/math]> [showif [website]!]
[/showif][showif [website]!] [/showif] [/foundItems][/search][searchdb=dbs/ad1.db&eqlivedatarq=Y&neskudata=
[math]donotuse[/math]&skusort=1&skusdir=ra&max=1]
[founditems] [showif [website]!]
[/showif][showif [website]!] [/showif] [/foundItems][/search].....................................................................W O R L D P O I N T I N T E R A C T I V E DANIEL CAMERON web engineerHonolulu San Francisco 2800 woodlawn drive 222 sutter street dcameron@worldpoint.com suite 170 sixth floor www.worldpoint.com honolulu, hi 96822 san francisco, ca 94108 voice.808.539.3932 fax.808.539.3943 page.808.598.8640.....................................................................
Daniel Cameron
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] Build Name for 6.1 (2008)
The Form authentication trick (2000)
all records returned. (1997)
Re:2nd WebCatalog2 Feature Request (1996)
[LINEITEMS] (2000)
WebCommerce: Folder organization ? (1997)
pc (1997)
Include (1998)
[CART] inside a [LOOP] (1997)
Summing fields (1997)
[WebDNA] Broken Links on Webdna.us Website (2011)
Newbie problem blah blah blah (1997)
[WebDNA] Integration with QuickBooks (2011)
Pulling Captions from JPGs (2003)
Email within tmpl ? (1997)
Windows 2.1b2 Append Bug? (1997)
WebTEN vs webSTAR have you seen this? (1998)
How do I specify a & character in Grep? (2000)
Notepad problems (1998)
RE: [WebDNA] [table] and COMMA in a Field (2015)