Re: [WebDNA] [if] or [case] or something else

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 110022
interpreted = N
texte = If I understand your formula correctly you could just use something = like: [math show=3Df]x=3D120-(floor(([thisPrice]-500)/150)*10)[/math] And if you're not accepting x to be lower than 0 then add: [showif [x]<0][math show=3Df]x=3D0[/math][/showif] Best, Christer ************************************************************* Christer Olsson PO Box 9160 Phone +46 40 25 85 85 Ljusa Id=C3=A9er AB SE-200 39 Malmo Fax +46 40 25 85 89 Kantyxegatan 5 Sweden http://www.ljusaideer.se 13 dec 2012 kl. 18.00 skrev Steve Craig: > Hi >=20 > Ok thanks for this, I take it there is not a [elseif] statement in = WebDNA so it's all nested in one if? >=20 > Cheers > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Steve Craig - Asylum Interactive Ltd > Tel +44 1330 860550 Fax +44 1330 860880 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > http://www.asylumweb.com > Email: steve@asylumweb.com > Skype: s.craig - iChat: steve.craig > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 >=20 >=20 > On 13 Dec 2012, at 16:49, Brian Fries wrote: >=20 >> Switch only works for "equals" comparisons, not less than or greater = than, so if/then/else is your best choice here. >>=20 >> [text]x=3D[if [price]<650][then]120[/then][else][if = [price]<800][then]110[/then][else]100[/else][/if][/else][/if][/text] >>=20 >> You can extend this as far as you like; just be sure to close all the = if, then and else contexts properly. >>=20 >> Brian >>=20 >> On Dec 13, 2012, at 8:13 AM, Steve Craig wrote: >>=20 >>> Hi All >>>=20 >>> I have a little problem that I'm hoping someone cane help with or at = least point me in the correct direction. >>>=20 >>> I have a list of prices, if the price lies in a particular range I = do one set of maths, if it lies in a different range I do a different = thing etc etc.=20 >>>=20 >>> <650 then set x to 120 >>> =3D>650 and < 800 set x to 110 >>> =3D>800 and < 950 set x to 100 >>> .... >>> .... >>> .... >>>> 1550 set x to 50 >>>=20 >>> What is the best way to code it, using if then or using switch? If = it's switch then what is the syntax of the case bit? Or maybe a = different way? >>>=20 >>> Any help much appreciated. >>>=20 >>> Cheers >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Steve Craig - Asylum Interactive Ltd >>> Tel +44 1330 860550 Fax +44 1330 860880 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> http://www.asylumweb.com >>> Email: steve@asylumweb.com >>> Skype: s.craig - iChat: steve.craig >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [BULK] Re: [WebDNA] [if] or [case] or something else ("Brian B. Burton" 2012)
  2. RE: [BULK] Re: [WebDNA] [if] or [case] or something else ("Terry Nair" 2012)
  3. Re: [BULK] Re: [WebDNA] [if] or [case] or something else ("Brian B. Burton" 2012)
  4. RE: [BULK] Re: [WebDNA] [if] or [case] or something else ("Terry Nair" 2012)
  5. Re: [BULK] Re: [WebDNA] [if] or [case] or something else (Steve Craig 2012)
  6. [BULK] Re: [WebDNA] [if] or [case] or something else ("Brian B. Burton" 2012)
  7. Re: [WebDNA] [if] or [case] or something else (Christer Olsson 2012)
  8. Re: [WebDNA] [if] or [case] or something else (Steve Craig 2012)
  9. Re: [WebDNA] [if] or [case] or something else (Christer Olsson 2012)
  10. Re: [WebDNA] [if] or [case] or something else (Steve Craig 2012)
  11. Re: [WebDNA] [if] or [case] or something else (Brian Fries 2012)
  12. [WebDNA] [if] or [case] or something else (Steve Craig 2012)
If I understand your formula correctly you could just use something = like: [math show=3Df]x=3D120-(floor(([thisPrice]-500)/150)*10)[/math] And if you're not accepting x to be lower than 0 then add: [showif [x]<0][math show=3Df]x=3D0[/math][/showif] Best, Christer ************************************************************* Christer Olsson PO Box 9160 Phone +46 40 25 85 85 Ljusa Id=C3=A9er AB SE-200 39 Malmo Fax +46 40 25 85 89 Kantyxegatan 5 Sweden http://www.ljusaideer.se 13 dec 2012 kl. 18.00 skrev Steve Craig: > Hi >=20 > Ok thanks for this, I take it there is not a [elseif] statement in = WebDNA so it's all nested in one if? >=20 > Cheers > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Steve Craig - Asylum Interactive Ltd > Tel +44 1330 860550 Fax +44 1330 860880 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > http://www.asylumweb.com > Email: steve@asylumweb.com > Skype: s.craig - iChat: steve.craig > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 >=20 >=20 > On 13 Dec 2012, at 16:49, Brian Fries wrote: >=20 >> Switch only works for "equals" comparisons, not less than or greater = than, so if/then/else is your best choice here. >>=20 >> [text]x=3D[if [price]<650][then]120[/then][else][if = [price]<800][then]110[/then][else]100[/else][/if][/else][/if][/text] >>=20 >> You can extend this as far as you like; just be sure to close all the = if, then and else contexts properly. >>=20 >> Brian >>=20 >> On Dec 13, 2012, at 8:13 AM, Steve Craig wrote: >>=20 >>> Hi All >>>=20 >>> I have a little problem that I'm hoping someone cane help with or at = least point me in the correct direction. >>>=20 >>> I have a list of prices, if the price lies in a particular range I = do one set of maths, if it lies in a different range I do a different = thing etc etc.=20 >>>=20 >>> <650 then set x to 120 >>> =3D>650 and < 800 set x to 110 >>> =3D>800 and < 950 set x to 100 >>> .... >>> .... >>> .... >>>> 1550 set x to 50 >>>=20 >>> What is the best way to code it, using if then or using switch? If = it's switch then what is the syntax of the case bit? Or maybe a = different way? >>>=20 >>> Any help much appreciated. >>>=20 >>> Cheers >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Steve Craig - Asylum Interactive Ltd >>> Tel +44 1330 860550 Fax +44 1330 860880 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> http://www.asylumweb.com >>> Email: steve@asylumweb.com >>> Skype: s.craig - iChat: steve.craig >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Christer Olsson

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:

CVS Files for databases (2000) Updating fields from different platforms (1998) fix permissions on osx ... (2004) [ShowNext] (1997) Nested tags count question (1997) Bug Report, maybe (1997) Multiple catalog databases and showcart (1997) Generating unique SKU from [cart] (1997) WEBCAT with SQL backend. Help please! (2000) eCommerce software pricing (1998) Ooops..Broswer Info.txt (was Web*SSL and WebCatalog) (1997) Webcat no longer supported? (2006) WebCat2 - [format thousands] (1997) WebCatalog can't find database (1997) Practice runs ? (1997) OK, here goes... (1997) Appending Information from one db to another (1998) Database changes (1998) RE: [WebDNA] directory protection questions (2008) quotes and truncating? (1997)