Re: Display [price] in banner ad

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19674
interpreted = N
texte = >I am working on a store that has thousands of items and have created some >banner >ads for featured products. I have got it so that when a person clicks on an >specific ad it takes them to the details.tpl for that specific product.OK, assuming your banner ads database has a SKU field in it, and your product database is called Catalog.db, you can do something like the following:Price is: [Lookup db=Catalog.db&lookInField=sku&value=[sku]&returnField=price¬Found=Unknown]T his does a lookup in your product database, looking for the sku from your banner ads databaseTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Display [price] in banner ad (PCS Technical Support 1998)
  2. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  3. Re: Display [price] in banner ad (PCS Technical Support 1998)
  4. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  5. Re: Display [price] in banner ad (PCS Technical Support 1998)
  6. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  7. Re: Display [price] in banner ad (Kenneth Grome 1998)
  8. Display [price] in banner ad (Mark Bergkvist 1998)
>I am working on a store that has thousands of items and have created some >banner >ads for featured products. I have got it so that when a person clicks on an >specific ad it takes them to the details.tpl for that specific product.OK, assuming your banner ads database has a SKU field in it, and your product database is called Catalog.db, you can do something like the following:Price is: [Lookup db=Catalog.db&lookInField=sku&value=[sku]&returnField=price¬Found=Unknown]T his does a lookup in your product database, looking for the sku from your banner ads databaseTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical 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:

Netscape Communicator 4 chops off URLs (was No Data) (1997) NetSplat and WebCat2 (1997) Disregard Not reading blanks (1998) WebCat2 - Getting to the browser's username/password data (1997) [subtotal] and others (1997) [searchString] (1997) Another question (1997) Help! WebCat2 bug (1997) Online reference (1997) Searching an Email database (1997) A question on sub-categories (1997) Erotic Sites (1997) tricky embedded[showifs/hideifs] (w/ code.. long) (2000) [WC 2.1.30] Stack overflow. (2000) Thanks ! (1997) Major problem (1999) Making Thumbnail Graphics (1997) File Upload (1997) Add (1998) Find all in search. (2002)