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:
One per customer (2000)
Warning: 50 [MATH] Variable Limit per page (1998)
[NT] ie 4.0 required (1997)
WebDNA Solutions ... sorry! (1997)
Ok here is a question? (1997)
[WriteFile] problems (1997)
code under a [purchase] tag executed when already an Order? (2000)
Show if time tags (1997)
RAM variables (1997)
carriage returns in data (1997)
Claris HomePage messes up the code (1997)
PCS Frames (1997)
Sort Order on a page search (1997)
Encryption method used for [encrypt]? (2000)
Problem (1997)
Setting up the server (1997)
[WebDNA] WebDNA programmers for hire? (2010)
For those of you not on the WebCatalog Beta... (1997)
You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000)
shownext problems (1998)