still having shipCost.db Problem

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12208
interpreted = N
texte = Well,Tried the syntax suggestion from Ken, however still no go.So......After the reference from formula.dbName Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]the original shipCosts.dbShipMethod ShipCost Australia 5.00 International 10.00 works fine,However changing the shipCost to a calcualtion ShipMethod ShipCost Australia [showif [subtotal]<100] 5.00 [/showif] International 10.00 Still doesn't work. THe other wierd things is that with this show if statement it effects all subseqent entries, even if they are just numbers with out calculations.So, is the problem, one database calculation calling another calcualtion, the [showif] or something else.I think I've tried every combination, and getting very frustrated.thanks in advance.Rick Associated Messages, from the most recent to the oldest:

    
  1. Re: still having shipCost.db Problem (Richard Wylie 1997)
  2. Re: still having shipCost.db Problem (Grant Hulbert 1997)
  3. still having shipCost.db Problem (Richard Wylie 1997)
Well,Tried the syntax suggestion from Ken, however still no go.So......After the reference from formula.dbName Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]the original shipCosts.dbShipMethod ShipCost Australia 5.00 International 10.00 works fine,However changing the shipCost to a calcualtion ShipMethod ShipCost Australia [showif [subtotal]<100] 5.00 [/showif] International 10.00 Still doesn't work. THe other wierd things is that with this show if statement it effects all subseqent entries, even if they are just numbers with out calculations.So, is the problem, one database calculation calling another calcualtion, the [showif] or something else.I think I've tried every combination, and getting very frustrated.thanks in advance.Rick Richard Wylie

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:

How do _you_ back up your db? (2000) ups quickcost [repost] (1999) TCPConnect (1998) Date Sorting (1997) Why does the following crash WebCat? (2000) Multiple fields on 1 input (1997) Problem (1997) The old multiple selection bit (2000) Shipping.db (1998) [WebDNA] read database from other domain (2015) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Help with nested search (1998) Country & Ship-to address & other fields ? (1997) Sendmail truncation in Eudora Clients (1998) PIXO (1997) WC1.6 to WC2 date formatting -FIXED! (1997) Order not created error (never mind) (1997) searching numbers (1998) Snake Bites (1997) [WebDNA] php/mySQL version of WebDNA Speed Test? (2009)