Re: shipcost

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15098
interpreted = N
texte = Ray & Grant,Oh man am I a dunce or what? (Don't answer that Grant :) Anyway, so here is the excerpt from my invoice.tmpl. I don't want to use the format for the subtotal itself because I want all the cents. I checked and the formula is indeed giving me the correct subtotal with no decimals, but I still getting nothing in return from the look up tag. The lookup is not using the [math] value. <--[format .0f][math show=f]sub=0[/math][LineItems][math show=F]sub=sub+[quantity]*[price][/math][/lineitems][math]sub[/math][/forma t] --> $[lookup db=ship.db&lookInField=subtot&value=[math]&returnField=shipping¬Found=ov er$500, please call] I did change my db accordingly (it is now just whole numbers) so that isn't the problem. And if that were the problem I would get the not found message, not a blank. I feel like I am so close, what am I missing? Janna >I believe he was refering to the [format .0f] to round your prices. such as >[format .0f][shipping][/format] should show 1.00, if that's what's found, >go ahead and take the f out of your database. This might solve your problem. > >What your trying to match (i believe) is the subtotal of the purchase, to a >dollar amount in your shipping database, to return the proper cost of >shipping for that ammount. When your search looks at that database trying >to compare 10.00 and sees 10.00f it doesn't consider that a match. So by >taking the f out, it should. =) > >Ray > > > >At 12:20 PM 11/25/97 -0000, you wrote: >>Good question. Here was Grant's reason: To simplify this, you could >>round off to the nearest dollar with [format .0f] and then your database >>would only have whole dollars in it. That has the advantage that it's >>very easy to update your shipping tables (I know it's really hard to read >>those formulas, so a table would be nice). >> >>Janna >> >>>I'm curious what the { f } is for in your actual database, why not just 1.0? >>> >>>Ray >>> >>>At 11:45 AM 11/25/97 -0000, you wrote: >>>>BTW: I also tried it with the math formula instead of the [subtotal]: >>>>[format .2f][math show=f]sub=0[/math][LineItems][math >>>>show=F]sub=sub+[quantity]*[price][/math][/lineitems][math]sub[/math][/forma >>>>t] >>>> >>>> and in my lookup formula used [math]: >>>>[lookup >>>>db=ship.db&lookInField=subtot&value=[math]&returnField=shipping¬Found=ov >>>>er$500, please call] >>>> >>>> but then I just get a blank response. >>>> >>>>Janna >>>> >>>> >>>>>OK, so I have made a database and use the following formula as instead of >>>>>[shipcost] in my Invoice.tmpl (I tried using it in the formula.db, but it >>>>>didn't work, but that is fine 'cause now it is working in the Invoice >>>>>page). >>>>> >>>>>$[lookup >>>>>db=ship.db&lookInField=subtot&value=[subtotal]&returnField=shipping¬F >oun >>>>>d=over$500, please call] >>>>> >>>>>My ship.db looks like this: >>>>>subtot shipping >>>>>1.0f 1 >>>>>2.0f 1 >>>>>3.0f 1 >>>>>4.0f 1 >>>>>5.0f 1 >>>>>6.0f 1 >>>>>7.0f 1 >>>>>8.0f 1 >>>>>9.0f 1 >>>>>10.0f 1 >>>>> >>>>>and so until 500 >>>>> >>>>>But my shipping keeps getting returned as over$500, please call. Why >>>>>can't the formula find the subtotal? Did I use the .0f incorrectly? >>>>> >>>>>Janna >>>>> >>>>> >>>>> >>>>>Oh. I get it. I think you are right about using the lookup table. I >>>>>will try it. >>>>> >>>>>Thank you, >>>>>Janna >>>>> >>>>>First off, I think you're better off using a database table lookup >>>because >>>>>you have so many ranges that it causes the shipCost formula to bloat. >>>>>Tables are a nice way to simplify these kinds of calculations, and they >>>>>are not a 'waste' of databases. >>>>> >>>>>But, using your current technique, you would use [math] to 'remember' a >>>>>numeric value for later use, and stick that math equation at the >>>beginning >>>>>of your shipcost formula. The math context remembers all its variable >>>>>names for the duration of the page. >>>>> >>>>>[math show=f]sub=all the stuff to calc the subtotal[/math][showif >>>>>[math]sub[/math]<20.00]...[/showif] >>>>> >>>>>Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of >Us >>>>==== >>>>>Pacific Coast Software | WebCatalog, WebMerchant, >>>>>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >>>>>San Diego, CA 92128 | Typhoon >>>>>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>****************************** >>>>>Janna S. Kohen >>>>>Big Mind Media L. L. C. >>>>>http://www.bigmindmedia.com/ >>>>>janna@bigmindmedia.com >>>>> >>>>> >>>>> >>>> >>>> >>> >> >> > Associated Messages, from the most recent to the oldest:

    
  1. Re: Updating shipcost ( Mark Derrick 2005)
  2. Updating shipcost ( Mark Derrick 2005)
  3. Re: Shipcost formula ( WJC Limited 2004)
  4. Re: Shipcost formula ( WJC Limited 2004)
  5. Re: Shipcost formula ( Gary Krockover 2004)
  6. Re: Shipcost formula ( Gary Krockover 2004)
  7. Re: Shipcost formula ( WJC Limited 2004)
  8. Re: Shipcost formula ( Gary Krockover 2004)
  9. Re: Shipcost formula ( WJC Limited 2004)
  10. Re: Shipcost formula ( Gary Krockover 2004)
  11. Re: Shipcost formula ( WJC Limited 2004)
  12. Re: Shipcost formula ( Gary Krockover 2004)
  13. Shipcost formula ( WJC Limited 2004)
  14. Re: Shipcost formula ( WJC Limited 2004)
  15. Re: Shipcost formula ( Gary Krockover 2004)
  16. Shipcost formula ( WJC Limited 2004)
  17. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  18. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  19. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  20. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  21. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  22. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  23. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  24. Re: the dreaded unitShipCost ( John Peacock 2003)
  25. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  26. Re: the dreaded unitShipCost ( Alain Russell 2003)
  27. Re: the dreaded unitShipCost ( Alain Russell 2003)
  28. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  29. Re: the dreaded unitShipCost ( John Peacock 2003)
  30. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  31. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  32. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  33. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  34. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  35. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  36. Re: the dreaded unitShipCost ( Tim Robinson 2003)
  37. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  38. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  39. the dreaded unitShipCost ( "Andrew Simpson" 2003)
  40. Re: Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
  41. Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
  42. Re: UnitShipCost Slight Return (Donovan 2003)
  43. UnitShipCost Slight Return (Alphonse MacDonald 2003)
  44. Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
  45. Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  46. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  47. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  48. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  49. UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  50. Re: shopcost, unitshipcost (Andrew Simpson 2002)
  51. Re: shopcost, unitshipcost (Donovan Brooke 2002)
  52. Re: shopcost, unitshipcost (Arturo Vargas 2002)
  53. Re: shopcost, unitshipcost (Andrew Simpson 2002)
  54. shopcost, unitshipcost (Arturo Vargas 2002)
  55. Re: unitShipCost - setlineitem nevermind (Donovan 2002)
  56. unitShipCost - setlineitem (Donovan 2002)
  57. Re: and more [shipcost].... (Arturo Vargas 2001)
  58. Re: and more [shipcost].... (Glenn Busbin 2001)
  59. Re: and more [shipcost].... (Arturo Vargas 2001)
  60. Re: and more [shipcost].... (Anup Setty 2001)
  61. Re: and more [shipcost].... (Arturo Vargas 2001)
  62. Re: and more [shipcost].... (Anup Setty 2001)
  63. and more [shipcost].... (Arturo Vargas 2001)
  64. shipCost problems (Nitai @ Eyework 2000)
  65. Re: Stumped on ShipCosts.db Problem (Bob McPeak 2000)
  66. Re: Stumped on ShipCosts.db Problem (John Butler 2000)
  67. Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
  68. Re: shipCost -vs- shippingtotal ? (John Butler 2000)
  69. Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
  70. Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
  71. Re: shipCost -vs- shippingtotal ? (John Butler 2000)
  72. Re: shipCost -vs- shippingtotal ? (John Butler 2000)
  73. Re: shipCost -vs- shippingtotal ? (John Butler 2000)
  74. Re: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
  75. shipCost -vs- shippingtotal ? (John Butler 2000)
  76. Correction: shipCost (Robert Wade 2000)
  77. shipCost (Robert Wade 2000)
  78. Re: shipcost and Formulas.db (John Butler 2000)
  79. Re: shipcost and Formulas.db (Chris Vargas 2000)
  80. Re: shipcost and Formulas.db (Chris Vargas 2000)
  81. Re: shipcost and Formulas.db (John Butler 2000)
  82. shipcost and Formulas.db (Chris Vargas 2000)
  83. Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
  84. Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  85. Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
  86. Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  87. Setting shipCost -- thanks! (Chris Vargas 1999)
  88. Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998)
  89. ShipCost formula (for weight *and* quantities)? (Dale Stokdyk 1998)
  90. Re: TaxRate and ShipCost Problem (PCS Technical Support 1998)
  91. TaxRate and ShipCost Problem (Karl Isselhardt 1998)
  92. Re: ShipCost and TaxRate problems (PCS Technical Support 1998)
  93. Re: shipCost (PCS Technical Support 1998)
  94. Re: shipCost (Brian B. Burton 1998)
  95. ShipCost and TaxRate problems (Karl Isselhardt 1998)
  96. Re: shipCost (PCS Technical Support 1998)
  97. shipCost (Brian B. Burton 1998)
  98. Re: When is unitShipCost calculated? (Luke Melia 1998)
  99. Re: When is unitShipCost calculated? (Brian Drum 1998)
  100. Re: When is unitShipCost calculated? (Brian Drum 1998)
  101. Re: When is unitShipCost calculated? (PCS Technical Support 1998)
  102. When is unitShipCost calculated? (Brian Drum 1998)
  103. Shipcost Based on SubTotal (Michael Fichtenmayer 1998)
  104. [unitshipcost] values do NOT write to orderfile (Kenneth Grome 1998)
  105. Re: ShipCost Problems (PCS Technical Support 1998)
  106. ShipCost Problems (Richard Kirsner 1998)
  107. Re: ShipCost Data Base (Kenneth Grome 1998)
  108. Re: ShipCost Data Base (Richard Kirsner 1998)
  109. Re: ShipCost Data Base (Kenneth Grome 1998)
  110. Re: ShipCost Data Base (bob 1998)
  111. ShipCost Data Base (Richard Kirsner 1998)
  112. Re: shipCost (PCS Technical Support 1998)
  113. shipCost (Raymond Hatch (by way of Jay Van Vark) 1998)
  114. Re: shipCost (Raymond Hatch 1998)
  115. Re: shipcost - cleaner with a table (Brian B. Burton 1998)
  116. shipcost - cleaner with a table (PCS Technical Support 1998)
  117. Shipcost Prob solved, new one arises (Kevin Furuta 1998)
  118. shipcost - fed up with the old way (Kevin Furuta 1998)
  119. Re: shipcost vs shiptotal (PCS Technical Support 1998)
  120. shipcost vs shiptotal (Kevin Furuta 1998)
  121. Re: shipCost not working v2.1b4 (Grant Hulbert 1997)
  122. Re: shipCost not working v2.1b4 (Pat McCormick 1997)
  123. Re: shipCost not working v2.1b4 (Pat McCormick 1997)
  124. shipCost not working v2.1b4 (Pat McCormick 1997)
  125. more on the Shipcost update problem (Jim Lanford 1997)
  126. Shipcost update problem (Jim Lanford 1997)
  127. Re: shipcost (Raymond Hatch 1997)
  128. Re: shipcost (Raymond Hatch 1997)
  129. Re: shipcost (Grant Hulbert 1997)
  130. Re: shipcost (Raymond Hatch 1997)
  131. Re: shipcost (Raymond Hatch 1997)
  132. Re: shipcost (Janna S. Kohen 1997)
  133. Re: shipcost (Janna S. Kohen 1997)
  134. Re: shipcost (Janna S. Kohen 1997)
  135. Re: shipcost (Janna S. Kohen 1997)
  136. Re: shipcost (Janna S. Kohen 1997)
  137. Re: shipcost (Janna S. Kohen 1997)
  138. Re: shipcost (Grant Hulbert 1997)
  139. Re: shipcost (Raymond Hatch 1997)
  140. Re: shipcost (Grant Hulbert 1997)
  141. Re: shipcost (Grant Hulbert 1997)
  142. Re: shipcost (Raymond Hatch 1997)
  143. Re: shipcost (Janna S. Kohen 1997)
  144. Re: shipcost (Janna S. Kohen 1997)
  145. Re: shipcost (Janna S. Kohen 1997)
  146. Re: shipcost (Janna S. Kohen 1997)
  147. Re: shipcost (Janna S. Kohen 1997)
  148. Re: shipcost (Janna S. Kohen 1997)
  149. Re: shipcost (grichter@panavise.com (Gary Richter) 1997)
  150. Re: shipcost (Kenneth Grome 1997)
  151. Re: shipcost (Kenneth Grome 1997)
  152. Re: shipcost (Kenneth Grome 1997)
  153. Re: shipcost (Raymond Hatch 1997)
  154. Re: shipcost (Raymond Hatch 1997)
  155. Re: shipcost (Raymond Hatch 1997)
  156. Re: shipcost (Janna S. Kohen 1997)
  157. Re: shipcost (Janna S. Kohen 1997)
  158. Re: shipcost (Janna S. Kohen 1997)
  159. Re: shipcost (Janna S. Kohen 1997)
  160. shipcost (Janna S. Kohen 1997)
  161. Re: [shipCost] math formula? (Grant Hulbert 1997)
  162. [shipCost] math formula? (dwilfong@world-wide-art.com (David Wilfong) 1997)
  163. shipCost formula (Janna S. Kohen 1997)
  164. calculating ShipCost depending on weight (Mike Heininger 1997)
  165. RE: Tax and ShipCost Problem (Marc Eagle 1997)
  166. Tax and ShipCost Problem (Mike Heininger 1997)
  167. THANKS!!! Re: ShipCosts.db and debugging (Dale Stokdyk 1997)
  168. Re: ShipCosts database (Grant Hulbert 1997)
  169. Re: ShipCosts database (Dale Stokdyk 1997)
  170. Re: creating a ShipCosts database (grichter@panavise.com (Gary Richter) 1997)
  171. Re: creating a ShipCosts database (Grant Hulbert 1997)
  172. Re: creating a ShipCosts database (Dale Stokdyk 1997)
  173. Re: creating a ShipCosts database (Grant Hulbert 1997)
  174. creating a ShipCosts database (Dale Stokdyk 1997)
  175. Re: unitshipcost vs shipcosts (Grant Hulbert 1997)
  176. unitshipcost vs shipcosts (Kevin Furuta 1997)
  177. Re: still having shipCost.db Problem (Richard Wylie 1997)
  178. Re: still having shipCost.db Problem (Grant Hulbert 1997)
  179. still having shipCost.db Problem (Richard Wylie 1997)
  180. Re: Shipcost lookup? (Kenneth Grome 1997)
  181. Shipcost lookup? (Richard Wylie 1997)
  182. Re: Further tests with the infamous shipCost (Sven U. Grenander 1997)
  183. Further tests with the infamous shipCost (w curt eggemeyer 1997)
  184. Further on formula.db failure to calculate shipCost (w curt eggemeyer 1997)
