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:

Re: two unique banners on one page (Kenneth Grome 1997) Re: two unique banners on one page (Grant Hulbert 1997) Re: two unique banners on one page (Kenneth Grome 1997) Re: two unique banners on one page (Grant Hulbert 1997) Re: two unique banners on one page (Olin 1997) Re: two unique banners on one page (Grant Hulbert 1997) Re: two unique banners on one page (Olin 1997) Re: two unique banners on one page (Daniel Cameron 1997) Re: two unique banners on one page (Daniel Cameron 1997) two unique banners on one page (Olin 1997)

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:

No Wanna Duppys (1998) Here's how to kill a Butler Database. (1997) no global [username] or [password] displayed ... (1997) CC: (1998) suggestions for a good text editor on windows? (2005) Shipping costs again (1998) simple answer? [hideif] (1997) Writefile illegal characters ? (2004) WebDNA Build Area (linux) (2004) Denying access by IP address (2000) SQL Errors (2003) Concatenating Form Variables (1998) [WebDNA] Pretty URLS (2011) browser info.txt and SSL (1997) Username for Admin Group (1997) # of real domains on 1 web server (1997) Comments in db? (1997) PIXO (1997) WebCat2 - Getting to the browser's username/password data (1997) Re:Remote stockroom ? (1998)