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 =:)=20thanks 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 =:)=20thanks 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)