Re: [shippingtotal] & Formulas.db prob

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50502
interpreted = N
texte = Will, Since 90% of formulas.db problems are going to be problems of syntax it does more good to Copy/paste your exact code then to post generalities.90% was derived from a thurough test study done by Gallup Poles Inc. 12,000 WebDNA users were called during dinner for their accurate opinion.DonovanWJ Starck wrote: > > Ah sorry, here is the correct formula > > [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=ordersubtotal&returnfield=insuranc > e] > [/showif] > [showif [subtotal]>50] > [showif [subtotal]<100.01] > [lookup > db=dbs/ > uspsinsurance.db&value=100&lookinfield=ordersubtotal&returnfield=insuran > ce] > [/showif] > > [loop start=100&end=5000&advance=100] > [showif [subtotal]>[index].01] > [lookup > db=dbs/ > uspsinsurance.db&value=[index]&lookinfield=ordersubtotal&returnfield=ins > urance] > [/showif] > [/loop] > [/showif] > [/showif] > [/showif] > [/math][/format] > > -W > > On Tuesday, May 20, 2003, at 12:06 PM, WJ Starck wrote: > > > This formula is in formulas.db like so > > > > shipcost formula > > > > where the formula is (minus the white space of course) > > > > [format .2f][math] > > > > [showif [subtotal]<45][lookup > > db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=Ship > > Cost][/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=insuran > > ce] > > [/showif] > > [/loop] > > [/showif] > > [/showif] > > [/showif] > > [/math][/format] > > > > In Shipcosts.db I have > > > > Shipmethod Shipcost > > freeship 0.00 > > priority 6.50 > > > > Basically, 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/ > > > > > -- > > 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/------------------------------------------------------------- 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)
Will, Since 90% of formulas.db problems are going to be problems of syntax it does more good to Copy/paste your exact code then to post generalities.90% was derived from a thurough test study done by Gallup Poles Inc. 12,000 WebDNA users were called during dinner for their accurate opinion.DonovanWJ Starck wrote: > > Ah sorry, here is the correct formula > > [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=ordersubtotal&returnfield=insuranc > e] > [/showif] > [showif [subtotal]>50] > [showif [subtotal]<100.01] > [lookup > db=dbs/ > uspsinsurance.db&value=100&lookinfield=ordersubtotal&returnfield=insuran > ce] > [/showif] > > [loop start=100&end=5000&advance=100] > [showif [subtotal]>[index].01] > [lookup > db=dbs/ > uspsinsurance.db&value=[index]&lookinfield=ordersubtotal&returnfield=ins > urance] > [/showif] > [/loop] > [/showif] > [/showif] > [/showif] > [/math][/format] > > -W > > On Tuesday, May 20, 2003, at 12:06 PM, WJ Starck wrote: > > > This formula is in formulas.db like so > > > > shipcost formula > > > > where the formula is (minus the white space of course) > > > > [format .2f][math] > > > > [showif [subtotal]<45][lookup > > db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=Ship > > Cost][/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=insuran > > ce] > > [/showif] > > [/loop] > > [/showif] > > [/showif] > > [/showif] > > [/math][/format] > > > > In Shipcosts.db I have > > > > Shipmethod Shipcost > > freeship 0.00 > > priority 6.50 > > > > Basically, 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/ > > > > > -- > > 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/------------------------------------------------------------- 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/ dbrooke

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:

Banners and sort of random display (1997) problems with WebCat-Plugin () Who is doing sign-ups-got it (1998) Cart date/time (2006) Uploading out of FMP (2001) authenticate and password (1998) [WebDNA] sendmail attached file (2011) OLD ORDERS (1998) Quiestion (1997) Execute Applescript (1997) WebCat2b13MacPlugIn - more [date] problems (1997) X Server (1999) restart needed???? (1997) redhat 9.0 (2003) Showing unopened cart (1997) Multiple Pulldowns (1997) Looking for a Manual (1997) SetHeader not Working (2006) Running _every_ page through WebCat ? (1997) too many nested tags ... (1997)