Correction: shipCost

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30590
interpreted = N
texte = Robert Wade wrote:> I've set up several shipping strategies in the past with WebCatalog and > now I'm having problems with the simplest one yet. > > My [shipCost] tag in the invoice page returns 0.00 no matter what I have > listed in the shipCosts.db field and no matter what I set the notFound > in the [lookup]. It seems that it is not trying to find the formula at > all. I've been through it and through and tried several different > formulas and nothing is working. My taxRate lookup is similar in it's > code and it works fine. MacOs 8.6 - Web* 4.2 - WebCat Plug-in 3.04. > Anyone? > > Formulas.db... > > Name Formula > price [price] > taxRate [lookup > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Found=0.00] > > shipCost [lookup > db=shipCosts.db&lookInField=shipMethod&value=Ground&returnField=shipCost¬Found=6.00] > > shipCosts.db... > > shipMethod shipCost > Ground 4.95 > > The area of my invoice page containing the [shipCost]... > > > > [lineItems] > > align=right>$[format > .2f][math][quantity]*[price][/math][/format] > [/lineItems] > > align=right> size=-1>$[taxTotal] > > > >
Title face=verdana,helvetica,arial size=-1>Qty face=verdana,helvetica,arial size=-1>Price face=verdana,helvetica,arial size=-1>Qty*Price face=verdana,helvetica,arial size=-1>Shipping Fee
size=-1>[title] size=-1>[quantity] face=verdana,helvetica,arial size=-1>$[price] face=verdana,helvetica,arial size=-1>$[unitShipCost]
size=-1>Subtotal face=verdana,helvetica,arial size=-1>$[subTotal]
[Shiptostate] Tax > Rate: [taxRate]% face=verdana,helvetica,arial size=-1>Tax
size=-1>Handling Charge face=verdana,helvetica,arial size=-1>$[shipCost]
size=-1>Total Shipping & Handling face=verdana,helvetica,arial size=-1>$[shipTotal]
size=-1>Grand Total face=verdana,helvetica,arial size=-1>$[grandTotal]
> > ___________________________________________________ > Robert Wade > CABIN6 Design > > ===================== > |[ //\ ||} || ||\| V| > ===================== > > htttp://www.cabin6.com > robert@cabin6.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 ------------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. Correction: shipCost (Robert Wade 2000)
Robert Wade wrote:> I've set up several shipping strategies in the past with WebCatalog and > now I'm having problems with the simplest one yet. > > My [shipCost] tag in the invoice page returns 0.00 no matter what I have > listed in the shipCosts.db field and no matter what I set the notFound > in the [lookup]. It seems that it is not trying to find the formula at > all. I've been through it and through and tried several different > formulas and nothing is working. My taxRate lookup is similar in it's > code and it works fine. MacOs 8.6 - Web* 4.2 - WebCat Plug-in 3.04. > Anyone? > > formulas.db... > > Name Formula > price [price] > taxRate [lookup > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Found=0.00] > > shipCost [lookup > db=shipCosts.db&lookInField=shipMethod&value=Ground&returnField=shipCost¬Found=6.00] > > shipCosts.db... > > shipMethod shipCost > Ground 4.95 > > The area of my invoice page containing the [shipCost]... > > > > [lineitems] > > align=right>$[format > .2f][math][quantity]*[price][/math][/format] > [/lineItems] > > align=right> size=-1>$[taxTotal] > > > >
Title face=verdana,helvetica,arial size=-1>Qty face=verdana,helvetica,arial size=-1>Price face=verdana,helvetica,arial size=-1>Qty*Price face=verdana,helvetica,arial size=-1>Shipping Fee
size=-1>[title] size=-1>[quantity] face=verdana,helvetica,arial size=-1>$[price] face=verdana,helvetica,arial size=-1>$[unitShipCost]
size=-1>Subtotal face=verdana,helvetica,arial size=-1>$[subTotal]
[Shiptostate] Tax > Rate: [taxRate]% face=verdana,helvetica,arial size=-1>Tax
size=-1>Handling Charge face=verdana,helvetica,arial size=-1>$[shipCost]
size=-1>Total Shipping & Handling face=verdana,helvetica,arial size=-1>$[shipTotal]
size=-1>Grand Total face=verdana,helvetica,arial size=-1>$[grandTotal]
> > ___________________________________________________ > Robert Wade > CABIN6 Design > > ===================== > |[ //\ ||} || ||\| V| > ===================== > > htttp://www.cabin6.com > robert@cabin6.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 ------------------------------------------------------------- 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 Robert Wade

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:

Include a big block of text (1997) [quantity] solved (1997) WebCat2 several catalogs? (1997) looping table rows (1999) Revisit: speed test (2002) (no subject) (1997) Database Import/Export (1998) Details of shipping - Totalqty calculations (1997) OK, here goes... (1997) carriage returns in data (1997) RE: [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) Email Line Breaks [OT] (2003) https validation (2001) WebMerchant 1.6 and https (1997) I give up!! (1997) [OT] Friendly URL's (2004) Re:Emailer and encryption (1997) Pithy questions on webcommerce & siteedit (1997) Shownext never shows next...still (1997) Bad Cookie / Internet Option / Internet Explorer (2004)