Re: Display [price] in banner ad
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19786
interpreted = N
texte = > >Thanks, this does work and displays the price. However, I also have a> >markup of> >the price and the markup works fine in the details.tpl but not with the> >banner ad> >and I can't seem to figure out what I need to change to get it to work.>> The reason is that just putting [price] into your banner ad is not enough> for WebCatalog to know what the price should be. It needs to know what> database to look in, what sku to look for, etc. That's why you use the> [lookup] to find the price. So from a simplistic standpoint, if you> substitute that big [lookup] everywhere you need [price] in your big math> equation, then you'd get the right information.>> There is a way to simplify this with an [include], though, so you don't> have to do so much typing:>> -- MarkupCalc.inc --> (put that big bunch of [ShowIf] with [math] text here)>> Then anywhere you need the marked-up price (even on your details.tpl page), use> [include file=MarkupPrice.inc&price=[Lookup> db=catalog.txt&lookinfield=sku&value=[sku]&returnfield=price]]>> You're basically making a 'macro' that takes a SKU and looks up its> marked-up price atuomatically.Ok, sounds simple enough. But I get an error that says, On Special for only$Error: template ' file=MarkupCalc.inc&price=363.19' not found Here is the code I have in the banner ad:
On Special for only $[includefile=MarkupCalc.inc&price=[lookupdb=catalog.txt&lookinfield=sku&value=455303&returnfield=price]]I made a MarkupCalc.inc file and pasted all the big bunch of [ShowIf] with [math]stuff in it.Am I missing something????????Thanks !Mark B.
Associated Messages, from the most recent to the oldest:
> >Thanks, this does work and displays the price. However, I also have a> >markup of> >the price and the markup works fine in the details.tpl but not with the> >banner ad> >and I can't seem to figure out what I need to change to get it to work.>> The reason is that just putting [price] into your banner ad is not enough> for WebCatalog to know what the price should be. It needs to know what> database to look in, what sku to look for, etc. That's why you use the>
[lookup] to find the price. So from a simplistic standpoint, if you> substitute that big
[lookup] everywhere you need [price] in your big math> equation, then you'd get the right information.>> There is a way to simplify this with an
[include], though, so you don't> have to do so much typing:>> -- MarkupCalc.inc --> (put that big bunch of
[showif] with
[math] text here)>> Then anywhere you need the marked-up price (even on your details.tpl page), use> [include file=MarkupPrice.inc&price=[Lookup> db=catalog.txt&lookinfield=sku&value=[sku]&returnfield=price]]>> You're basically making a 'macro' that takes a SKU and looks up its> marked-up price atuomatically.Ok, sounds simple enough. But I get an error that says, On Special for only$Error: template ' file=MarkupCalc.inc&price=363.19' not found Here is the code I have in the banner ad:
On Special for only $[includefile=MarkupCalc.inc&price=[lookupdb=catalog.txt&lookinfield=sku&value=455303&returnfield=price]]I made a MarkupCalc.inc file and pasted all the big bunch of
[showif] with
[math]stuff in it.Am I missing something????????Thanks !Mark B.
Mark Bergkvist
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:
Copyright ? (1997)
cookies crumbling (1999)
founditem align (1998)
[WebDNA] Calculate Cube root (2012)
WC2b15 File Corruption (1997)
Help name our technology! (1997)
Newbie problem blah blah blah (1997)
Reversed words (1997)
[WebDNA] Sorry WebDNA server not running (2014)
Merging databases (1997)
browser info.txt and SSL (1997)
How to find duplicates - With code samples (2000)
[Sum] function? (1997)
Suffix or Line? (1999)
WebCatalog 4.0.1b1 is now available (2000)
billing system (2003)
[ListFiles] & [loop] (1998)
[index] (1997)
Help! Missing [showif] or [hideif] (2000)
Can you do this??? and other stuff (1997)