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

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 110033
interpreted = N
texte = interesting, ok, going to go actually run the code and see what's what = :)=20 thanks for the heads up! On Dec 13, 2012, at 11:16 PM, Terry Nair wrote: > Hi Brian .... >=20 > Strange ....I tried the code your way ....Did not work. Tried mine > ...worked. >=20 > According to the docs and replacing the field name where appropriate > (paraphrasing so to speak) .... >=20 > less than or equal to - leLOWdatarq=3D7 finds all records whose LOW = field is > "less than or equal to" 7. That means the range 1 to 4 and 5 to 9 = qualify. >=20 > greater than or equal to - geHIGHdatarq=3D7 finds all records whose = HIGH field > is "greater than or equal to" 7. That means all the table rows qualify > except for range 1 to 4. >=20 > Given we have a "rq" which means AND both conditions must be met = ....the > only table row is one which is the range 5 to 9. >=20 > Basically, you refer to the [howmany] as greater then or equal to when = it > should be read as LOW values that are greater then or equal to. > Interpretation error. Anyway, try it on your test / dev server = ......don't > want anyone losing hair on this ....barely keeping mine on these days = ..LOL >=20 > Cheers TDn >=20 Associated Messages, from the most recent to the oldest:

    
interesting, ok, going to go actually run the code and see what's what = :)=20 thanks for the heads up! On Dec 13, 2012, at 11:16 PM, Terry Nair wrote: > Hi Brian .... >=20 > Strange ....I tried the code your way ....Did not work. Tried mine > ...worked. >=20 > According to the docs and replacing the field name where appropriate > (paraphrasing so to speak) .... >=20 > less than or equal to - leLOWdatarq=3D7 finds all records whose LOW = field is > "less than or equal to" 7. That means the range 1 to 4 and 5 to 9 = qualify. >=20 > greater than or equal to - geHIGHdatarq=3D7 finds all records whose = HIGH field > is "greater than or equal to" 7. That means all the table rows qualify > except for range 1 to 4. >=20 > Given we have a "rq" which means AND both conditions must be met = ....the > only table row is one which is the range 5 to 9. >=20 > Basically, you refer to the [howmany] as greater then or equal to when = it > should be read as LOW values that are greater then or equal to. > Interpretation error. Anyway, try it on your test / dev server = ......don't > want anyone losing hair on this ....barely keeping mine on these days = ..LOL >=20 > Cheers TDn >=20 "Brian B. Burton"

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:

test (2000) [WebDNA] Sorry WebDNA server not running (2014) AppleScript question (1997) quotes (2004) Fun with Dates - finally resolved but.... (1997) [WebDNA] Month Old Email files in email folder... (2010) Associative lookup style? + bit more (1997) Append probs, please help (2001) expired beta (1997) serial number generation (1997) [WebDNA] Error 500 with SUMM=T (2017) Nesting format tags (1997) delayed email response (2005) My server admin needs help ... (2004) Re:Merchant and WebCat 3.0 (1998) Director 7 (1999) Resume Catalog ? (1997) Public beta 3 of WebCatalog 4.0 is now available (2000) Printing a final order (1997) HTML encoding in URLs (1997)