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 anembedded search, but I am having trouble sorting the results so that thecorrect amount comes up. For example: If my subtotal is $34.00, this bringsup 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 andless than 50.00. Any thoughts on how to get this to work correctly? It'sprobably something really easy, but I've looked at it too much and thought afresh perspective could help. Below is my embedded search code and myShipTable.db contents.Thanks A lot!--Michael Fichtenmayer[searchdb=ShipTable.db&leHighamountdatarq=[subtotal]&geLowAmountdatarq=[subtotal]&max=1&AllReqd=T][founditems][shipTotal][/founditems][/search]LowAmount HighAmount shipTotal0 50.00 5.9550.01 75.00 6.9575.01 100.00 7.95100.01 150.00 8.95150.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 anembedded search, but I am having trouble sorting the results so that thecorrect amount comes up. For example: If my subtotal is $34.00, this bringsup 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 andless than 50.00. Any thoughts on how to get this to work correctly? It'sprobably something really easy, but I've looked at it too much and thought afresh perspective could help. Below is my embedded search code and myShipTable.db contents.Thanks A lot!--Michael Fichtenmayer[searchdb=ShipTable.db&leHighamountdatarq=[subtotal]&geLowAmountdatarq=[subtotal]&max=1&AllReqd=T][founditems][shipTotal][/founditems][/search]LowAmount HighAmount shipTotal0 50.00 5.9550.01 75.00 6.9575.01 100.00 7.95100.01 150.00 8.95150.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:

how realize an advertiser ? (2005) What would be sweet is (2003) Whats going on? (2000) [WebDNA] a major shift in strategy? (2008) Help! (1996) protect acting looney?? (2003) Problems with [Applescript] (1997) [returnraw] and form variables (1998) Emailer choke (1997) PCS Emailer's role ? (1997) [WebDNA] Brian Harrington (2019) W* 3.x & WebCat + WebMerchant (1998) v6 Development copy download link seems to be offline? (2004) [WriteFile] problems (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Fwd: 502 Bad Gateway (1998) Error:Too many nested [xxx] contexts (1997) Feedback on new features (2000) WC2.0 Memory Requirements (1997) Shopping cart now bad (1997)