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:

Requiring that certain fields be completed (1997) When to use [convertchars] ?!?!? (2000) Delete only one duplicate record? (2003) easy numfound search? (2001) [WebDNA] Brian Harrington (2019) WYSIWYG Editor? (2006) is [Bankres] an internal webcat variable? (1999) Server crash (1997) Getting total number of items ordered (1997) New Site WebCat (1997) Running WebCat from a CD-ROM (1997) Keep away (1997) Strange intermittent WebDNA problems (2008) Replace Missing Images (2003) SiteBuilder Problem (2004) [WebDNA] special chars --> WebDNA file upload (2009) still having shipCost.db Problem (1997) Credit card types (1997) Stop the madness. (1997) [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (2012)