Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107297
interpreted = N
texte = I am pretty sure I tried that (in the past), but, IIRC, grouping fields = does not work when you have other search params/criteria *outside* of = the grouped fields; grouped fields are only useful when they are the = only search criteria. Thanks for replying. :-) Anyone have any ideas? Thanks -Govinda On 2011-08-29, at 10:02 AM, aaronmichaelmusic@gmail.com wrote: > It looks like a GroupFields in the search string would do the trick >=20 >> I need to find records that belong to a client (in a db full of = records for lots of clients), *AND* where a user-input string is found = in one of several other fields. >>=20 >> So... >>=20 >> I wish i had a good quick way (without loading a big RAM [table] = (which crash webdna when they get too large)) to effectively do this: >>=20 >> imaginary (sample) syntax: >>=20 >> [Search = db=3Dqqqqqq.db&eqTHIS_FIELDxxx_REQUIREDdatarq=3D[aaa]&eqFIELDyyydatarq1of2= =3D[bbb]&eqFIELDzzzdatarq2of2=3D[bbb]] >> [!]--- >> would return records where: >> 1.) [THIS_FIELDxxx_REQUIRED] *necessarily = contained* "[aaa]" >> *AND*=20 >> 2.) *ANY* (*but at least one*) of these = conditions were met: >> 2a.) [FIELDyyy] contained "[bbb]" >> *OR* >> 2b.) [FIELDzzz] contained "[bbb]" >> ---[/!] >> [/Search] >>=20 >>=20 >> Given version 6.02, How would you do this (without a [table])? >>=20 >> Thanks >> -Govinda - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Associated Messages, from the most recent to the oldest:
I am pretty sure I tried that (in the past), but, IIRC, grouping fields = does not work when you have other search params/criteria *outside* of = the grouped fields; grouped fields are only useful when they are the = only search criteria. Thanks for replying. :-) Anyone have any ideas? Thanks -Govinda On 2011-08-29, at 10:02 AM, aaronmichaelmusic@gmail.com wrote: > It looks like a GroupFields in the search string would do the trick >=20 >> I need to find records that belong to a client (in a db full of = records for lots of clients), *AND* where a user-input string is found = in one of several other fields. >>=20 >> So... >>=20 >> I wish i had a good quick way (without loading a big RAM
[table] = (which crash webdna when they get too large)) to effectively do this: >>=20 >> imaginary (sample) syntax: >>=20 >> [Search = db=3Dqqqqqq.db&eqTHIS_FIELDxxx_REQUIREDdatarq=3D[aaa]&eqFIELDyyydatarq1of2= =3D[bbb]&eqFIELDzzzdatarq2of2=3D[bbb]] >>
[!]--- >> would return records where: >> 1.) [THIS_FIELDxxx_REQUIRED] *necessarily = contained* "[aaa]" >> *AND*=20 >> 2.) *ANY* (*but at least one*) of these = conditions were met: >> 2a.) [FIELDyyy] contained "[bbb]" >> *OR* >> 2b.) [FIELDzzz] contained "[bbb]" >> ---[/!] >> [/Search] >>=20 >>=20 >> Given version 6.02, How would you do this (without a
[table])? >>=20 >> Thanks >> -Govinda - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Govinda
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:
RE: Signal Raised (1997)
Search design (1997)
Date Formats (1997)
[click][/click] (1999)
SM's Tech Help (2000)
Lookup Notfound (1998)
emailer on Windows Beta 18 (1997)
sorting by date Y2K mix up (2000)
NT [delete] - duh nevermind. (1998)
shipping & multiple comparisons? (2000)
delete after x (1998)
Using [redirect] in the middle of a page? (1999)
Getting total number of items ordered (1997)
RE: WebCatalog2 for NT Beta Request (1997)
Snake Bites (1997)
[append] vs. [appendfile] delta + question? (1997)
problem with NT beta (1997)
[WebDNA] Pretty URLS (2011)
4.5's frequency of math problem running as demo? (2002)
Pull Down Search (2000)