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:

Emailer again & again (1997) server 2003 weirdness (2004) Secure server question (1997) Error Lob.db records error message not name (1997) Record Modified Date - SQL ? (2000) another problem (1997) Note added to [sendmail] in Docs (2004) Reinstalling (2001) Max Record length (1997) problem with NT beta (1997) shipcost (1997) Formulas.db + Users.db (1997) expired beta (1997) Browser Caching (2003) Uh...can someone help me out with the b10? (1997) NEVERMIND! New syntax (2000) emailer (1997) [WebDNA] v7 Stress Test and Strange Behaviour (2012) switching users (1998) Location of Webcat site in folder hierarchy (1997)