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:

refreshing IE with posted .tmpl (1997) Re:no [search] with NT (1997) Sorting error (1997) Plugin or CGI or both (1997) [Summary] re: Emailer setup (1997) shipcost (1997) [CreateDate], [ListFiles] context tag broken on Linux? (2000) PSC recommends what date format yr 2000??? (1997) WebCatalog Help (2002) authorize.net hex coded variables (2002) Forumulas.db & Variables (2002) Viewing old carts (was FEW QUESTIONS) (1997) Assign Variable Value (1998) Bug or syntax error on my part? (1997) Dreamweaver MX (again) (2002) Harvesting invalid email addresses from bounced emails??? (2000) [WebDNA] WebDNA on Facebook (2009) Help! WebCat2 bug (1997) form data submission gets truncated (1997) Help needed! (SIMS recommendation) (1998)