Re: Forumulas.db & Variables

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45830
interpreted = N
texte = > >I want shipping to be based on [shipvia] and tax to be based on [state] and >I can't used either of them in the Formulas.db because when I put them in, >they come up as blank... >Like I said, the Formulas.db will recognize only certain field names. (See the docs.) That's why a field name like [state] is unacceptable. You can, however, use the value of [state] if you name it TextA-E in the formula.On the page in which the item is selected to be added to the shopping cart, set the input name as [TextA-E] and its value as [state].In the Formulas.db, use the [TextA-E] values. The state=[state] or shipvia=[shipvia] values simply won't be used in the price calcs.In the orderfile contexts on the ShoppingCart page, you can have the state shown, but only if you call it [TextA-E].The use of variables in the Formulas.db and the orderfile context isn't intuitive, IMO, because of the restrictions on field names. It's a security thing to prevent unauthorized changing of [price].Glenn ------------------------------------------------------------- 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)
> >I want shipping to be based on [shipvia] and tax to be based on [state] and >I can't used either of them in the formulas.db because when I put them in, >they come up as blank... >Like I said, the formulas.db will recognize only certain field names. (See the docs.) That's why a field name like [state] is unacceptable. You can, however, use the value of [state] if you name it TextA-E in the formula.On the page in which the item is selected to be added to the shopping cart, set the input name as [TextA-E] and its value as [state].In the formulas.db, use the [TextA-E] values. The state=[state] or shipvia=[shipvia] values simply won't be used in the price calcs.In the orderfile contexts on the ShoppingCart page, you can have the state shown, but only if you call it [TextA-E].The use of variables in the formulas.db and the orderfile context isn't intuitive, IMO, because of the restrictions on field names. It's a security thing to prevent unauthorized changing of [price].Glenn ------------------------------------------------------------- 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/ Glenn Busbin

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:

Simple Page (2000) More on the email templates (1997) request for comment tag (1998) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) searchable list archive (1997) possible to oscillate between a [redirect] and [authenticate] every other login attempt? (2000) WebCatalog 4.0 has been released! (2000) send mail problem? (1997) New Plug-in and Type 11 errors (1997) Webcatalog error, Plug-in for Webstar (1996) Loops and [index] (1998) ShowIf Question (1998) Make sure I understand this??? (1997) Locking up with WebCatalog... (1997) WebCat2 - Getting to the browser's username/password data (1997) RE: Languages (1997) WC 2.0 frames feature (1997) Session Number (1998) [middle] (2000) Is there a way to just get to the last record in the database? (1997)