Re: brain teaser with an advanced search

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38793
interpreted = N
texte = >Looking for a little help with this syntax: > >I am trying to search 5 fields simultaneously using >group1field=field1+field2+field3+....... > >Then I want to summarize the results so that I get a >single list of unique values from all of these fields. > >i.e. if blue is found in both field1 and field 5, >only one instance of the value blue is returned in >the [founditems] context. > >I am sure this is simple, but the solution is eluding >me.At the very least, you would need to know which field to display. I don't think webcat will tell you that field1 was the field in the group1 that matched. So with that restriction, you are forced to do a search for as many fields as you have. Depending on the size of your data, you could try something like this[text]t_knownvalues=[/text] [listwords words=field1 field2 field3] [search ...wn[word]datarq=[t_knownvalues]&[word]summ=T&[word]sort=1] [founditems][text]t_knownvalues=[t_knownvalues][/text][/founditems] [/search] [/listwords]-Sam>Thanks! >Jeff > >__________________________________________________ >Terrorist Attacks on U.S. - How can you help? >Donate cash, emergency relief information >http://dailynews.yahoo.com/fc/US/Emergency_Information/ > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: brain teaser with an advanced search (Samuel Renkert 2001)
  2. Re: brain teaser with an advanced search (Jeff Grady 2001)
  3. Re: brain teaser with an advanced search (Jeff Grady 2001)
  4. Re: brain teaser with an advanced search (Bob McPeak 2001)
  5. Re: brain teaser with an advanced search (Jeff Grady 2001)
  6. Re: brain teaser with an advanced search (Bob McPeak 2001)
  7. brain teaser with an advanced search (Jeff Grady 2001)
>Looking for a little help with this syntax: > >I am trying to search 5 fields simultaneously using >group1field=field1+field2+field3+....... > >Then I want to summarize the results so that I get a >single list of unique values from all of these fields. > >i.e. if blue is found in both field1 and field 5, >only one instance of the value blue is returned in >the [founditems] context. > >I am sure this is simple, but the solution is eluding >me.At the very least, you would need to know which field to display. I don't think webcat will tell you that field1 was the field in the group1 that matched. So with that restriction, you are forced to do a search for as many fields as you have. Depending on the size of your data, you could try something like this[text]t_knownvalues=[/text] [listwords words=field1 field2 field3] [search ...wn[word]datarq=[t_knownvalues]&[word]summ=T&[word]sort=1] [founditems][text]t_knownvalues=[t_knownvalues][/text][/founditems] [/search] [/listwords]-Sam>Thanks! >Jeff > >__________________________________________________ >Terrorist Attacks on U.S. - How can you help? >Donate cash, emergency relief information >http://dailynews.yahoo.com/fc/US/Emergency_Information/ > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Samuel Renkert

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:

Not really WebCat- (1997) Directory Overload (1998) [ReturnRaw] and hiding FORM data (2003) question on [delete] (1998) [append] (1997) [WebDNA] Styling search results [using css] (2009) PHP vs WebCatalog (2000) really wierd browser truncating (1997) Free WebDNA snippets (Extending WebCatalog) (1997) Carraige returns [sendmail] (2004) how to check for no value while using [URL] to prevent cr (1999) WebCat2b13MacPlugIn - [include] (1997) Protect vs Authenicate (1997) TaxTotal (2003) [WebDNA] Developer Resources (2011) rn doesn't work on date fields (1998) Simple Store (2000) emailer (1997) web delivery (1997) Pithy questions on webcommerce & siteedit (1997)