[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 = 107295
interpreted = N
texte = 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. So... 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: imaginary (sample) syntax: [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] Given version 6.02, How would you do this (without a [table])? Thanks -Govinda= Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  2. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
  3. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  4. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
  5. Re: [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (aaronmichaelmusic@gmail.com 2011)
  6. [WebDNA] i wish we could require one *amongst of a collection* of search comparisons/params (Govinda 2011)
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. So... 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: imaginary (sample) syntax: [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] Given version 6.02, How would you do this (without a [table])? Thanks -Govinda= 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:

Windows Install issue (2003) [OT] IANA Special Use (2004) A Current Feature or Futre Concept (1998) Running 2 two WebCatalog.acgi's (1996) [format 40s]text[/format] doesn't work (1997) Summing fields (1997) [TaxableTotal] - not working with AOL and IE (1997) Sub Categories (2000) [fullPath] bug? (1998) japanese characters (1997) Can't load tmpl files (1997) Help name our technology! I found it (1997) WC1.6 to WC2 date formatting (1997) RE: Ongoing group search problems ... (1997) b12 cannot limit records returned and more. (1997) [WebDNA] Search on a database (2012) WEBDNA chat (2002) Date problems (1997) Re:Copyright ? (1997) Mac Vs WindowsNT (1997)