ShipTotal Yet Again
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20120
interpreted = N
texte = Hi, I haven't gotten this to work yet. Does anyone have any ideas???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:
| |
- ShipTotal Yet Again (Michael Fichtenmayer 1998)
|
Hi, I haven't gotten this to work yet. Does anyone have any ideas???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:
New Server? (2006)
Secure server question (1997)
Force a search at the default.tmpl page? (1997)
Server Freeze (1998)
writefile - continued (1997)
[WebDNA] java class (2014)
WebCat2_Mac RETURNs in .db (1997)
[format xs] freeze (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Server capacity (2003)
TemplateCacheSize preference! (1998)
R.I.P. Netscape (2003)
Search returns all, not 20 (1997)
reserved characters for field names? (1998)
OFF TOPIC: help wanted (1997)
WebCat2 - [format thousands] (1997)
oops private message leaked into talk list (1997)
Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)
how to get s repeatedly in and out of a form? (1999)
Re:2nd WebCatalog2 Feature Request (1996)