Ray & Grant,Oh man am I a dunce or what? (Don't answer that Grant :) Anyway, so here is the excerpt from my invoice.tmpl. I don't want to use the format for the subtotal itself because I want all the cents. I checked and the formula is indeed giving me the correct subtotal with no decimals, but I still getting nothing in return from the look up tag. The lookup is not using the [math] value. <--[format .0f][math show=f]sub=0[/math][lineitems][math show=F]sub=sub+[quantity]*[price][/math][/lineitems][math]sub[/math][/forma t] --> $[lookup db=ship.db&lookInField=subtot&value=[math]&returnField=shipping¬Found=ov er$500, please call] I did change my db accordingly (it is now just whole numbers) so that isn't the problem. And if that were the problem I would get the not found message, not a blank. I feel like I am so close, what am I missing? Janna >I believe he was refering to the [format .0f] to round your prices. such as >[format .0f][shipping][/format] should show 1.00, if that's what's found, >go ahead and take the f out of your database. This might solve your problem. > >What your trying to match (i believe) is the subtotal of the purchase, to a >dollar amount in your shipping database, to return the proper cost of >shipping for that ammount. When your search looks at that database trying >to compare 10.00 and sees 10.00f it doesn't consider that a match. So by >taking the f out, it should. =) > >Ray > > > >At 12:20 PM 11/25/97 -0000, you wrote: >>Good question. Here was Grant's reason: To simplify this, you could >>round off to the nearest dollar with [format .0f] and then your database >>would only have whole dollars in it. That has the advantage that it's >>very easy to update your shipping tables (I know it's really hard to read >>those formulas, so a table would be nice). >> >>Janna >> >>>I'm curious what the { f } is for in your actual database, why not just 1.0? >>> >>>Ray >>> >>>At 11:45 AM 11/25/97 -0000, you wrote: >>>>BTW: I also tried it with the math formula instead of the [subtotal]: >>>>[format .2f][math show=f]sub=0[/math][lineitems][math >>>>show=F]sub=sub+[quantity]*[price][/math][/lineitems][math]sub[/math][/forma >>>>t] >>>> >>>> and in my lookup formula used [math]: >>>>[lookup >>>>db=ship.db&lookInField=subtot&value=[math]&returnField=shipping¬Found=ov >>>>er$500, please call] >>>> >>>> but then I just get a blank response. >>>> >>>>Janna >>>> >>>> >>>>>OK, so I have made a database and use the following formula as instead of >>>>>[shipcost] in my Invoice.tmpl (I tried using it in the formula.db, but it >>>>>didn't work, but that is fine 'cause now it is working in the Invoice >>>>>page). >>>>> >>>>>$[lookup >>>>>db=ship.db&lookInField=subtot&value=[subtotal]&returnField=shipping¬F >oun >>>>>d=over$500, please call] >>>>> >>>>>My ship.db looks like this: >>>>>subtot shipping >>>>>1.0f 1 >>>>>2.0f 1 >>>>>3.0f 1 >>>>>4.0f 1 >>>>>5.0f 1 >>>>>6.0f 1 >>>>>7.0f 1 >>>>>8.0f 1 >>>>>9.0f 1 >>>>>10.0f 1 >>>>> >>>>>and so until 500 >>>>> >>>>>But my shipping keeps getting returned as over$500, please call. Why >>>>>can't the formula find the subtotal? Did I use the .0f incorrectly? >>>>> >>>>>Janna >>>>> >>>>> >>>>> >>>>>Oh. I get it. I think you are right about using the lookup table. I >>>>>will try it. >>>>> >>>>>Thank you, >>>>>Janna >>>>> >>>>>First off, I think you're better off using a database table lookup >>>because >>>>>you have so many ranges that it causes the shipCost formula to bloat. >>>>>Tables are a nice way to simplify these kinds of calculations, and they >>>>>are not a 'waste' of databases. >>>>> >>>>>But, using your current technique, you would use [math] to 'remember' a >>>>>numeric value for later use, and stick that math equation at the >>>beginning >>>>>of your shipcost formula. The math context remembers all its variable >>>>>names for the duration of the page. >>>>> >>>>>[math show=f]sub=all the stuff to calc the subtotal[/math][showif >>>>>[math]sub[/math]<20.00]...[/showif] >>>>> >>>>>Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of >Us >>>>==== >>>>>Pacific Coast Software | WebCatalog, WebMerchant, >>>>>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >>>>>San Diego, CA 92128 | Typhoon >>>>>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>****************************** >>>>>Janna S. Kohen >>>>>Big Mind Media L. L. C. >>>>>http://www.bigmindmedia.com/ >>>>>janna@bigmindmedia.com >>>>> >>>>> >>>>> >>>> >>>> >>> >> >> > Janna S. Kohen

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:

all db's in one folder and protected (1998) WebCat editing, SiteGuard & SiteEdit (1997) instant cookies? (1999) Using Plug-In while running 1.6.1 (1997) WebCat2b15MacPlugin - [protect] (1997) calendar (2001) Speeding up my [showif] performance (1999) 2cd pair.. [math] and European Date format (2004) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) corrupted images (2002) [isfile] ? (1997) Communigate (2001) The word TYPE in search contexts and fields (1998) Text data with spaces in them... (1997) Upgrading from 2.1 to 3.0.7 (2000) Fwd: Problems with Webcatalog Plug-in (1997) The max=0 issue is a bug ... (2000) RE: Credit card processing - UK (1997) b12 cannot limit records returned and more. (1997) Mime Headers for Mail (1998)