Re: [shippingtotal] Fixed...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45759
interpreted = N
texte = D'oh!Just had to add this on the template after all the [setlineitems] and such, and changed Formulas.db back to the standard shipping equation:[math show=f]ordered=0[/math] [orderfile ShoppingCarts/[GetCookie SessionID]] [lineitems][math show=f]ordered=[ordered]+[quantity][/math][/lineitems][/orderfile] [showif [ordered]=1][setheader cart=[GetCookie SessionID]&db=catalog.db]shippingTotal=6.50[/setheader][/showif] [showif [ordered]>1][setheader cart=[GetCookie SessionID]&db=catalog.db]shippingTotal=0.00[/setheader][/showif]Thanks a trillion, John!Thanks too Donovan...!You've saved Christmas!-WillOn Wednesday, November 27, 2002, at 09:15 AM, John Peacock wrote:> WJ Starck wrote: >> Now, the million dollar question: >> 1) How can I use the above in Formulas.db to properly calculate the >> shipping charges? > > You cannot affect existing line items, unless you delete the lines and > readd them. Formulas.db only fires upon [addlineitem] context (or > ?command=add but you should really use the context). > >> 2) Can I somehow override the shipping cost calculated in Formulas.db >> with the above WebDNA in a template? > > Use a [lineitems] loop and [setlineitem] (with a password) to alter > the individual lines. Use a [setheader] to alter the header ShipCost > field itself. My preferred method is to always use contexts to add > line items at the top of the target page (which may very well be the > cart page itself), so I can preprocess the lines anywhich way I want. > I can add hidden lineitems (for a discount for example) or walk the > lines and delete/alter existing items. > > Since you have such a simple shipping scheme, I would just use the > header and set all of the line items unitshipcost to 0. Just have a > loop at the top of the cart page which loops through the line items > and updates the shipcost header field accordingly. > > HTH > > John > > -- > John Peacock > Director of Information Research and Technology > Rowman & Littlefield Publishing Group > 4720 Boston Way > Lanham, MD 20706 > 301-459-3366 x.5010 > fax 301-429-5747 > > > ------------------------------------------------------------- > 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:
| |
- Re: [shippingtotal] Fixed... (WJ Starck 2002)
|
D'oh!Just had to add this on the template after all the [setlineitems] and such, and changed formulas.db back to the standard shipping equation:[math show=f]ordered=0[/math] [orderfile ShoppingCarts/[GetCookie SessionID]] [lineitems][math show=f]ordered=[ordered]+[quantity][/math][/lineitems][/orderfile] [showif [ordered]=1][setheader cart=[GetCookie SessionID]&db=catalog.db]shippingTotal=6.50[/setheader][/showif] [showif [ordered]>1][setheader cart=[GetCookie SessionID]&db=catalog.db]shippingTotal=0.00[/setheader][/showif]Thanks a trillion, John!Thanks too Donovan...!You've saved Christmas!-WillOn Wednesday, November 27, 2002, at 09:15 AM, John Peacock wrote:> WJ Starck wrote: >> Now, the million dollar question: >> 1) How can I use the above in formulas.db to properly calculate the >> shipping charges? > > You cannot affect existing line items, unless you delete the lines and > readd them. formulas.db only fires upon [addlineitem] context (or > ?command=add but you should really use the context). > >> 2) Can I somehow override the shipping cost calculated in formulas.db >> with the above WebDNA in a template? > > Use a [lineitems] loop and [setlineitem] (with a password) to alter > the individual lines. Use a [setheader] to alter the header ShipCost > field itself. My preferred method is to always use contexts to add > line items at the top of the target page (which may very well be the > cart page itself), so I can preprocess the lines anywhich way I want. > I can add hidden lineitems (for a discount for example) or walk the > lines and delete/alter existing items. > > Since you have such a simple shipping scheme, I would just use the > header and set all of the line items unitshipcost to 0. Just have a > loop at the top of the cart page which loops through the line items > and updates the shipcost header field accordingly. > > HTH > > John > > -- > John Peacock > Director of Information Research and Technology > Rowman & Littlefield Publishing Group > 4720 Boston Way > Lanham, MD 20706 > 301-459-3366 x.5010 > fax 301-429-5747 > > > ------------------------------------------------------------- > 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:
tpl and Explorer (1998)
Encrypt Decrypt URL UnURL Weirdness (2001)
Requiring that certain fields be completed (1997)
RE: Problems reading files created by WC (1997)
charging? (2001)
WebCommerce: Folder organization ? (1997)
2.1b3 --> way slow (1997)
WebCat2b15MacPlugin - [protect] (1997)
Forms Search Questions (1997)
RE: Promise of future help (1998)
Hiding HTML and page breaks (1997)
date and time stamp (2003)
customers getting same cart (2004)
Languages (1997)
Accented chars and emailer (1998)
Quit revisited (1997)
TEXTA-D (2003)
SKU (1997)
Linux WebDNA Server probs (2004)
WebMerchant 1.6 and SHTML (1997)