Re: Frustration with formulas.db

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25458
interpreted = N
texte = >I'd like the taxRate to lookup on [State] if [ShipToState] is blank (so >people don't have to enter a ShipToState seperately). My first thought is >that this is easiest to do in formulas.db, something like: > >taxRate [interpret][lookup db=TaxRates.db&lookInField=State&value=[showif >[ShipToState]>][ShipToState][/showif][showif >[ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00][/inter >pret]Using [interpret] inside a database field does not make webcatalog interpret the enclosed code. The [interpret] context has to be outside the database -- and in the template file.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  2. Re: Frustration with formulas.db (Kevin Lippert 1999)
  3. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  4. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  5. Re: Frustration with formulas.db (Kenneth Grome 1999)
  6. Frustration with formulas.db (Kevin Lippert 1999)
>I'd like the taxRate to lookup on [State] if [ShipToState] is blank (so >people don't have to enter a ShipToState seperately). My first thought is >that this is easiest to do in formulas.db, something like: > >taxRate [interpret][lookup db=TaxRates.db&lookInField=State&value=[showif >[ShipToState]>][ShipToState][/showif][showif >[ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00][/inter >pret]Using [interpret] inside a database field does not make webcatalog interpret the enclosed code. The [interpret] context has to be outside the database -- and in the template file.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Kenneth Grome

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:

[TaxableTotal] - not working with AOL and IE (1997) Mystery authentication (1997) OT: 800x600 (2003) Groups doesn't work (1997) Looking up two prices in database? (1997) help needed w/ search params (1998) Forcing a NEWCART (1997) Enhancement Request for WebCatalog-NT (1996) redirect from the errorsMessages.db entry (1997) Errata: WCS Newbie question (1997) shipcost (1997) shownext example (2001) RE: Last desperate attempt (1998) RE: Can't get appendfile to work (1997) [WebDNA] [BULK] WebDNA Windows Install (2016) WebCatalog as another user on mac osx (2001) WebMerchant 1.6 and SHTML (1997) timing out? (1997) Custom Shipping Charges (1997) WebCat2 beta 11 - new prefs ... (1997)