numero = 10942
interpreted = N
texte = I just ran another test on our shipCost problem where the complex formula below was applied to it via a hidden input field (I took it out of the formula db). This doesn't work either, even though this very same formula on the final_invoice.tmpl works.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]>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 tests with the infamous shipCost (w curt eggemeyer 1997)
I just ran another test on our shipCost problem where the complex formula below was applied to it via a hidden input field (I took it out of the formula db). This doesn't work either, even though this very same formula on the final_invoice.tmpl works.[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]>Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |----------------------------------------------------------------------
w curt eggemeyer
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...