Further on formula.db failure to calculate shipCost

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 10906
interpreted = N
texte = I have updated the formula for calculating shipCost to work without using the totalweight variable and it still doesn't work. Although this new formula does show the correct value in the final_invoice.tmpl page. Now the formula has grown to what's below:shipCost [hideif [math][lineItems][quantity]*[textB]+[/lineItems]0[/math]>0.5][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=half_lb][/hideif][showif [math][lineItems][quantity]*[textB]+[/lineItems]0[/math]>0.5][hideif [math][lineItems][quantity]*[textB]+[/lineItems]0[/math]>5][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=[math]ceil([lineItems][quantity]*[textB]+[/lineItems]0)[/math]][/hideif][showif [math][lineItems][quantity]*[textB]+[/lineItems]0[/math]>5][math][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=5]+(ceil([lineItems][quantity]*[textB]+[/lineItems]0)-5)*[lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=addl_lb][/math][/showif][/showif]Its amazing that this works in the web tmpl's but not in the formula.db!Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |---------------------------------------------------------------------- Associated Messages, from the most recent to the oldest:

Further on formula.db failure to calculate shipCost (w curt eggemeyer 1997)

I have updated the formula for calculating shipCost to work without using the totalweight variable and it still doesn't work. Although this new formula does show the correct value in the final_invoice.tmpl page. Now the formula has grown to what's below:shipCost [hideif [math][lineitems][quantity]*[textB]+[/lineItems]0[/math]>0.5][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=half_lb][/hideif][showif [math][lineitems][quantity]*[textB]+[/lineItems]0[/math]>0.5][hideif [math][lineitems][quantity]*[textB]+[/lineItems]0[/math]>5][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=[math]ceil([lineItems][quantity]*[textB]+[/lineItems]0)[/math]][/hideif][showif [math][lineitems][quantity]*[textB]+[/lineItems]0[/math]>5][math][lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=5]+(ceil([lineItems][quantity]*[textB]+[/lineItems]0)-5)*[lookup db=country_cost_list.db&lookInField=country&value=[hideif [ShipToCountry]=Specify_Country][ShipToCountry][/hideif][showif [ShipToCountry]=Specify_Country][Country][/showif]&returnField=addl_lb][/math][/showif][/showif]Its amazing that this works in the web tmpl's but not in the formula.db!Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |---------------------------------------------------------------------- w curt eggemeyer

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:

Size limit for tmpl editor ? (1997) WCS Newbie question (1997) OT: Poll Results (2002) [WebDNA] WebDNA licenses discount from 12/23 to 12/31 (2011) Re[2]: 2nd WebCatalog2 Feature Request (1996) WebCat for mass emailings (1997) WebCat and WebTen 2.0 (1997) Summing fields (1997) RE: Displaying Location (1997) hideif/showif causes error if wrapped around searches (2003) WebCat2 - [format thousands] (1997) Mac 2.1b2 speed (1997) Shop till you drop dead on the avenue ... (1997) PIXO support (1997) [BULK] [WebDNA] [BULK] Mac OS X LION has no FastCGI (2011) WebCat2 several catalogs? (1997) It just Does't add up!!! (1997) WebCat for Unix?? (1997) order in the search? (2003) WCS Newbie question (1997)