Re: grouping fields

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23607
interpreted = N
texte = >Hello- > >I am using the following form: > >------------ >
> > > > >VALUE=itemid+itemname+creationdate+moddate+statusid+url+desc+time+startdate+end >date+cname+aemail+aphone+afax+address+aorg+name+org+phone+fax+email+addr+country >+city+state+zip+catid> > > > > > > >Keyword:
>City:
>State:
>Zip:
>Country:
> > >
>------------ > >To set up a form to search a bunch of different grouped together fields. >When someone just does a search on the group1 field, it works just fine. >When they do a search on the group2 (or higher) field, it only searches the >first defined field city and not address as well. > >Does anyone know why this is happening? I have been pulling my hair out >trying to figure this out and I can't.You can't search group fields with eq unless BOTH or ALL of the grouped fields have values exactly equal to the value entered -- and that's going to be rare or never. Try using wo like you did with the group1 field ...Sincerely, Ken Grome WebDNA Consultant Associated Messages, from the most recent to the oldest:

    
  1. Re: Grouping Fields ( Marko Bernyk 2006)
  2. Re: Grouping Fields ( Stuart Tremain 2006)
  3. Re: Grouping Fields ( Donovan Brooke 2006)
  4. Re: Grouping Fields ( Marko Bernyk 2006)
  5. Re: Grouping Fields ( Brian Fries 2006)
  6. Re: Grouping Fields ( Clint Davis 2006)
  7. Re: Grouping Fields ( Donovan Brooke 2006)
  8. Grouping Fields ( Clint Davis 2006)
  9. Re: Grouping fields help ( Gary Krockover 2004)
  10. Re: Grouping fields help ( Gary Krockover 2004)
  11. Re: Grouping fields help ( Gary Krockover 2004)
  12. Re: Grouping fields help ( Brian Fries 2004)
  13. Re: Grouping fields help ( Donovan Brooke 2004)
  14. Re: Grouping fields help ( Donovan Brooke 2004)
  15. Re: Grouping fields help ( Rob Marquardt 2004)
  16. Re: Grouping fields help ( Gary Krockover 2004)
  17. Re: Grouping fields help ( Gary Krockover 2004)
  18. Re: Grouping fields help ( Rob Marquardt 2004)
  19. Re: Grouping fields help ( Donovan Brooke 2004)
  20. Re: Grouping fields help ( Gary Krockover 2004)
  21. Re: Grouping fields help ( Donovan Brooke 2004)
  22. Grouping fields help ( Gary Krockover 2004)
  23. Re: Grouping Fields in Context (Josh Tiger 1999)
  24. Re: Grouping Fields in Context (John Hill 1999)
  25. Re: Grouping Fields in Context (Timothy W. Killian 1999)
  26. Re: Grouping Fields in Context (John Hill 1999)
  27. Grouping Fields in Context (Timothy W. Killian 1999)
  28. Re: grouping fields (Kenneth Grome 1999)
  29. grouping fields (Josh Knauer 1999)
  30. grouping fields (Kenneth Grome 1999)
  31. Weighting of grouped results possible? (was: grouping fieldsquestion) (Dale Stokdyk 1998)
  32. Re: grouping fields question (Britt T. 1998)
  33. grouping fields question (Dale Stokdyk 1998)
  34. Re: Grouping fields problem (John Hill 1998)
  35. Re: Grouping fields problem (Dave MacLeay 1998)
  36. Re: Grouping fields problem (Britt T. 1998)
  37. Re: Grouping fields problem (Britt T. 1998)
  38. Grouping fields problem (Kenneth Grome 1998)
>Hello- > >I am using the following form: > >------------ >
> > > > >VALUE=itemid+itemname+creationdate+moddate+statusid+url+desc+time+startdate+end >date+cname+aemail+aphone+afax+address+aorg+name+org+phone+fax+email+addr+country >+city+state+zip+catid> > > > > > > >Keyword:
>City:
>State:
>Zip:
>Country:
> > >
>------------ > >To set up a form to search a bunch of different grouped together fields. >When someone just does a search on the group1 field, it works just fine. >When they do a search on the group2 (or higher) field, it only searches the >first defined field city and not address as well. > >Does anyone know why this is happening? I have been pulling my hair out >trying to figure this out and I can't.You can't search group fields with eq unless BOTH or ALL of the grouped fields have values exactly equal to the value entered -- and that's going to be rare or never. Try using wo like you did with the group1 field ...Sincerely, Ken Grome WebDNA Consultant Kenneth Grome

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:

Quick Question (1997) 2nd WebCatalog2 Feature Request (1996) SSL Certificates (2004) Searchable WebCat (etc.) Docs ? (1997) WebMerchant and Mac Auth Hub Help Please (1999) Multiple prices (1997) [TaxableTotal] - not working with AOL and IE (1997) $Append for Users outside the ADMIN group (1997) problems with 2 tags (1997) [protect admin] (1997) OT: Several requests (2003) multi-paragraph fields (1997) [WebDNA] anyway to speed up tcpconnect? (2008) Too Much Rootbeer Free Offer (1997) [WebDNA] Retrieving a PDF from an email (2008) Extended [ConvertChars] (1997) Interfacing WebMerchant to www.fedex.com (1997) SKU (1997) [WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow speeds (2019) WebCatalog host... (2000)