Re: [shippingtotal] in Formulas.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45746
interpreted = N
texte = No to both questions.However, here's what I did for a quick fix:Set the Shipcost in Formulas,db to double the normal shipping value, in this case $13.00Gave each item a UnitShipCost of $-6.50Then when one item is added, the shippingtotal is $13.00 -6.50 = $6.50When more than one item is added, [shippingtotal] is $13.00-6.50-6.50...=0I like this because I don't have to have some crazy formula that accounts for the number of lineitems *and* the quantities of lineitems.Bleah, my head was starting to spin. Maybe they should name the next big ride at Six Flags the FormulasDB!?!;)-WillOn Tuesday, November 26, 2002, at 08:24 PM, Donovan Brooke wrote:> Do you have unitshipcosts being applied to the lineitems? > > ShipCost doesn't override these values, it adds to the total of them. > Also, I assume you don't have any CR's in the formulas.db. :-) > > note.. You can overide the shippingtotal with a setheader. > > Donovan > > > > WJ Starck wrote: > >> In an attempt to offer free shipping when 2 or more products are >> ordered, I have this in Formulas.db: >> >> [orderfile ShoppingCarts/[GetCookie SessionID]][lineitems][math >> show=f]ordered=[lineindex][/math][/lineitems][/orderfile][showif >> [ordered]>1]0.00[/showif][showif [ordered]<2]6.50[/showif] >> >> When 1 item is added to the cart the shipping ([shippingtotal]) is >> correctly figured. >> >> When a second item is added the shipping does not change to 0 >> >> When the third and any further items are added the shipping changes >> to >> 0. >> >> Why the lag? >> >> -Will >> > > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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: [shippingtotal] in Formulas.db (WJ Starck 2002)
  2. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  3. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  4. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  5. [shippingtotal] in Formulas.db (WJ Starck 2002)
No to both questions.However, here's what I did for a quick fix:Set the Shipcost in Formulas,db to double the normal shipping value, in this case $13.00Gave each item a UnitShipCost of $-6.50Then when one item is added, the shippingtotal is $13.00 -6.50 = $6.50When more than one item is added, [shippingtotal] is $13.00-6.50-6.50...=0I like this because I don't have to have some crazy formula that accounts for the number of lineitems *and* the quantities of lineitems.Bleah, my head was starting to spin. Maybe they should name the next big ride at Six Flags the FormulasDB!?!;)-WillOn Tuesday, November 26, 2002, at 08:24 PM, Donovan Brooke wrote:> Do you have unitshipcosts being applied to the lineitems? > > ShipCost doesn't override these values, it adds to the total of them. > Also, I assume you don't have any CR's in the formulas.db. :-) > > note.. You can overide the shippingtotal with a setheader. > > Donovan > > > > WJ Starck wrote: > >> In an attempt to offer free shipping when 2 or more products are >> ordered, I have this in formulas.db: >> >> [orderfile ShoppingCarts/[GetCookie SessionID]][lineitems][math >> show=f]ordered=[lineindex][/math][/lineitems][/orderfile][showif >> [ordered]>1]0.00[/showif][showif [ordered]<2]6.50[/showif] >> >> When 1 item is added to the cart the shipping ([shippingtotal]) is >> correctly figured. >> >> When a second item is added the shipping does not change to 0 >> >> When the third and any further items are added the shipping changes >> to >> 0. >> >> Why the lag? >> >> -Will >> > > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ WJ Starck

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:

Format of Required fields error message (1997) [CART] inside a [LOOP] (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) encryption in browser? NOT (1998) Alternating colors (1997) Is there a max number of fields? (1998) math problems (2000) Question on lineitems (2002) SiteCheck & WebCat ? (1997) Need help with emailer- 2 issues (1997) Encrypted items in DB (2001) Server IP address? (1998) Undeliverable Mail (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) form ENCTYPE confusion (2003) eMailer replacement? (1998) lookups or math? (1998) Help! WebCat2 bug (1997) Is this possible, WebCat2.0 and checkboxes (1997) Universal root for WC errors? (1997)