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 but tells me you rewrote or edited the code upon sending 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:

    
  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)
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 but tells me you rewrote or edited the code upon sending 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)