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:
>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)