THANKS!!! Re: ShipCosts.db and debugging

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 12854
interpreted = N
texte = Grant,Thanks for the late-nite response to my query (read: my nearly desparateplea for help!). Everything works fine now! I think there may have been2 problems:1) an error in my ShipCost formula (although, for the life of me, Icouldn't see any character-for-character difference when compared to theone you emailed); and2) a problem with the Shipcosts.db (there must have been an additionaltab or CR somewhere!)Thanks for the debugging advice as well! My snips were working...but Iwasn't getting anything when the entire formula was strung together.Which leads to my next question about debugging...can you provide somemore details regarding the syntax errors you warned against (such as1+A or 5- or the elusive 1+)? Also, is there any documentation for ShippingTotal tag...yes, I didassume it's (sum of unitShipCost's + shipCost)?Thanks again for putting 2 days of frustration to end! Dale dstokdyk@dvs.mv.comp.s. -- here's the rest of the dialog for the public talk list:--------------------------------------------------------Grant Hulbert wrote:> > But....what I need the formula to do is add all the weights, *then* look> up the corresponding cost! I think what I need is a new variable,> something like SumWeights, then use your formula to lookup the cost for> NextDay or Ground by SumWeights.You can sum the weights right in the math formula:[math][lineitems][weight]+[/lineitems]0[/math]use that instead of just [weight], which would only use the one weightyou just added to the cart.Dale wrote:Thanks again, Grant! But I ran off the road somewhere....Before I try adding the math calculation for total shipping weight(below), I need some help ingetting the original formula to work for shipCosts:[lookupdb=shipcosts.db&lookInField=weight&value=[weight}&returnField=[shipVia]}I realized this morning that I had some other funky stuff going onwith my shipping cost calculations...namely, that numbers I had thrownin to test the unitShipCost field were throwing off the number. I thinkbecause I was using the totalShippingCosts tag (from the General Storeexample). (BTW--couldn't find documentation for totalShippingCosts, although Ibelieve it's supposesd to add shipCosts and unitShipCosts, right?)So...to cut to the chase...I'm using [shipCosts] in my Invoice.tmpl, butam getting no output (I set shipCosts equal to the formula in theformulas.db.--this is OK, right?)Am trying to debug by throwing snips into the ShoppingCart.tmpl, and amseeing:* weight for each item* total weights* but nothing for the lookup formula aboveCan you provide some advice on further debugging? It's as if theshipCosts db. didn't exist (it shows up fine in ADMIN)!?! Grant Hulbert wrote:> When you get no output from a [math] context, that means it has a syntax error in it, such as 1+A or 5- or the elusive 1+, where is an accidental carriage return from an include file or some other source.> > >[lookup db=shipcosts.db&lookInField=weight&value=[weight}&returnField=[shipVia]}> >* but nothing for the lookup formula above> > If you are truly using this formula, the curly-braces are a no-no. I also notice you are adding 's' to the end of many tags, where no 's' truly exists.> > >Can you provide some advice on further debugging? It's as if the> >shipCosts db. didn't exist (it shows up fine in ADMIN)!?!> > Start by putting the equation into your shopping cart page, so you can see the output of what will eventually go into the formula database:> > shipVia: [shipVia]
> > list of weights: [lineItems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight],[/lineItems]
> > sum of weights: [math][lineItems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]
> > desired shipCost: [lookup db=shipcosts.db&lookInField=weight&value=[math][lineItems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]&returnField=[shipVia]]> > And then, once you're happy with the results, you can paste that formula into the shipCost database (remember at this point you should zero out any unitShipCost values you might have in your product catalog, because the assumption is (sum of unitShipCost's + shipCost), and we're setting up a formula here that includes all the costs into the one shipCost variable.> > -- formulas.db --> shipCost [lookup db=shipcosts.db&lookInField=weight&value=[math][lineItems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]&returnField=[shipVia]]> > I haven't tried any of these formulas out, because my wife is calling me to sleep, but it's the general idea.> > If this stuff works, please post it to the public talk list so everyone can learn. Associated Messages, from the most recent to the oldest:

