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:

Re:no [search] with NT (1997) WebCat2b12plugin - [search] is broken ... not! (1997) taxTotal, grandTotal (1997) Rhapsody? (1997) Text data with spaces in them... (1997) DON'T use old cart file! (1997) Re:Emailer setup (1997) Where is f2? (1997) Why doesn't it change? (1998) problems with 2 tags (1997) '0' vs. blank (2005) Problems appending to database (1997) how to do multiple prices/item? (1998) Webcatalog server support (1997) Seeking Better Display of results... (1997) Error:Too many nested [xxx] contexts (1997) Multipart/alternative e-mail (2003) RequiredFields template (1997) practicing safe queries.. (2000) Signal Raised (1997)