[shippingtotal] & Formulas.db prob
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50499
interpreted = N
texte = This formula is in formulas.db like soshipcost formulawhere the formula is (minus the white space of course)[format .2f][math][showif [subtotal]<45][lookup db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=ShipC ost][/showif][showif [subtotal]>44.99]0.00[/showif][showif [thisurl]^verify] [showif priorityfreeship^[shipvia]] +[showif [subtotal]<50.01] [lookup db=dbs/ uspsinsurance.db&value=50&lookinfield=subtotal&returnfield=insurance] [/showif] [showif [subtotal]>50] [showif [subtotal]<100.01] [lookup db=dbs/ uspsinsurance.db&value=100&lookinfield=subtotal&returnfield=insurance] [/showif] [loop start=100&end=5000&advance=100] [showif [subtotal]>[index].01] [lookup db=dbs/ uspsinsurance.db&value=[index]&lookinfield=subtotal&returnfield=insuranc e] [/showif] [/loop] [/showif] [/showif][/showif][/math][/format]In Shipcosts.db I haveShipmethod Shipcostfreeship 0.00priority 6.50Basically, shipping is free if $45 or more is ordered, but insurance costs are always figured for every order.uspsinsurance.db looks like:ordersubtotal insurance50 1.30100 2.20200 3.20...It calculates correctly when the above WebDNA is placed on a template inside an orderfile context, but [shippingtotal] is still showing 0.00 inside the same orderfile context.Can anyone see why?Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
This formula is in formulas.db like soshipcost formulawhere the formula is (minus the white space of course)[format .2f][math][showif [subtotal]<45][lookup db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=ShipC ost][/showif][showif [subtotal]>44.99]0.00[/showif][showif [thisurl]^verify] [showif priorityfreeship^[shipvia]] +[showif [subtotal]<50.01] [lookup db=dbs/ uspsinsurance.db&value=50&lookinfield=subtotal&returnfield=insurance] [/showif] [showif [subtotal]>50] [showif [subtotal]<100.01] [lookup db=dbs/ uspsinsurance.db&value=100&lookinfield=subtotal&returnfield=insurance] [/showif] [loop start=100&end=5000&advance=100] [showif [subtotal]>[index].01] [lookup db=dbs/ uspsinsurance.db&value=[index]&lookinfield=subtotal&returnfield=insuranc e] [/showif] [/loop] [/showif] [/showif][/showif][/math][/format]In Shipcosts.db I haveShipmethod Shipcostfreeship 0.00priority 6.50Basically, shipping is free if $45 or more is ordered, but insurance costs are always figured for every order.uspsinsurance.db looks like:ordersubtotal insurance50 1.30100 2.20200 3.20...It calculates correctly when the above WebDNA is placed on a template inside an orderfile context, but [shippingtotal] is still showing 0.00 inside the same orderfile context.Can anyone see why?Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
WJ Starck
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:
nested ListWords? (2003)
More questions about serial number dishing (1997)
Setting up shop (1997)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
[delete] problem (1997)
More on the email templates (1997)
Setting up WebCatalog with Retail Pro data (1996)
[OT] I am old. (2003)
code to phantom spacing (2001)
WebCatalog NT beta 18 now available (1997)
webcat- multiple selection in input field (1997)
RE: textA and Title? (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
[OT] HTML Table Cell Problem (2003)
WebCat2.0 [format thousands .0f] no go (1997)
Associative lookup style? (1997)
db merge problem (2002)
RE: Emailer prefs in two places ... (1997)
[append] and SSL (1997)
WebCatalog for guestbook ? (1997)