Re: Grouping fields problem

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20714
interpreted = N
texte = >group1field=company >wogroup1datarq=GTE >group1word=ss >group2field=company >wogroup2datarq=U.S.%WEST >group2word=ss > >... and my results were exactly the same as when I used only this parameter: > >wocompanydatarq=GTE> >Therefore, this means that all the group2field stuff above was apparently ignored (for some unknown reason) ... :(By default, the word match is sub-string, so taking out the groupxword parameters won't make any difference on the search. the text you have U.S.%WEST is probably not in the database (with the percent sign) so perhaps that's causing the confusion.>By the way, when I removed the rq's from both search parameters above, the search retrieved all the records in the database, another incorrect result ... :(Considering it was search for all records that had a U or S in them, returning all the records seems possible.JOhn. John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Grouping fields problem (John Hill 1998)
  2. Re: Grouping fields problem (Dave MacLeay 1998)
  3. Re: Grouping fields problem (Britt T. 1998)
  4. Re: Grouping fields problem (Britt T. 1998)
  5. Grouping fields problem (Kenneth Grome 1998)
>group1field=company >wogroup1datarq=GTE >group1word=ss >group2field=company >wogroup2datarq=U.S.%WEST >group2word=ss > >... and my results were exactly the same as when I used only this parameter: > >wocompanydatarq=GTE> >Therefore, this means that all the group2field stuff above was apparently ignored (for some unknown reason) ... :(By default, the word match is sub-string, so taking out the groupxword parameters won't make any difference on the search. the text you have U.S.%WEST is probably not in the database (with the percent sign) so perhaps that's causing the confusion.>By the way, when I removed the rq's from both search parameters above, the search retrieved all the records in the database, another incorrect result ... :(Considering it was search for all records that had a U or S in them, returning all the records seems possible.JOhn. John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com John Hill

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:

Email Set-Up? (1997) Am I going senile? (Price recalc based on quantity) (1997) Emailer (WebCat2) (1997) USPS Intergration (2001) [addlineitems] (1997) RE: NewCart+Search with one click ? (1997) Locking up with WebCatalog... (1997) nslookup (2000) 2.0Beta Command Ref (can't find this instruction) (1997) [Announce]: Web server security and password protection (1997) Bug or syntax error on my part? (1997) newbies to web, spaces in email address (1998) REVISED: Help needed: older WebCat app breaks under 4.0.1 (2000) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) New (1998) Setting up shop (1997) Error Lob.db records error message not name (1997) mapping fields between databases (2001) Trouble with formula.db (1997) Include a big block of text (1997)