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:
>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:
[delete] problem (1997)
Need A Hired Gun :^) (1998)
Open Databases on Restart (1999)
[sendmail] questions... (1997)
Enhancement Request for WebCatalog-NT (1996)
using showpage and showcart commands (1996)
Limit to Field Length in DB (1998)
setlineitem quantity to zero? (2000)
Funny Chars (1999)
Dummy Credit Card Number for debug? (1997)
Quit revisited (1997)
SKU (1997)
Search/sort in URL Was: GuestBook example (1997)
[WebDNA] Nested Searches (2013)
Appendfile memory usage (redux) (2003)
This message couldn't reach the list! (multi-column layout ofsearch results) (1998)
Emailer (WebCat2) (1997)
too many nested tags ... (1997)
Web Delivery Page concept (1997)
Stopping bad HTML propagation ? (1997)