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:

SKU lookup (1997) OH MY GOD! (1998) shownext (1997) [WebDNA] Google Cloud (2014) Sense/Disallow HTML tags during $Append (1997) Nesting format tags (1997) path hierarchy notation (1998) SendMail context not working on CentOS 4 (2007) RE: [WebDNA] anyone use curl with shell? (2010) cc auth with [purchase] (1998) [date] +1 (1999) Re:2nd WebCatalog2 Feature Request (1996) Shownext on AOL (2003) PIXO support (1997) BinaryBody for ReturnRaw (2003) More on the email templates (1997) Realtor Search (2000) Dual processors? (2000) Some Questions (1997) Online CC Processing (2002)