ShipTotal Again

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20104
interpreted = N
texte = I have the shipTotal pulling in from the ShipTable.db database using an embedded search, but I am having trouble sorting the results so that the correct amount comes up. For example: If my subtotal is $34.00, this brings up a [shipTotal] of $7.95 (which is the middle (average) amount on the DB). It should bring up a [shipTotal] of $5.95 since it is greater than 0 and less than 50.00. Any thoughts on how to get this to work correctly? It's probably something really easy, but I've looked at it too much and thought a fresh perspective could help. Below is my embedded search code and my ShipTable.db contents.Thanks A lot! --Michael Fichtenmayer [search db=ShipTable.db&leHighamountdatarq=[subtotal]&geLowAmountdatarq=[subtotal]&m ax=1&AllReqd=T] [founditems] [shipTotal] [/founditems] [/search] LowAmount HighAmount shipTotal 0 50.00 5.95 50.01 75.00 6.95 75.01 100.00 7.95 100.01 150.00 8.95 150.01 20000.00 9.95 Associated Messages, from the most recent to the oldest:

    
  1. Re: ShipTotal Again (Michael Fichtenmayer 1998)
  2. Re: ShipTotal Again (PCS Technical Support 1998)
  3. ShipTotal Again (Michael Fichtenmayer 1998)
I have the shipTotal pulling in from the ShipTable.db database using an embedded search, but I am having trouble sorting the results so that the correct amount comes up. For example: If my subtotal is $34.00, this brings up a [shipTotal] of $7.95 (which is the middle (average) amount on the DB). It should bring up a [shipTotal] of $5.95 since it is greater than 0 and less than 50.00. Any thoughts on how to get this to work correctly? It's probably something really easy, but I've looked at it too much and thought a fresh perspective could help. Below is my embedded search code and my ShipTable.db contents.Thanks A lot! --Michael Fichtenmayer [search db=ShipTable.db&leHighamountdatarq=[subtotal]&geLowAmountdatarq=[subtotal]&m ax=1&AllReqd=T] [founditems] [shipTotal] [/founditems] [/search] LowAmount HighAmount shipTotal 0 50.00 5.95 50.01 75.00 6.95 75.01 100.00 7.95 100.01 150.00 8.95 150.01 20000.00 9.95 Michael Fichtenmayer

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:

WebCat2b15MacPlugin - showing [math] (1997) Hummm .... (2002) form data submission gets truncated (1997) Associative lookup style? + bit more (1997) Showif for mulitple variations (1997) About the E-mailer (2002) test (2004) Email (2000) WebCat2b13 Command Reference Doc error (1997) access denied problem (1997) Strange errors in error log (1998) [Webcat 2]Next (1997) Summing fields (1997) MacActivity and PCS (1997) WebCatalog 4.x Consultant Needed (2003) (1997) Order not created error (never mind) (1997) ShowIf, If, XML Syntax.... (2004) emailer (1997) Title not showing up in ViewOrder template (1998)