Re:my First Ship table

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 21024
interpreted = N
texte = Okay, I took your advice and changed a lot of things around and finallygot this lookup to work if I write it into invoice.tplCourier [lookupdb=customShipping.txt&lookInField=sam&value=[math][lineitems][quantity]+[/lineitems]0[/math][shipVia]&returnField=shipCost¬Found=555]it works it displays 7.75 --- perfect.However my formulas.db has the exact same lookup....shipCost [lookupdb=customShipping.txt&lookInField=sam&value=[math][lineitems][quantity]+[/lineitems]0[/math][shipVia]&returnField=shipCost¬Found=555]I has ZERO effect on shipTotal or ShipCost. It won't even return 555I checked the following things...WebCatalog does see formulas.db as a database after Iflusheddatabases and reloaded and it says 2 fields 3 records which ithas... What is different about the looking up from formulas.db anddoing the lookup on invoice.tpl. I need the value to be passed on toshipTotal so the value can be totales and passed on smoothly.Any Ideas?Timit went...>>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 shoppingcart>>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] forthat>lineitem. When you ShowCart or Purchase, the formulas for [taxRate]and>[shipCost] are evaluated for the whole cart (but individual lineitemsare>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] whichwill>>then become [shipTotal] on invoice.tpl and be added to [subTotal] forthe>>[grandTotal]>>Have you tried seeing what this formula displays when you drop it intoyour>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 wouldbe>coming from. Perhaps you meant eqShipMethdatarq=[shipVia]?>>Try simplifying this by putting every little piece of WebDNA ontoseparate>lines in your template so you can see what they evaluate toindividually.>This way you don't have to try to be a magician and figure out what'sgoing>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:

Re:my First Ship table (PCS Technical Support 1998)
Re:my First Ship table (Tim Taylor 1998)
Re:my First Ship table (PCS Technical Support 1998)
Re:my First Ship table (Tim Taylor 1998)

Okay, I took your advice and changed a lot of things around and finallygot this lookup to work if I write it into invoice.tplCourier [lookupdb=customShipping.txt&lookInField=sam&value=[math][lineitems][quantity]+[/lineitems]0[/math][shipVia]&returnField=shipCost¬Found=555]it works it displays 7.75 --- perfect.However my formulas.db has the exact same lookup....shipCost [lookupdb=customShipping.txt&lookInField=sam&value=[math][lineitems][quantity]+[/lineitems]0[/math][shipVia]&returnField=shipCost¬Found=555]I has ZERO effect on shipTotal or ShipCost. It won't even return 555I checked the following things...WebCatalog does see formulas.db as a database after Iflusheddatabases and reloaded and it says 2 fields 3 records which ithas... What is different about the looking up from formulas.db anddoing the lookup on invoice.tpl. I need the value to be passed on toshipTotal so the value can be totales and passed on smoothly.Any Ideas?Timit went...>>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 shoppingcart>>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] forthat>lineitem. When you ShowCart or Purchase, the formulas for [taxRate]and>[shipCost] are evaluated for the whole cart (but individual lineitemsare>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] whichwill>>then become [shipTotal] on invoice.tpl and be added to [subTotal] forthe>>[grandTotal]>>Have you tried seeing what this formula displays when you drop it intoyour>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 wouldbe>coming from. Perhaps you meant eqShipMethdatarq=[shipVia]?>>Try simplifying this by putting every little piece of WebDNA ontoseparate>lines in your template so you can see what they evaluate toindividually.>This way you don't have to try to be a magician and figure out what'sgoing>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/

Tim Taylor

DOWNLOAD WEBDNA NOW!

Re:my First Ship table

1998

Top Articles:

Related Readings: