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:

Attn: Bug in GeneralStore example b15 (1997) searchable list archive (1997) WebCat2: Formulas.db question (1997) I give up!! (1997) Format all of a sudden doesn't work (1997) WebMerchant and Mac Auth Hub Help Please (1999) Putting a page between checkout and invoice (1999) Is there a max number of fields? (1998) page redirect in webDNA (1997) No Access warning when caching HTML files (1997) Weird G3 Happenings. (1998) WebCatalog Upgrade Pricing? (1997) RE: template security preferences????? (1998) WebCat2b12 CGI Mac - [shownext] problem (1997) List archive status? (1999) [WebDNA] Successful, working WebDNA7/CentOS install? (2013) Re2: frames & carts (1997) Sorting by date (1997) Re:Emailer setup (1997) [format xs] freeze (1997)