[Mac 3.0.8] Formulas.db Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48879
interpreted = N
texte = I'm getting a consistent 0.00 for [shippingtotal] when I use this code in my Formulas.db. If I copy and paste this code into the page, it works fine (It's surrounded by an [orderfile] context in the actual page.)[math show=t]0[Search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&leMINdatarq=[ format .2f][subtotal][/format]&MINtype=num&geMAXdatarq=[format .2f][subtotal][/format]&MAXtype=num&max=1][founditems]+[cost][/founditems][/ search][showif [url][shiptostate][/url]=AK]+[search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&eqTYPdatarq=s tate&eqSKUdatarq=AK][founditems][cost][/founditems][/search][/showif][showif [url][shiptostate][/url]=HI]+[search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&eqTYPdatarq=s tate&eqSKUdatarq=HI][founditems][cost][/founditems][/search][/showif][/math]Thanks -- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- [Mac 3.0.8] Formulas.db Question (Jesse Williams-Proudman 2003)
|
I'm getting a consistent 0.00 for [shippingtotal] when I use this code in my formulas.db. If I copy and paste this code into the page, it works fine (It's surrounded by an [orderfile] context in the actual page.)[math show=t]0[Search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&leMINdatarq=[ format .2f][subtotal][/format]&MINtype=num&geMAXdatarq=[format .2f][subtotal][/format]&MAXtype=num&max=1][founditems]+[cost][/founditems][/ search][showif [url][shiptostate][/url]=AK]+[search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&eqTYPdatarq=s tate&eqSKUdatarq=AK][founditems][cost][/founditems][/search][/showif][showif [url][shiptostate][/url]=HI]+[search db=^simplestore/shiprates.db&eqKEYdatarq=[url][header30][/url]&eqTYPdatarq=s tate&eqSKUdatarq=HI][founditems][cost][/founditems][/search][/showif][/math]Thanks -- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Jesse Williams-Proudman
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:
Multiple prices (1997)
frames & carts (1997)
Nesting [RAW] (1998)
Serving images from databases (1998)
WebStar CGI Version (2005)
Cookies (1999)
Webmerchant confirmation hooks? (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Date Range search (1997)
Some Advise needed (1997)
Running 2 two WebCatalog.acgi's (1996)
RequiredFields template (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Never ending problem.... (2000)
Using Japanesse text with webcat. (1998)
Multiple catalog databases and showcart (1997)
breaking words (1997)
[WriteFile] problems (1997)
Shipcost lookup? (1997)
PIXO Support (1997)