Re: [WebDNA] math and blank /no value

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111434
interpreted = N
texte = --1619090392-215866803-1404602920=:2185 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I'll give it a try.=0AWeird how the solution posted in the talklists way ba= ck was acting so erratically.=0AI even did a total reboot/restart of webdna= 'cause sometimes windows like to act goofy on its own.=0A=0ARich=0A=0A=0A= =0AOn Saturday, July 5, 2014 5:32 PM, Stuart Tremain w= rote:=0A =0A=0A=0AThis will fix your problem:=0A=0A[text show=3DF]totalchar= ges=3D[math][FORMAT .2f][ad_listing_price][/FORMAT]+[FORMAT .2f][promo_tops= pot_price][/FORMAT]+[FORMAT .2f][photo_update_price][/FORMAT][/math][/text]= =0A=0AIf any of your values are blank they will be formatted to 0.00 so tha= t your math will then be able to calculate without error.=0A=0ARegards=0A= =0AStuart Tremain=0AIDFK Web Developments=0AAUSTRALIA=0Awebdna@idfk.com.au= =0A=0A=0A=0A=0AOn 6 Jul 2014, at 1:57 am, Rich Kwas wrote:=0A=0AHope everyone in the US had a nice 4th of July.....=0A>Chi= cago stopped its lakefront fireworks extravaganza years ago.... ;(=0A>=0A>= =0A>=0A>=0A>A somewhat simple [math] addition snippet is driving me nuts=0A= >=0A>=0A>I've seen this referenced one way or another in the talklists.....= =0A>=0A>=0A>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>Another trick for deali= ng with fields that may be blank is to prepend=A0=0A>them with a 0 within t= he=A0math=A0context:[math][_itemamount]+[_postage]+0[_donation][/math]=0A>= =0A>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>= =0A>=0A>=0A>=0A>Doesn't behave as mentioned that way for me.....=0A>=0A>=0A= >=0A>=0A>I'm ultimately snatching some price values and doing simple additi= on:=0A>=0A>=0A>[text show=3DF]totalcharges=3D[math][ad_listing_price]+[prom= o_topspot_price]+[photo_update_price][/math][/text]=0A>=0A>=0A>(there will = be many more fields, but for now I'm just dealing with those 3)=0A>=0A>=0A>= If any one of those 3 price variables is not passed from the form the addit= ion will not happen.=0A>If all 3 are passed they total up just fine.=A0=0A>= There might be as many as 13 fields getting totaled up when complete.=0A>Th= ere might be just one price to pass along, maybe 2 or 3 to add up, maybe 4 = or 5 etc=0A>=0A>=0A>Adding a "0" like mentioned in the talklist entries I'v= e found does nothing.=0A>=0A>=0A>I've used [listvariables] and [formvariabl= es] to be sure those 3 prices are being passed around OK and they are....= =0A>=0A>=0A>=0A>=0A>Something simple I'm missing or flying over my head?=0A= >=0A>=0A>Adding [hideif]s into that [math] part is an option, but looking f= or a simpler solution.=0A>=0A>=0A>I'm running version 6.2 on Windows Server= 2008=0A>=0A>=0A>Searching the newer talklist gets a little clunky at times = using that form.....=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=A0=0A---------= ------------------------------------------------=0AThis message is sent to = you because you are subscribed to=0Athe mailing list .=0ATo unsubscribe, E-= mail to: =0Aarchives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us=0A=0A------------------------------------------------= ---------=0AThis message is sent to you because you are subscribed to=0Athe= mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://mail.webdn= a.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us --1619090392-215866803-1404602920=:2185 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I'll give it a try.
Weird how the solution posted in the tal= klists way back was acting so erratically.
I even did a total reboot/restart of webdn= a 'cause sometimes windows like to act goofy on its own.

Rich



On Saturday, July 5, 2014 5:32 PM, Stuart Tremain <webdna@idfk.co= m.au> wrote:


This will fix your problem:

=
[text show=3DF]totalcharges=3D[math][FORM= AT .2f][ad_listing_price][/FORMAT]+[FORMAT .2f][promo_topspot_price][/FORMAT]= +[FORMAT .2f][photo_update_price]<= /span>[/FORMAT][/math][/text]

If any of= your values are blank they will be formatted to 0.00 so that your math wil= l then be able to calculate without error.

=0A
Regards

Stuart Tremain
IDFK Web Developments
<= div>AUSTRALIA



=0A=0A
=0A
On 6 Jul 2014, at 1:57 am, Rich = Kwas <r= ichkwasniewski@yahoo.com> wrote:

