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:

Menu to select product variations (1997) Displaying photo attached to first record (1997) Re:quit command on NT (1997) Re:Searching for ALL / empty form field *the FINAL answer* (1997) Using Plug-In while running 1.6.1 (1997) Handy Browser Counter Tip (1997) Email Tracking (2004) [SHOWIF]s and empty arguments (1997) RE: [WebDNA] Cart Login (2014) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Perl programmer needed (2002) PCS Frames (1997) Problems with [Applescript] (1997) creator code (1997) WebCat2: Items xx to xx shown, etc. (1997) Multi Colonns (1998) taxTotal, grandTotal (1997) pc (1997) Sorting by date (1997) RE: PIXO support (1997)