Math function in Formula.db

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15665
interpreted = N
texte = Hi All,I can't get this one to work, so I guess I should ask if it can be done first :-)Can I use the [math] function within the Formulas.db to return a calculated result ?This is what the formula looks like. I know the formula works because when I execute it as a line command through a standard .tmpl file I get the correct result. I then try to use the [price] command and the result is 0.--Formulas.db-- Name Formula price [math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=setup]+[quantity.form]*[l ookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=monthlyrental][/math] Thanks,Tim_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 9111 80 Berry Street Facsimile + 61 7 3839 5442 Spring Hill Queensland email tim@webhost.com.au AUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE Associated Messages, from the most recent to the oldest:

    
  1. Re: Math function in Formula.db (Grant Hulbert 1997)
  2. Math function in Formula.db (Tim Rignold 1997)
Hi All,I can't get this one to work, so I guess I should ask if it can be done first :-)Can I use the [math] function within the formulas.db to return a calculated result ?This is what the formula looks like. I know the formula works because when I execute it as a line command through a standard .tmpl file I get the correct result. I then try to use the [price] command and the result is 0.--formulas.db-- Name Formula price [math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=setup]+[quantity.form]*[l ookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=monthlyrental][/math] Thanks,Tim_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 9111 80 Berry Street Facsimile + 61 7 3839 5442 Spring Hill Queensland email tim@webhost.com.au AUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE Tim Rignold

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:

Writefile doesn't work, which permissions to use? (2005) OSX Install error (2000) Questions To Answer (1997) Grep is Broke (2004) SwitchNotFoundDEFAULT (2003) Robert Minor duplicate mail (1997) Will webdna execute before a [redirect]? (1999) WebCatalog can't find database (1997) Emailer error code? (2001) can WC render sites out? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Webcat 2.0.1 date math bug -> Crash! (1997) cookie length (1998) Scoping rules in WebDNA 4.0 (2000) Some Advise needed (1997) A multi-processor savvy WebCatalog? (1997) More to Expire (1998) multiple databases (1997) E-mail loop ! (1997) [OT] ImageMagick error (2004)