Hope everyone in the US had = a nice 4th of July.....
Chicag= o stopped its lakefront fireworks extravaganza years ago.... ;(


A somewhat simple [math] addition snippet is driving me nut= s

I've seen this referenced one way or another in the talkli= sts.....

=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Another trick for dealing with fields that may be = blank is to prepend 
th= em with a 0 within the math context:[math][_itemamount]+[_postage]+0[_donation][/math]
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


Doesn't behave as mentioned= that way for me.....


<= div class=3D"yiv5574971491" style=3D"font-size: 13px; font-family: Helvetic= aNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; fon= t-style: normal; background-color: transparent;">I'm ultimately snatching s= ome price values and doing simple addition:

[text show=3DF]totalcharges=3D[math][ad_listing_price]+[promo_topspot_price]+= [photo_update_price][/math][/text]

(there will be many more fields, but for now= I'm just dealing with those 3)

If any one of those 3 price = variables is not passed from the form the addition will not happen.
If all 3 are passed they total up just fine= . 
There might = be as many as 13 fields getting totaled up when complete.
There might be just one price to pa= ss along, maybe 2 or 3 to add up, maybe 4 or 5 etc

Adding a "0" = like mentioned in the talklist entries I've found does nothing.

I've used [listvariables] and [formvariables] to be sure those 3 prices= are being passed around OK and they are....


Something simple= I'm missing or flying over my head?
<= span class=3D"yiv5574971491" style=3D"font-size:10pt;">
<= /span>
Adding [hideif]s into that [ma= th] part is an option, but looking for a simpler solution.

I'm = running version 6.2 on Windows Server2008

Searching the ne= wer talklist gets a little clunky at times using that form.....

=



 
=0A---------------------------------------------------------=0AThis messa= ge is sent to you because you are subscribed to=0Athe mailing list .=0ATo u= nsubscribe, E-mail to: =0Aarchives: http://mai= l.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us
=0A--------------------------------------= -------------------=0AThis message is sent to you because you are subscribe= d to=0Athe mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://= mail.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us
=


--1619090392-215866803-1404602920=:2185-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] math and blank /no value (=?utf-8?Q?iPhonzie=40G?= 2014)
  2. Re: [WebDNA] math and blank /no value (Kenneth Grome 2014)
  3. Re: [WebDNA] math and blank /no value (Rich Kwas 2014)
  4. Re: [WebDNA] math and blank /no value (Stuart Tremain 2014)
  5. [WebDNA] math and blank /no value (Rich Kwas 2014)
--1619090392-215866803-1404602920=:2185 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I'll give it a try.=0AWeird how the solution posted in the talklists way ba= ck was acting so erratically.=0AI even did a total reboot/restart of webdna= 'cause sometimes windows like to act goofy on its own.=0A=0ARich=0A=0A=0A= =0AOn Saturday, July 5, 2014 5:32 PM, Stuart Tremain w= rote:=0A =0A=0A=0AThis will fix your problem:=0A=0A[text show=3DF]totalchar= ges=3D[math][FORMAT .2f][ad_listing_price][/FORMAT]+[FORMAT .2f][promo_tops= pot_price][/FORMAT]+[FORMAT .2f][photo_update_price][/FORMAT][/math][/text]= =0A=0AIf any of your values are blank they will be formatted to 0.00 so tha= t your math will then be able to calculate without error.=0A=0ARegards=0A= =0AStuart Tremain=0AIDFK Web Developments=0AAUSTRALIA=0Awebdna@idfk.com.au= =0A=0A=0A=0A=0AOn 6 Jul 2014, at 1:57 am, Rich Kwas wrote:=0A=0AHope everyone in the US had a nice 4th of July.....=0A>Chi= cago stopped its lakefront fireworks extravaganza years ago.... ;(=0A>=0A>= =0A>=0A>=0A>A somewhat simple [math] addition snippet is driving me nuts=0A= >=0A>=0A>I've seen this referenced one way or another in the talklists.....= =0A>=0A>=0A>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>Another trick for deali= ng with fields that may be blank is to prepend=A0=0A>them with a 0 within t= he=A0math=A0context:[math][_itemamount]+[_postage]+0[_donation][/math]=0A>= =0A>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>= =0A>=0A>=0A>=0A>Doesn't behave as mentioned that way for me.....=0A>=0A>=0A= >=0A>=0A>I'm ultimately snatching some price values and doing simple additi= on:=0A>=0A>=0A>[text show=3DF]totalcharges=3D[math][ad_listing_price]+[prom= o_topspot_price]+[photo_update_price][/math][/text]=0A>=0A>=0A>(there will = be many more fields, but for now I'm just dealing with those 3)=0A>=0A>=0A>= If any one of those 3 price variables is not passed from the form the addit= ion will not happen.=0A>If all 3 are passed they total up just fine.=A0=0A>= There might be as many as 13 fields getting totaled up when complete.=0A>Th= ere might be just one price to pass along, maybe 2 or 3 to add up, maybe 4 = or 5 etc=0A>=0A>=0A>Adding a "0" like mentioned in the talklist entries I'v= e found does nothing.=0A>=0A>=0A>I've used [listvariables] and [formvariabl= es] to be sure those 3 prices are being passed around OK and they are....= =0A>=0A>=0A>=0A>=0A>Something simple I'm missing or flying over my head?=0A= >=0A>=0A>Adding [hideif]s into that [math] part is an option, but looking f= or a simpler solution.=0A>=0A>=0A>I'm running version 6.2 on Windows Server= 2008=0A>=0A>=0A>Searching the newer talklist gets a little clunky at times = using that form.....=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=A0=0A---------= ------------------------------------------------=0AThis message is sent to = you because you are subscribed to=0Athe mailing list .=0ATo unsubscribe, E-= mail to: =0Aarchives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us=0A=0A------------------------------------------------= ---------=0AThis message is sent to you because you are subscribed to=0Athe= mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://mail.webdn= a.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us --1619090392-215866803-1404602920=:2185 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I'll give it a try.
Weird how the solution posted in the tal= klists way back was acting so erratically.
I even did a total reboot/restart of webdn= a 'cause sometimes windows like to act goofy on its own.

Rich



On Saturday, July 5, 2014 5:32 PM, Stuart Tremain <webdna@idfk.co= m.au> wrote:


This will fix your problem:

=
[text show=3DF]totalcharges=3D[math][FORM= AT .2f][ad_listing_price][/FORMAT]+[FORMAT .2f][promo_topspot_price][/FORMAT]= +[FORMAT .2f][photo_update_price]<= /span>[/FORMAT][/math][/text]

If any of= your values are blank they will be formatted to 0.00 so that your math wil= l then be able to calculate without error.

=0A
Regards

Stuart Tremain
IDFK Web Developments
<= div>AUSTRALIA



=0A=0A
=0A
On 6 Jul 2014, at 1:57 am, Rich = Kwas <r= ichkwasniewski@yahoo.com> wrote:

Hope everyone in the US had = a nice 4th of July.....
Chicag= o stopped its lakefront fireworks extravaganza years ago.... ;(


A somewhat simple [math] addition snippet is driving me nut= s

I've seen this referenced one way or another in the talkli= sts.....

=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Another trick for dealing with fields that may be = blank is to prepend 
th= em with a 0 within the math context:[math][_itemamount]+[_postage]+0[_donation][/math]
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


Doesn't behave as mentioned= that way for me.....


<= div class=3D"yiv5574971491" style=3D"font-size: 13px; font-family: Helvetic= aNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; fon= t-style: normal; background-color: transparent;">I'm ultimately snatching s= ome price values and doing simple addition:

[text show=3DF]totalcharges=3D[math][ad_listing_price]+[promo_topspot_price]+= [photo_update_price][/math][/text]

(there will be many more fields, but for now= I'm just dealing with those 3)

If any one of those 3 price = variables is not passed from the form the addition will not happen.
If all 3 are passed they total up just fine= . 
There might = be as many as 13 fields getting totaled up when complete.
There might be just one price to pa= ss along, maybe 2 or 3 to add up, maybe 4 or 5 etc

Adding a "0" = like mentioned in the talklist entries I've found does nothing.

I've used [listvariables] and [formvariables] to be sure those 3 prices= are being passed around OK and they are....


Something simple= I'm missing or flying over my head?
<= span class=3D"yiv5574971491" style=3D"font-size:10pt;">
<= /span>
Adding [hideif]s into that [ma= th] part is an option, but looking for a simpler solution.

I'm = running version 6.2 on Windows Server2008

Searching the ne= wer talklist gets a little clunky at times using that form.....

=



 
=0A---------------------------------------------------------=0AThis messa= ge is sent to you because you are subscribed to=0Athe mailing list .=0ATo u= nsubscribe, E-mail to: =0Aarchives: http://mai= l.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us
=0A--------------------------------------= -------------------=0AThis message is sent to you because you are subscribe= d to=0Athe mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://= mail.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.us
=


--1619090392-215866803-1404602920=:2185-- Rich Kwas

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:

Snake Bites (1997) (2002) Why is my easy [AddLineItems] NOT working?? MORE (2000) [PROTECT] Problem (2003) Emailer setup (1997) serial number not working-fixed (1998) Claris HomePage messes up the code (1997) Searching an Email database (1997) Site Builder & IE Mac (2004) Fufillment e-mail? (1998) Help name our technology! (1997) Grouping Fields (2006) [OT] HTML Email in Lotus Notes (2005) Add a field to the error log? (1997) Cart Question (1998) [table] (was Feature req.) (2002) Another date range search Q (2002) [WebDNA] Sorry WebDNA server not running. (2008) Where has WebDNA shown up in your life? (2003) off topic - dna snipets (1997)