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:

SMSI -- a [notfound] context? (2002) emailer (1997) Upload files script (2003) WC2.0 Memory Requirements (1997) Can [writefile] files be served thru webcat? (2000) One other big addition... (1997) Multiple Ad databases? (1997) Showif? (2000) Showif Or (2000) HELP! Search finding too much! (1998) no template caching (1997) WebCat2b15MacPlugin - showing [math] (1997) Updating Prices in Online Database (1999) Big Databases (1997) OT - How to pay commissions to non US affiliates? (2000) Show new (2003) Press Release hit the NewsWire!!! (1997) WCS Newbie question (1997) E-Mail (1998) Search minus first found (1999)