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:

WebMerchant? (1998) FW: I'll Know If You Don't Read This (2006) Putting [cart] into a database (2003) Global variables are not always global ... (2000) [WebDNA] v7 thisurl has different behavour (2012) Shopping Cart Directory (2000) Requiring that certain fields be completed (1997) Referrer (2000) Running _every_ page through WebCat ? (1997) Re1000001: Setting up shop (1997) three cart questions (1997) LOOP and IF statements (1997) Total found of each unique field (2003) math on date? (1997) Secure Server (1997) Freeze (2003) WC2b15 File Corruption (1997) Wild WebCat 98 Contest! (1998) Bug? (1997) Remote stockroom ? (1998)