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:
>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:
Items XX to XX shown (1997)
New Year Trigger Problem (2003)
Duplicate Cart ID (2001)
RE: shrink-wrapped version out yet? (1997)
Addlineitems SKU peramiter (2002)
Encrypting the URL Query String (2003)
Initiating NewCart (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Almost a there but..bye bye NetCloak (1997)
combining strings (1997)
SandBox and ImageMagick (2003)
Summing fields (1997)
PCS Frames (1997)
payflowpro problem #2 (2003)
carriage returns in data (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Setting the Date (2000)
back button problem (1999)
Bug Report, maybe (1997)
FlushDatabase Suggestion (1998)