Re: Associative lookup style? + bit more

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10836
interpreted = N
texte = >>Using the above input form in the shoppingcart.tmpl didn't work. > >I might be wrong about ciel(). Try [format .0f]...[/format] instead. B16 >will definitely have ciel() back in it, though. >ciel works! > >>The formula for shipCost still ends up with zero. Does the formula for >>shipcost only get invoked when moving from the shoppingcart.tmpl -> >>invoice.tmpl? > >No, all formulas are evaluated at $Add, $Remove, $ShowCart, and $Purchase >times. WebCatalog has no idea you are going to an invoice page -- they're >all just templates to it.Well, the formula.db doesnt seem to be invoking on $ShowCart action from our invoice.tmpl. In there I have the following input forms (first one doesn't work in the shoppingcart.tmpl, but does here...hmmph!). The other one is a variable used to simplify the formula below it:Then I have in the formula.db:shipCost [hideif [math][totalWeight]>.5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=half_lb][/hideif][showif [math][totalWeight]>.5[/math]][hideif][math][totalWeight]>5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=[math]ciel([totalWeight])[/math]][/hideif][showif [math][totalWeight]>5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[math][wheretoshipto]&ret urnField=5]+(ciel([totalWeight])-5)*[lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=addl_lb][/math][/showif][/showif]NOTE: I put the above massive formula in the final_invoice.tmpl to see it displayed alongside what [shipCost] thinks it should be. The formula above produces the proper shipcost value, but the [shipCost] is still 0 from the formula database. So, something is funny.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:

    
>>Using the above input form in the shoppingcart.tmpl didn't work. > >I might be wrong about ciel(). Try [format .0f]...[/format] instead. B16 >will definitely have ciel() back in it, though. >ciel works! > >>The formula for shipCost still ends up with zero. Does the formula for >>shipcost only get invoked when moving from the shoppingcart.tmpl -> >>invoice.tmpl? > >No, all formulas are evaluated at $Add, $Remove, $ShowCart, and $Purchase >times. WebCatalog has no idea you are going to an invoice page -- they're >all just templates to it.Well, the formula.db doesnt seem to be invoking on $ShowCart action from our invoice.tmpl. In there I have the following input forms (first one doesn't work in the shoppingcart.tmpl, but does here...hmmph!). The other one is a variable used to simplify the formula below it:[math][lineitems][quantity]*[textB]+[/lineItems]0)[/math]>Then I have in the formula.db:shipCost [hideif [math][totalWeight]>.5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=half_lb][/hideif][showif [math][totalWeight]>.5[/math]][hideif][math][totalWeight]>5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=[math]ciel([totalWeight])[/math]][/hideif][showif [math][totalWeight]>5[/math]][lookup db=country_cost_list.db&lookInField=country&value=[math][wheretoshipto]&ret urnField=5]+(ciel([totalWeight])-5)*[lookup db=country_cost_list.db&lookInField=country&value=[wheretoshipto]&returnFie ld=addl_lb][/math][/showif][/showif]NOTE: I put the above massive formula in the final_invoice.tmpl to see it displayed alongside what [shipCost] thinks it should be. The formula above produces the proper shipcost value, but the [shipCost] is still 0 from the formula database. So, something is funny.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:

Sorry WebCat server not running (2001) formula.db, adding option prices (1997) No Wanna Duppys (1998) WebCat2 - [format thousands] (1997) [date] problem with %d%m%Y (1998) WebMerchant 1.6 and https (1997) [SearchString] problem with [search] context (1997) Showif for mulitple variations (1997) How flexible is Shipping? (1997) Mac 2.1b2 speed (1997) Quiz question: Return all green and blank records? (2001) Reversed words (1997) Configuring E-mail (1997) WebCat2 - [format thousands] (1997) Upgrade to wsV (2004) Newbie Help (2003) WebCatalog-NT?'s (1996) Emailer setup (1997) CommitDatabase vs. CloseDatabase (2001) Solution help needed (1998)