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 trickOn 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 trickOn 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:
ichat (2003)
Cookie woes with Mac IE4 (1998)
Questions (1998)
Lost Field (1998)
Beta 18 (1997)
Another question (1997)
[math] variable question (1997)
Webcat Hosting in London or UK (2003)
RequiredFields template (1997)
OK to delete records while finding them? (2000)
Site / Database Structure (2002)
Questions To Answer (1997)
setting HTTP response header (1998)
[ModDate] & [ModTime] ? (1997)
Associative lookup style? (1997)
different show next (1997)
Sending emails (2002)
Help name our technology! (1997)
E-Mail (1998)
Erotic Sites (1997)