[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:

    
  1. [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:

Weird Math and SV (1997) createfolder not behaving as expected (1999) Stumpted Again (1997) [lookup] is case-sensitive, [lookup] is case sensitive... (2003) Re:quit command on NT (1997) Webcatalog quitting (1997) Specifying the URL where a user should go (2000) Field name-subcategory (1997) Searching for the end (1998) Empty fields delete-able? (2000) Problem with version 4 browsers (1998) Running _every_ page through WebCat-error.html (1997) [WebDNA] Sorting -- Dealing with Blanks (2008) [format 40s]text[/format] doesn't work (1997) Alternating colors (1997) two domains and one cart and database (2000) Attn: Bug in GeneralStore example b15 (1997) Problem (1997) Multiple adding (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009)