Grant,Thanks for the late-nite response to my query (read: my nearly desparateplea for help!). Everything works fine now! I think there may have been2 problems:1) an error in my ShipCost formula (although, for the life of me, Icouldn't see any character-for-character difference when compared to theone you emailed); and2) a problem with the Shipcosts.db (there must have been an additionaltab or CR somewhere!)Thanks for the debugging advice as well! My snips were working...but Iwasn't getting anything when the entire formula was strung together.Which leads to my next question about debugging...can you provide somemore details regarding the syntax errors you warned against (such as1+A or 5- or the elusive 1+)? Also, is there any documentation for ShippingTotal tag...yes, I didassume it's (sum of unitShipCost's + shipCost)?Thanks again for putting 2 days of frustration to end! Dale dstokdyk@dvs.mv.comp.s. -- here's the rest of the dialog for the public Talk List:--------------------------------------------------------Grant Hulbert wrote:> > But....what I need the formula to do is add all the weights, *then* look> up the corresponding cost! I think what I need is a new variable,> something like SumWeights, then use your formula to lookup the cost for> NextDay or Ground by SumWeights.You can sum the weights right in the math formula:[math][lineitems][weight]+[/lineitems]0[/math]use that instead of just [weight], which would only use the one weightyou just added to the cart.Dale wrote:Thanks again, Grant! But I ran off the road somewhere....Before I try adding the math calculation for total shipping weight(below), I need some help ingetting the original formula to work for shipCosts:[lookupdb=shipcosts.db&lookInField=weight&value=[weight}&returnField=[shipVia]}I realized this morning that I had some other funky stuff going onwith my shipping cost calculations...namely, that numbers I had thrownin to test the unitShipCost field were throwing off the number. I thinkbecause I was using the totalShippingCosts tag (from the General Storeexample). (BTW--couldn't find documentation for totalShippingCosts, although Ibelieve it's supposesd to add shipCosts and unitShipCosts, right?)So...to cut to the chase...I'm using [shipCosts] in my Invoice.tmpl, butam getting no output (I set shipCosts equal to the formula in theformulas.db.--this is OK, right?)Am trying to debug by throwing snips into the ShoppingCart.tmpl, and amseeing:* weight for each item* total weights* but nothing for the lookup formula aboveCan you provide some advice on further debugging? It's as if theshipCosts db. didn't exist (it shows up fine in ADMIN)!?! Grant Hulbert wrote:> When you get no output from a [math] context, that means it has a syntax error in it, such as 1+A or 5- or the elusive 1+, where is an accidental carriage return from an include file or some other source.> > >[lookup db=shipcosts.db&lookInField=weight&value=[weight}&returnField=[shipVia]}> >* but nothing for the lookup formula above> > If you are truly using this formula, the curly-braces are a no-no. I also notice you are adding 's' to the end of many tags, where no 's' truly exists.> > >Can you provide some advice on further debugging? It's as if the> >shipCosts db. didn't exist (it shows up fine in ADMIN)!?!> > Start by putting the equation into your shopping cart page, so you can see the output of what will eventually go into the formula database:> > shipVia: [shipVia]
> > list of weights: [lineitems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight],[/lineItems]
> > sum of weights: [math][lineitems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]
> > desired shipCost: [lookup db=shipcosts.db&lookInField=weight&value=[math][lineitems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]&returnField=[shipVia]]> > And then, once you're happy with the results, you can paste that formula into the shipCost database (remember at this point you should zero out any unitShipCost values you might have in your product catalog, because the assumption is (sum of unitShipCost's + shipCost), and we're setting up a formula here that includes all the costs into the one shipCost variable.> > -- formulas.db --> shipCost [lookup db=shipcosts.db&lookInField=weight&value=[math][lineitems][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=weight]+[/lineItems]0[/math]&returnField=[shipVia]]> > I haven't tried any of these formulas out, because my wife is calling me to sleep, but it's the general idea.> > If this stuff works, please post it to the public Talk List so everyone can learn. Dale Stokdyk

DOWNLOAD WEBDNA NOW!

THANKS!!! Re: ShipCosts.db and debugging

1997

Top Articles:

Related Readings: