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

Members register & gain access system (1998) Credit card payment processor (2004) Performance Issue (2000) RE: URL too Long? (1997) RE: WebCat cannot handle compatible search parameters? (1997) [cart][date][time] (2003) Show if time tags (1997) Help needed! (SIMS recommendation) (1998) Multiple Pulldowns (1997) Quickie question on the email templates (1997) Hiding URL ? (1998) WebCatalog Use Question (1997) Secure server question (1997) RSS Feeds; basic info (2005) WebDNA Solutions ... sorry! (1997) Cart Numbers (1997) Internet Advancement (2003) AutoCommit Preference? (1998) WebCatalog Plug-in for Webstar. (1997) Cart Numbers (1997)