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:

Browsername (1998) [shownext max=?] armed (1997) Trigger Bug? (2000) WebCat2 beta 11 - new prefs ... (1997) hyperlinking unique input strings on the fly when displaying in HTML (2000) wrong authentication (1998) ConverChars (1999) cookies and [returnraw] (1997) WebCatalog [FoundItems] Problem - LONG - (1997) getmimeheader host on my local machine (2003) Not really WebCat (1997) Buying sans cart (1997) WebCat2.0 acgi vs plugin (1997) Listserver problem (1997) RE: E-mailer error codes (1997) Help! WebCat2 bug (1997) OT: Raid Software on OSX (2003) [WriteFile] problems (1997) [SHOWIF AND/OR] (1997) includes and cart numbers (1997)