Re: shipcost
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14978
interpreted = N
texte = try putting a space between your showif and your [subtotal] [showif [subtotal]>20]1[/showif]RayAt 01:15 PM 11/21/97 -0000, you wrote:>Great Ray. Thank you so much. Now I have another question. I want to >make a series of these, and this is the formula I made, but it doesn't >work. Any ideas?>>[showif >[subtotal]<20]1[/showif][showif[subtotal]>19.99]3[/showif][showif[subtotal]>>39.99]5[/showif][showif >[subtotal]>59.99]7[/showif][showif[subtotal]>79.99]9[/showif][showif >[subtotal]>99.99]11[/showif][showif[subtotal]>129.99]13[/showif][showif[sub>total]>159.99]15[/showif]>>>I found this response from Grant in my personal archives.. =)>>>>Ray>>>>>>>What formula would be used to generate a [shipCost] of $5.00 if the>>>[subTotal] is under $50.00;>>>>>>and a [shipCost] of $0.00 if the [subTotal] is equal to or above $50.00?>>>>That's pretty straightforward...in fact, you can modify the example>>shipCost formula that is based on state, because it shows how to check the>>state. But in your case you would compare against the subtotal instead.>>>>[showif [subtotal]<50]5.00[/showif]0>>>>>>>>>>>>>>At 11:19 AM 11/21/97 -0000, you wrote:>>>I found the follow old message in the archives, but could not find a >>>response. I need to know how to make my shipcost work based on >>>subtotals. For example, if the subtotal is $0 - $5 then the shipping is >>>$5, if $5.01 - $6 it is $7, etc. But I don't see a math value of >>>anything to make that kind of range. Also, how can I say at the end if >>>the subtotal is $100 or more, the shipping is $10?>>>>>>Please help me.>>>>>>Thank you,>>>Janna>>>>>>>>>> From:>>>> David Wilfong (dwilfong@world-wide-art.com)>>>> Date: >>>> Tue, 18 Nov 1997 21:26:49 -0800 (PST)>>>> Subject: >>>> [shipCost] math formula?>>>>What formula would be used to generate a [shipCost] of $5.00 if the>>>>[subTotal] is under $50.00; and a [shipCost] of $0.00 if the[subTotal] is >>>equal to or >>>>above $50.00?>>>>>>>Thanks for the help,>>>>>>>>David Wilfong>>>>dwilfong@world-wide-art.com>>>>World Wide Art - Purveyors of Fine Art on the Internet.>>>>Specializing in Limited Editions by Today's Top Artists.>>>>http://www.world-wide-art.com>>>>>>******************************>>>Janna S. Kohen>>>Big Mind Media L. L. C.>>>http://www.bigmindmedia.com/>>>janna@bigmindmedia.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:
|
- Re: Updating shipcost ( Mark Derrick 2005)
- Updating shipcost ( Mark Derrick 2005)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Shipcost formula ( WJC Limited 2004)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( John Peacock 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Alain Russell 2003)
- Re: the dreaded unitShipCost ( Alain Russell 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( John Peacock 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Tim Robinson 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
- Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
- Re: UnitShipCost Slight Return (Donovan 2003)
- UnitShipCost Slight Return (Alphonse MacDonald 2003)
- Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
- Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
- Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
- Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
- Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
- UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
- Re: shopcost, unitshipcost (Andrew Simpson 2002)
- Re: shopcost, unitshipcost (Donovan Brooke 2002)
- Re: shopcost, unitshipcost (Arturo Vargas 2002)
- Re: shopcost, unitshipcost (Andrew Simpson 2002)
- shopcost, unitshipcost (Arturo Vargas 2002)
- Re: unitShipCost - setlineitem nevermind (Donovan 2002)
- unitShipCost - setlineitem (Donovan 2002)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Glenn Busbin 2001)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Anup Setty 2001)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Anup Setty 2001)
- and more [shipcost].... (Arturo Vargas 2001)
- shipCost problems (Nitai @ Eyework 2000)
- Re: Stumped on ShipCosts.db Problem (Bob McPeak 2000)
- Re: Stumped on ShipCosts.db Problem (John Butler 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- shipCost -vs- shippingtotal ? (John Butler 2000)
- Correction: shipCost (Robert Wade 2000)
- shipCost (Robert Wade 2000)
- Re: shipcost and Formulas.db (John Butler 2000)
- Re: shipcost and Formulas.db (Chris Vargas 2000)
- Re: shipcost and Formulas.db (Chris Vargas 2000)
- Re: shipcost and Formulas.db (John Butler 2000)
- shipcost and Formulas.db (Chris Vargas 2000)
- Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
- Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
- Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
- Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
- Setting shipCost -- thanks! (Chris Vargas 1999)
- Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998)
- ShipCost formula (for weight *and* quantities)? (Dale Stokdyk 1998)
- Re: TaxRate and ShipCost Problem (PCS Technical Support 1998)
- TaxRate and ShipCost Problem (Karl Isselhardt 1998)
- Re: ShipCost and TaxRate problems (PCS Technical Support 1998)
- Re: shipCost (PCS Technical Support 1998)
- Re: shipCost (Brian B. Burton 1998)
- ShipCost and TaxRate problems (Karl Isselhardt 1998)
- Re: shipCost (PCS Technical Support 1998)
- shipCost (Brian B. Burton 1998)
- Re: When is unitShipCost calculated? (Luke Melia 1998)
- Re: When is unitShipCost calculated? (Brian Drum 1998)
- Re: When is unitShipCost calculated? (Brian Drum 1998)
- Re: When is unitShipCost calculated? (PCS Technical Support 1998)
- When is unitShipCost calculated? (Brian Drum 1998)
- Shipcost Based on SubTotal (Michael Fichtenmayer 1998)
- [unitshipcost] values do NOT write to orderfile (Kenneth Grome 1998)
- Re: ShipCost Problems (PCS Technical Support 1998)
- ShipCost Problems (Richard Kirsner 1998)
- Re: ShipCost Data Base (Kenneth Grome 1998)
- Re: ShipCost Data Base (Richard Kirsner 1998)
- Re: ShipCost Data Base (Kenneth Grome 1998)
- Re: ShipCost Data Base (bob 1998)
- ShipCost Data Base (Richard Kirsner 1998)
- Re: shipCost (PCS Technical Support 1998)
- shipCost (Raymond Hatch (by way of Jay Van Vark) 1998)
- Re: shipCost (Raymond Hatch 1998)
- Re: shipcost - cleaner with a table (Brian B. Burton 1998)
- shipcost - cleaner with a table (PCS Technical Support 1998)
- Shipcost Prob solved, new one arises (Kevin Furuta 1998)
- shipcost - fed up with the old way (Kevin Furuta 1998)
- Re: shipcost vs shiptotal (PCS Technical Support 1998)
- shipcost vs shiptotal (Kevin Furuta 1998)
- Re: shipCost not working v2.1b4 (Grant Hulbert 1997)
- Re: shipCost not working v2.1b4 (Pat McCormick 1997)
- Re: shipCost not working v2.1b4 (Pat McCormick 1997)
- shipCost not working v2.1b4 (Pat McCormick 1997)
- more on the Shipcost update problem (Jim Lanford 1997)
- Shipcost update problem (Jim Lanford 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (grichter@panavise.com (Gary Richter) 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- shipcost (Janna S. Kohen 1997)
- Re: [shipCost] math formula? (Grant Hulbert 1997)
- [shipCost] math formula? (dwilfong@world-wide-art.com (David Wilfong) 1997)
- shipCost formula (Janna S. Kohen 1997)
- calculating ShipCost depending on weight (Mike Heininger 1997)
- RE: Tax and ShipCost Problem (Marc Eagle 1997)
- Tax and ShipCost Problem (Mike Heininger 1997)
- THANKS!!! Re: ShipCosts.db and debugging (Dale Stokdyk 1997)
- Re: ShipCosts database (Grant Hulbert 1997)
- Re: ShipCosts database (Dale Stokdyk 1997)
- Re: creating a ShipCosts database (grichter@panavise.com (Gary Richter) 1997)
- Re: creating a ShipCosts database (Grant Hulbert 1997)
- Re: creating a ShipCosts database (Dale Stokdyk 1997)
- Re: creating a ShipCosts database (Grant Hulbert 1997)
- creating a ShipCosts database (Dale Stokdyk 1997)
- Re: unitshipcost vs shipcosts (Grant Hulbert 1997)
- unitshipcost vs shipcosts (Kevin Furuta 1997)
- Re: still having shipCost.db Problem (Richard Wylie 1997)
- Re: still having shipCost.db Problem (Grant Hulbert 1997)
- still having shipCost.db Problem (Richard Wylie 1997)
- Re: Shipcost lookup? (Kenneth Grome 1997)
- Shipcost lookup? (Richard Wylie 1997)
- Re: Further tests with the infamous shipCost (Sven U. Grenander 1997)
- Further tests with the infamous shipCost (w curt eggemeyer 1997)
- Further on formula.db failure to calculate shipCost (w curt eggemeyer 1997)
|
try putting a space between your showif and your [subtotal] [showif [subtotal]>20]1[/showif]RayAt 01:15 PM 11/21/97 -0000, you wrote:>Great Ray. Thank you so much. Now I have another question. I want to >make a series of these, and this is the formula I made, but it doesn't >work. Any ideas?>>[showif >[subtotal]<20]1[/showif][showif[subtotal]>19.99]3[/showif][showif[subtotal]>>39.99]5[/showif][showif >[subtotal]>59.99]7[/showif][showif[subtotal]>79.99]9[/showif][showif >[subtotal]>99.99]11[/showif][showif[subtotal]>129.99]13[/showif][showif[sub>total]>159.99]15[/showif]>>>I found this response from Grant in my personal archives.. =)>>>>Ray>>>>>>>What formula would be used to generate a [shipCost] of $5.00 if the>>>[subTotal] is under $50.00;>>>>>>and a [shipCost] of $0.00 if the [subTotal] is equal to or above $50.00?>>>>That's pretty straightforward...in fact, you can modify the example>>shipCost formula that is based on state, because it shows how to check the>>state. But in your case you would compare against the subtotal instead.>>>>[showif [subtotal]<50]5.00[/showif]0>>>>>>>>>>>>>>At 11:19 AM 11/21/97 -0000, you wrote:>>>I found the follow old message in the archives, but could not find a >>>response. I need to know how to make my shipcost work based on >>>subtotals. For example, if the subtotal is $0 - $5 then the shipping is >>>$5, if $5.01 - $6 it is $7, etc. But I don't see a math value of >>>anything to make that kind of range. Also, how can I say at the end if >>>the subtotal is $100 or more, the shipping is $10?>>>>>>Please help me.>>>>>>Thank you,>>>Janna>>>>>>>>>> From:>>>> David Wilfong (dwilfong@world-wide-art.com)>>>> Date: >>>> Tue, 18 Nov 1997 21:26:49 -0800 (PST)>>>> Subject: >>>> [shipCost] math formula?>>>>What formula would be used to generate a [shipCost] of $5.00 if the>>>>[subTotal] is under $50.00; and a [shipCost] of $0.00 if the[subTotal] is >>>equal to or >>>>above $50.00?>>>>>>>Thanks for the help,>>>>>>>>David Wilfong>>>>dwilfong@world-wide-art.com>>>>World Wide Art - Purveyors of Fine Art on the Internet.>>>>Specializing in Limited Editions by Today's Top Artists.>>>>http://www.world-wide-art.com>>>>>>******************************>>>Janna S. Kohen>>>Big Mind Media L. L. C.>>>http://www.bigmindmedia.com/>>>janna@bigmindmedia.com >>>>>>>>>>>>>>******************************>Janna S. Kohen>Big Mind Media L. L. C.>http://www.bigmindmedia.com/>janna@bigmindmedia.com >>>
Raymond Hatch
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:
webdelivery.tmpl???? (1997)
&FieldNametype=time unnecessary? (2000)
Roundup (2001)
New York City sales tax database needed (1997)
Intermitent problem using [referrer] (1997)
Using the Tearoom Teamplates (2000)
[countWords]? (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
Generating Options for a Form. (1997)
A question on sub-categories (1997)
WebTV (1998)
Lock out multiple users with same password? (1999)
splitting numbers in webDNA? (1997)
[/application] error? (1997)
RE: OK, here goes... (1997)
Country & Ship-to address & other fields ? (1997)
formula??? (2000)
What is WebDNA (1997)
Global Function (2003)
Re:Emailer and encryption (1997)