Re: Formulas.db

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40362
interpreted = N
texte = Brian Fries wrote:> I haven't tried it, but couldn't you set a text variable within a > formula?well, I was assumeing you could. However, I was wondering if this variable could be passed or grabbed (from the addlineitems page) and according to John I guess it can't. However, I will run some tests if there is not a clear resolution to this.> As I understand it, WebCat basically grabs the formula from > the DB then does an [interpret] on it... so, theoretically, you could > put any DNA code you want there - including > [text]textVar=blah[/text] - as long as you are careful that the > resulting value has no extra characters after it's been interpreted. > > Also, a clarification: the entry in the formulas.db must be on one > line, and the results of the interpreted include file must not > contain any characters besides the desired result (no spaces or > returns...), but the code within the include file could be on > multiple lines for readability, as long as you comment out all the > return characters and other extraneous text.hey, thats a good thought! thanks.My whole idea is to have the showif/if comparisons in the formulas.db for my different discounts but yet include the actual different discount code so they are separated out to individual text files. This makes finding the right discount text easier and also shortens up the line in the Formulas.db.Donovan.> > > - Brian > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Formulas.db not working ( Donovan Brooke 2006)
  2. Re: Formulas.db not working ( Brian Fries 2006)
  3. Re: Formulas.db not working ( Charles Kline 2006)
  4. Re: Formulas.db not working ( Donovan Brooke 2006)
  5. Re: Formulas.db not working ( Donovan Brooke 2006)
  6. Re: Formulas.db not working ( Charles Kline 2006)
  7. Re: Formulas.db not working ( Donovan Brooke 2006)
  8. Re: Formulas.db not working ( Charles Kline 2006)
  9. Re: Formulas.db not working ( "Dan Strong" 2006)
  10. Re: Formulas.db not working ( Charles Kline 2006)
  11. Re: Formulas.db not working ( Donovan Brooke 2006)
  12. Re: Formulas.db not working ( Charles Kline 2006)
  13. Re: Formulas.db not working ( Donovan Brooke 2006)
  14. Re: Formulas.db not working ( Donovan Brooke 2006)
  15. Re: Formulas.db not working ( Donovan Brooke 2006)
  16. Re: Formulas.db not working ( Gary Krockover 2006)
  17. Formulas.db not working ( Charles Kline 2006)
  18. Re: formulas.db [feature request] ( Donovan 2003)
  19. Re: formulas.db ( Stuart Tremain 2003)
  20. Re: formulas.db ( Kenneth Grome 2003)
  21. formulas.db ( Tim Robinson 2003)
  22. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  23. Re: [shippingtotal] & Formulas.db prob (Gary Krockover 2003)
  24. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  25. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  26. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  27. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  28. [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  29. Re: Formulas.db (dbrooke 2003)
  30. Re: Formulas.db (John Peacock 2003)
  31. Formulas.db (dbrooke 2003)
  32. [Mac 3.0.8] Formulas.db Question (Jesse Williams-Proudman 2003)
  33. Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
  34. Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  35. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  36. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  37. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  38. UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  39. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  40. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  41. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  42. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  43. [shippingtotal] in Formulas.db (WJ Starck 2002)
  44. Re: Formulas.db question (Donovan 2002)
  45. Formulas.db question (charles kline 2002)
  46. Re: Formulas.db (Donovan Brooke 2001)
  47. Re: Formulas.db (Brian Fries 2001)
  48. Re: Formulas.db (John Peacock 2001)
  49. Formulas.db (Donovan Brooke 2001)
  50. Re: Formulas.db (John Peacock 2001)
  51. Re: Formulas.db (Donovan Brooke 2001)
  52. Re: Formulas.db (Glenn Busbin 2001)
  53. Re: Formulas.db (Donovan Brooke 2001)
  54. Re: Formulas.db (John Peacock 2001)
  55. Formulas.db (Donovan Brooke 2001)
  56. Re: where's Formulas.db? (Samuel Renkert 2001)
  57. Re: where's Formulas.db? (John Peacock 2001)
  58. Re: where's Formulas.db? (Charles Kline 2001)
  59. where's Formulas.db? (Brian Wachter 2001)
  60. Re: formvars available in formulas.db? (John Butler 2000)
  61. formvars available in formulas.db? (John Butler 2000)
  62. Re: shipcost and Formulas.db (John Butler 2000)
  63. Re: shipcost and Formulas.db (Chris Vargas 2000)
  64. Re: shipcost and Formulas.db (Chris Vargas 2000)
  65. Re: shipcost and Formulas.db (John Butler 2000)
  66. shipcost and Formulas.db (Chris Vargas 2000)
  67. Re: Formulas.db (Jesse Williams Proudman 2000)
  68. Re: Formulas.db (PCS Technical Support 2000)
  69. Formulas.db (Jesse Williams Proudman 2000)
  70. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  71. Re: Frustration with formulas.db (Kevin Lippert 1999)
  72. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  73. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  74. Re: Frustration with formulas.db (Kenneth Grome 1999)
  75. Frustration with formulas.db (Kevin Lippert 1999)
  76. Re: Problem with Formulas.db (Brian Boegershausen 1999)
  77. Problem with Formulas.db (Karim Ardalan 1999)
  78. Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
  79. Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  80. Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
  81. Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  82. Re: formulas.db (Bob Minor 1999)
  83. Re: formulas.db (PCS Technical Support 1999)
  84. formulas.db (Mícheál O Sé 1999)
  85. formulas.db (Mícheál O Sé 1999)
  86. formulas.db and prices (Mike Jones 1999)
  87. Re: Custom formulas.db (PCS Technical Support 1998)
  88. Re: Custom formulas.db (Tim Taylor 1998)
  89. Re: Custom formulas.db (PCS Technical Support 1998)
  90. Re: Custom formulas.db (Kenneth Grome 1998)
  91. Re: Custom formulas.db (Tim Taylor 1998)
  92. Re: Custom formulas.db (Grant Hulbert 1998)
  93. Re: Custom formulas.db (Kenneth Grome 1998)
  94. Re: Custom formulas.db (PCS Technical Support 1998)
  95. Re: Custom formulas.db (Kenneth Grome 1998)
  96. Re: Custom formulas.db (PCS Technical Support 1998)
  97. Custom formulas.db (Tim Taylor 1998)
  98. Re: Problem with Formulas.db (Mike Heininger 1998)
  99. Re: Problem with Formulas.db (Mike Heininger 1998)
  100. Re: Problem with Formulas.db (Kenneth Grome 1998)
  101. Re: Problem with Formulas.db (PCS Technical Support 1998)
  102. Re: Problem with Formulas.db (Mícheál O Sé 1998)
  103. Problem with Formulas.db (Mike Heininger 1998)
  104. Re: formulas.db problem solved (Mark Mesenko 1998)
  105. Re: formulas.db ?? (Peter Ostry 1998)
  106. Re: formulas.db ?? (Kenneth Grome 1998)
  107. Re: formulas.db ?? (Mark Mesenko 1998)
  108. Re: formulas.db ?? (Kenneth Grome 1998)
  109. formulas.db ?? (Mark Mesenko 1998)
  110. Re: Allowed fields in formulas.db (Paul Willis 1998)
  111. Re: Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  112. Re:Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  113. Re: Allowed fields in formulas.db (PCS Technical Support 1998)
  114. Allowed fields in formulas.db (Paul Willis 1998)
  115. Re:Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  116. Re:Formulas.db / Quantity Discount problem (Jay Van Vark 1998)
  117. Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  118. Re: Formulas.db (Grant Hulbert 1997)
  119. Formulas.db (Ray Hatch 1997)
  120. Re: [search] in formulas.db (Grant Hulbert 1997)
  121. [search] in formulas.db (Mike Heininger 1997)
  122. Looking up two prices in Formulas.db ( 1997)
  123. Looking up two prices in Formulas.db ( 1997)
  124. RE: Formulas.db + Users.db (A. Waldeck 1997)
  125. RE: Formulas.db + Users.db (Grant Hulbert 1997)
  126. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  127. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  128. RE: Formulas.db + Users.db (grichter@panavise.com (Gary Richter) 1997)
  129. RE: Formulas.db + Users.db (Marc Eagle 1997)
  130. Re: Formulas.db + Users.db (Sven U. Grenander 1997)
  131. Re: Formulas.db + Users.db (Express Communications 1997)
  132. Re: Formulas.db + Users.db (Richard Wylie 1997)
  133. Formulas.db + Users.db (Paul Keen 1997)
  134. Re: Variable prices and Formulas.db (Grant Hulbert 1997)
  135. Variable prices and Formulas.db (Austin H. Spiegelman 1997)
  136. Re: WebCat2: Formulas.db question (Grant Hulbert 1997)
  137. WebCat2: Formulas.db question (Ed Trefzger 1997)
  138. Re: WC2b12: Yes, Formulas.db is for real (Kenneth Grome 1997)
  139. WC2b12: Yes, Formulas.db is for real (Grant Hulbert 1997)
  140. formulas.db (Terry Wilson The )
Brian Fries wrote:> I haven't tried it, but couldn't you set a text variable within a > formula?well, I was assumeing you could. However, I was wondering if this variable could be passed or grabbed (from the addlineitems page) and according to John I guess it can't. However, I will run some tests if there is not a clear resolution to this.> As I understand it, WebCat basically grabs the formula from > the DB then does an [interpret] on it... so, theoretically, you could > put any DNA code you want there - including > [text]textVar=blah[/text] - as long as you are careful that the > resulting value has no extra characters after it's been interpreted. > > Also, a clarification: the entry in the formulas.db must be on one > line, and the results of the interpreted include file must not > contain any characters besides the desired result (no spaces or > returns...), but the code within the include file could be on > multiple lines for readability, as long as you comment out all the > return characters and other extraneous text.hey, thats a good thought! thanks.My whole idea is to have the showif/if comparisons in the formulas.db for my different discounts but yet include the actual different discount code so they are separated out to individual text files. This makes finding the right discount text easier and also shortens up the line in the formulas.db.Donovan.> > > - Brian > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics------------------------------------------------------------- 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://search.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:

WebCatalog [FoundItems] Problem - LONG - (1997) shownext and searches (2002) [showif [getcookie otherDomain]=yes] inside a [TCP connect] will work? (2000) Graphing Modules (2004) WebCatalog vs. Cold Fusion (1998) cybercash on OSX - was Executing remote AppleScript (2000) Summaries (1999) WebCatalog2 Feature Feedback (1996) [SHOWIF AND/OR] (1997) More Applescript (1997) Excluding orders from WebMerchant processing (1998) A quickie question (1997) Bad creator codes which cause access denied errormessage (1997) Not really WebCat- (1997) Shopping Carts (2000) WebCatalog and Bar Code Scanners (1999) switching users (1998) Anyone with a solution for this? (2001) [table] retained in memory (2006) [format] (1998)