Re:my First Ship table
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20994
interpreted = N
texte = >I guess what I don't understand is when exactly webcat looks into>Formulas.db, when an item is added to the cart, or when the shopping cart>is submitted to Invoice.tpl.Both times. For instance, when you Add to the cart, the formula isevaluated to get the proper [price], [unitShipCost] and [taxable] for thatlineitem. When you ShowCart or Purchase, the formulas for [taxRate] and[shipCost] are evaluated for the whole cart (but individual lineitems arenever touched once they have been added to the cart).>What I am trying to do in formulas.db is have it total up quantity, and>match that total to the [shipMeth] field and return [shipCost] which will>then become [shipTotal] on invoice.tpl and be added to [subTotal] for the>[grandTotal]Have you tried seeing what this formula displays when you drop it into yourinvoice page in such a way that it is visible to you? For instance,[shipMeth] is not a cart variable, so I don't know where that would becoming from. Perhaps you meant eqShipMethdatarq=[shipVia]?Try simplifying this by putting every little piece of WebDNA onto separatelines in your template so you can see what they evaluate to individually.This way you don't have to try to be a magician and figure out what's goingon invisibly inside the formula.Also, where's the beginning [Search part of your formula?>shipCost>> db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=[math][lineit>ems][quantity]+[/lineitems]0[/math]][FoundItems][shipCost][/FoundItems][/Search>]Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I guess what I don't understand is when exactly webcat looks into>
formulas.db, when an item is added to the cart, or when the shopping cart>is submitted to Invoice.tpl.Both times. For instance, when you Add to the cart, the formula isevaluated to get the proper [price], [unitShipCost] and [taxable] for thatlineitem. When you ShowCart or Purchase, the formulas for [taxRate] and[shipCost] are evaluated for the whole cart (but individual lineitems arenever touched once they have been added to the cart).>What I am trying to do in
formulas.db is have it total up quantity, and>match that total to the [shipMeth] field and return [shipCost] which will>then become [shipTotal] on invoice.tpl and be added to [subTotal] for the>[grandTotal]Have you tried seeing what this formula displays when you drop it into yourinvoice page in such a way that it is visible to you? For instance,[shipMeth] is not a cart variable, so I don't know where that would becoming from. Perhaps you meant eqShipMethdatarq=[shipVia]?Try simplifying this by putting every little piece of WebDNA onto separatelines in your template so you can see what they evaluate to individually.This way you don't have to try to be a magician and figure out what's goingon invisibly inside the formula.Also, where's the beginning [Search part of your formula?>shipCost>> db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=
[math][lineit>ems][quantity]+[/lineitems]0[/math]]
[founditems][shipCost][/FoundItems][/Search>]Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
OT: Amazon Patents (2000)
Was: Privacy Issue (Now: License For sale) (2003)
AAAH: stupid sendmail (2001)
3 card formulas! (1999)
emailer (1997)
JavaScript (1998)
web delivery (1997)
brain teaser with an advanced search (2001)
Non-repeating Random Numbers (2002)
movefile occasionally not working (long, code included) (2001)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
WebCat2 several catalogs? (1997)
Conditional Redirect (2004)
Under Score (1999)
unable to run webcatalog locally (1998)
multiple search commands (1997)
I give up!! (1997)
[WebDNA] Hmmm ... (2008)
$purchase vs [purchase] (1999)
Help! WebCat2 bug (1997)