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:

security problem (1997) WHY SO MANY DUPLICATES? (1999) [OT] Robust order processing (2003) Location of Browser Info.txt file (1997) [WebDNA] Count Lines (2011) Setting up shop (1997) RE: WebCat: Access denied, but why? (1997) Replacing a Word (1999) Search results templates (1996) 2.1 pricing? (1998) Integration? (1999) php vs WebCatalog (2000) Return records from another (1997) Running 2 two WebCatalog.acgi's (1996) Modifying order output (1997) 2.0 Info (1997) A question on sub-categories (1997) Credit card issuer by cc number? (1999) WebDNA tags in WebMerchant email templates ... (1997) Porting to NT (2001)