Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66164
interpreted = N
texte = Been a while myself-Don't you have to do some math on the price, i.e.:price
[showif [sku]=12345][math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/math][/showif]GaryAt 10:39 AM 2/3/2006, you wrote:>Hi all.>>Been a really long time since I used Formulas.db for anything. >Anyhow, I am trying to setup a discount on 1 item in the catalog. I >have a very simple formula:>>price[showif [sku]=12345][lookup >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/showif]>>Anyhow.. this is not working (does not return any change in price). >Even if I change my formula to just return a hard coded value such as >999 I get no change in price.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Been a while myself-Don't you have to do some math on the price, i.e.:price[showif [sku]=12345][math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/math][/showif]GaryAt 10:39 AM 2/3/2006, you wrote:>Hi all.>>Been a really long time since I used formulas.db for anything. >Anyhow, I am trying to setup a discount on 1 item in the catalog. I >have a very simple formula:>>price[showif [sku]=12345][lookup >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/showif]>>Anyhow.. this is not working (does not return any change in price). >Even if I change my formula to just return a hard coded value such as >999 I get no change in price.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:
WebCatalog seems to choke on large (2meg) html files. (1998)
Location of Browser Info.txt file (1997)
Need help with emailer- 2 issues (1997)
Emailer setup (1997)
WC2.0 Memory Requirements (1997)
Multiple serial numbers (1997)
search comparison (2003)
So many lookers, hey smith micro (2003)
Not really WebCat (1997)
[WebDNA] Triggers issue, or sendmail? (2012)
ReturnRaw and redirect (1997)
[browsername] (2001)
[WebDNA] Listwords and newline (2011)
format and math on the fly (1998)
DB Size - MAX (2004)
Solve the Problem, get the code! (2001)
[WebDNA] Trying to search for two values within one criteria... (2016)
WebCat2: Items xx to xx shown, etc. (1997)
WebTen? (1997)
Help name our technology! I found it (1997)