[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 Shipcost freeship 0.00 priority 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 insurance 50 1.30 100 2.20 200 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 Starck NovaDerm Skincare Science http://www.novaderm.com wjs@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:

    
  1. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  2. Re: [shippingtotal] & Formulas.db prob (Gary Krockover 2003)
  3. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  4. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  5. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  6. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  7. [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  8. Re: [shippingtotal] still... (John Peacock 2002)
  9. Re: [shippingtotal] still... (Donovan 2002)
  10. Re: [shippingtotal] still... (John Peacock 2002)
  11. Re: [shippingtotal] still... (Donovan 2002)
  12. Re: [shippingtotal] Fixed... (WJ Starck 2002)
  13. Re: [shippingtotal] still... (Donovan 2002)
  14. Re: [shippingtotal] still... (John Peacock 2002)
  15. [shippingtotal] still... (WJ Starck 2002)
  16. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  17. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  18. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  19. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  20. [shippingtotal] in Formulas.db (WJ Starck 2002)
  21. [shipTotal] or [shippingTotal] ??? (Kenneth Grome 1998)
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 Shipcost freeship 0.00 priority 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 insurance 50 1.30 100 2.20 200 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 Starck NovaDerm Skincare Science http://www.novaderm.com wjs@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)