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 = 107296
interpreted = N
texte = It looks like a GroupFields in the search string would do the trick On Aug 28, 2011, at 7:46 PM, Govinda wrote: > 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--------------------------------------------------------- > 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:
It looks like a GroupFields in the search string would do the trick On Aug 28, 2011, at 7:46 PM, Govinda wrote: > 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--------------------------------------------------------- > 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
aaronmichaelmusic@gmail.com
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:
cookies and [returnraw] (1997)
Searching multiple records for certain info (2000)
WebCatalog for guestbook ? (1997)
[WebDNA] new list (2008)
Sandbox Question (2003)
Unexpected comparison behavior change in 4.5.1 (2003)
Calendar using WebCatalog? (1997)
Bug or syntax error on my part? (1997)
security (1997)
Shhh... (2006)
summ=T (2003)
Performance Tuning (2006)
wc 2 pro users - sites, quotes wanted (1997)
[WebDNA] Installing with MAMP (2015)
Frames and WebCat (1997)
[WebDNA] Bullet proof dynamic tables (2009)
WebMerchant - MacAuthorize (1999)
WebDNA FAQ or FAQs -- was "weird problem" (2004)
New commands in Final candidate (1997)
[WriteFile] problems (1997)