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 is evaluated to get the proper [price], [unitShipCost] and [taxable] for that lineitem. When you ShowCart or Purchase, the formulas for [taxRate] and [shipCost] are evaluated for the whole cart (but individual lineitems are never 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 your invoice 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 be coming from. Perhaps you meant eqShipMethdatarq=[shipVia]?Try simplifying this by putting every little piece of WebDNA onto separate lines 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 going on 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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re:my First Ship table (PCS Technical Support 1998)
  2. Re:my First Ship table (Tim Taylor 1998)
  3. Re:my First Ship table (PCS Technical Support 1998)
  4. Re:my First Ship table (Tim Taylor 1998)
>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 is evaluated to get the proper [price], [unitShipCost] and [taxable] for that lineitem. When you ShowCart or Purchase, the formulas for [taxRate] and [shipCost] are evaluated for the whole cart (but individual lineitems are never 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 your invoice 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 be coming from. Perhaps you meant eqShipMethdatarq=[shipVia]?Try simplifying this by putting every little piece of WebDNA onto separate lines 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 going on 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 | Typhoon 619/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)