Re: [shippingtotal] & Formulas.db prob
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50504
interpreted = N
texte = WJ Starck wrote:> > Huh?> > What generalities?> > I've posted all or the exact relevant code.> > Are we reading the same email?you said.. minus white space of course.This not only could be the cause of the 0.00 buttells me you rewrote or edited the code uponsending the email.don't get mad.. just been down this road before. ;-)Donovan> > --> > Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@novaderm.com> > On Tuesday, May 20, 2003, at 02:00 PM, dbrooke wrote:> > > 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.> >> > Donovan> >> >> >> > WJ Starck wrote:> >>> >> Ah sorry, here is the correct formula> >>> >> [format .2f][math]> >>> >> [showif [subtotal]<45][lookup> >> db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=Shi> >> pC> >> 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=insura> >> nc> >> e]> >> [/showif]> >> [showif [subtotal]>50]> >> [showif [subtotal]<100.01]> >> [lookup> >> db=dbs/> >> uspsinsurance.db&value=100&lookinfield=ordersubtotal&returnfield=insur> >> an> >> ce]> >> [/showif]> >>> >> [loop start=100&end=5000&advance=100]> >> [showif [subtotal]>[index].01]> >> [lookup> >> db=dbs/> >> uspsinsurance.db&value=[index]&lookinfield=ordersubtotal&returnfield=i> >> ns> >> 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=Sh> >>> ip> >>> 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=insur> >>> an> >>> 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/> >> >> > -------------------------------------------------------------> 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:
WJ Starck wrote:> > Huh?> > What generalities?> > I've posted all or the exact relevant code.> > Are we reading the same email?you said.. minus white space of course.This not only could be the cause of the 0.00 buttells me you rewrote or edited the code uponsending the email.don't get mad.. just been down this road before. ;-)Donovan> > --> > Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@novaderm.com> > On Tuesday, May 20, 2003, at 02:00 PM, dbrooke wrote:> > > 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.> >> > Donovan> >> >> >> > WJ Starck wrote:> >>> >> Ah sorry, here is the correct formula> >>> >> [format .2f][math]> >>> >> [showif [subtotal]<45][lookup> >> db=ShipCosts.db&value=[shipvia]&lookinfield=shipmethod&returnfield=Shi> >> pC> >> 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=insura> >> nc> >> e]> >> [/showif]> >> [showif [subtotal]>50]> >> [showif [subtotal]<100.01]> >> [lookup> >> db=dbs/> >> uspsinsurance.db&value=100&lookinfield=ordersubtotal&returnfield=insur> >> an> >> ce]> >> [/showif]> >>> >> [loop start=100&end=5000&advance=100]> >> [showif [subtotal]>[index].01]> >> [lookup> >> db=dbs/> >> uspsinsurance.db&value=[index]&lookinfield=ordersubtotal&returnfield=i> >> ns> >> 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=Sh> >>> ip> >>> 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=insur> >>> an> >>> 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/> >> >> > -------------------------------------------------------------> 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:
adding shipping cost (1998)
eBay API thru webDNA (2004)
Need ideas (2002)
pictures / referrer etc. (1998)
Postdata expired from cache (2004)
PCS Customer submissions ? (1997)
[shownext] and descending order (1997)
HomePage Caution (1997)
Addlineitems ... grrr (2004)
Where is f2? (1997)
Generating Options for a Form. (1997)
Signal Raised (1997)
Its not that weird. (1997)
Resume Catalog ? (1997)
Help! Strange happenings... (1997)
Need relative path explanation (1997)
Error Type 3 (1999)
[CART] (1997)
Protecting Files (2005)
taxTotal confusion (1998)