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:
[WebDNA] isolatin-1 to utf-8 conversion (2013)
Applescript in Webcatalog problem (1997)
[isfile] ? (1997)
Trouble with formula.db (1997)
Re:no template caching (1997)
Text data with spaces in them... (1997)
Re:Emailer and encryption (1997)
Next X hits (1996)
Separate SSL Server (1997)
international time (1997)
Shipping Based on Number of Items (1998)
Waitfor file (2000)
WebCat editing, SiteGuard & SiteEdit (1997)
form data submission gets truncated (1997)
4.5.1 (2003)
Comments in db? (1997)
Problem with updating to 2.1.1 (1998)
BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Re2: AAgghh!! Help, please. SSL strikes again. (1997)