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 syntaxit 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:
Will,Since 90% of formulas.db problems are going to be problems of syntaxit 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:
Safari cookies (2006)
[WebDNA] Warning about a bad client (2015)
Mozilla/4. and Browser Info.txt (1997)
Generating Report Totals (1997)
creative use of webcatalog (1998)
Sorting by date (1997)
New WebDNA Solutions ... (1997)
Mac 2.1b4 unknown error: BadSuffix (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
[shownext max=?] armed (1997)
NT version (1997)
Previous and Next Solution (2004)
syntax question, not in online refernce (1997)
Checking two required fields (1998)
Help formatting search results w/ table (1997)
b12 cannot limit records returned and more. (1997)
Emailer (WebCat2) (1997)
Last desperate attempt (1998)
send mail problem? (1997)
cart (1997)