Re: Forumulas.db & Variables

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45847
interpreted = N
texte = price [lookup db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price]taxRate [showif [url][state][/url]=WA]8.25[/showif]0shipCost [showif [ShipVia]=1]5[/showif][showif [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100taxable TJesse, I think you are going to find that your system here will give your false values. for example: if your shipvia is 1, I think you will end up with a ship cost of $1100.00.Do this instead. [if [shipvia]=1][then]5[/then][else][if [ShipVia]=2][then]10[/then][else][if [ShipVia]=3][then]15[/then][else]100[/else][/if][/else][/if][/else][/if]Donovan(your taxrate code will work since if it is WA the number will end up 8.250) Jesse Williams-Proudman wrote:> On 12/1/02 11:19 AM, WJ Starck wrote: > > > Show us what your formula in formulas.db looks like... > > Well, this was just for testing: > > price [lookup > db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price > ] > > taxRate [showif [url][state][/url]=WA]8.25[/showif]0 > > shipCost [showif [ShipVia]=1]5[/showif][showif > [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100 > > taxable T > > I also tried wrapping taxrate and shipcost in [orderfile] and that didn't > work. > > -- > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Forumulas.db & Variables (Donovan 2002)
  2. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  3. Re: Forumulas.db & Variables (Alain Russell 2002)
  4. Re: Forumulas.db & Variables (Andrew Simpson 2002)
  5. Re: Forumulas.db & Variables (Alain Russell 2002)
  6. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  7. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  8. Re: Forumulas.db & Variables (Donovan 2002)
  9. Re: Forumulas.db & Variables (Donovan 2002)
  10. Re: Forumulas.db & Variables (Gary Krockover 2002)
  11. Re: Forumulas.db & Variables (John Peacock 2002)
  12. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  13. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  14. Re: Forumulas.db & Variables (Donovan 2002)
  15. Re: Forumulas.db & Variables (Donovan 2002)
  16. Re: Forumulas.db & Variables (John Peacock 2002)
  17. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  18. Re: Forumulas.db & Variables (Donovan 2002)
  19. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  20. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  21. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  22. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  23. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  24. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  25. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  26. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  27. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  28. Re: Forumulas.db & Variables (WJ Starck 2002)
  29. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  30. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  31. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  32. Re: Forumulas.db & Variables (WJ Starck 2002)
  33. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  34. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  35. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  36. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  37. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  38. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  39. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  40. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  41. Re: Forumulas.db & Variables (Gary Krockover 2002)
  42. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  43. Re: Forumulas.db & Variables (WJ Starck 2002)
  44. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  45. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  46. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  47. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  48. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  49. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  50. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  51. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  52. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  53. Re: Forumulas.db & Variables (WJ Starck 2002)
  54. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  55. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  56. Forumulas.db & Variables (Jesse Williams-Proudman 2002)
price [lookup db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price]taxRate [showif [url][state][/url]=WA]8.25[/showif]0shipCost [showif [ShipVia]=1]5[/showif][showif [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100taxable TJesse, I think you are going to find that your system here will give your false values. for example: if your shipvia is 1, I think you will end up with a ship cost of $1100.00.Do this instead. [if [shipvia]=1][then]5[/then][else][if [ShipVia]=2][then]10[/then][else][if [ShipVia]=3][then]15[/then][else]100[/else][/if][/else][/if][/else][/if]Donovan(your taxrate code will work since if it is WA the number will end up 8.250) Jesse Williams-Proudman wrote:> On 12/1/02 11:19 AM, WJ Starck wrote: > > > Show us what your formula in formulas.db looks like... > > Well, this was just for testing: > > price [lookup > db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price > ] > > taxRate [showif [url][state][/url]=WA]8.25[/showif]0 > > shipCost [showif [ShipVia]=1]5[/showif][showif > [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100 > > taxable T > > I also tried wrapping taxrate and shipcost in [orderfile] and that didn't > work. > > -- > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

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:

showif and cart (1997) Sorting by date (1997) fresh eyes needed. Append won't work. (2000) [BULK] [WebDNA] abstraction code can be tricky... (2012) Harvesting invalid email addresses from bounced emails??? (2000) [WebDNA] OT: How is this being done? Curious. (2009) Error Lob.db records error message not name (1997) emailer don't work (1998) no [search] with NT (1997) Sort Order on a page search (1997) [taxrate] question (1997) where to put code (1998) [Reload mydata.db] (1998) & Aftermath (1999) AAgghh!! Help, please. SSL strikes again. (1997) Cart # Starting at 1000 (2000) [LOOKUP] (1997) [WebDNA] [replacefounditems] fails (2009) Error Lob.db records error message not name (1997) Orders and notification (1998)