Re: brain teaser with an advanced search
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38789
interpreted = N
texte = Good point. Obviously you've already tried [group1] and it didn't work.I've done a solution for this problem in the past using a text declare and a hideif.Something like this:[text]thevalues=[/text] [founditems] [hideif [thevalues]^[yourfieldhere]] Display [yourfieldhere] [/hideif] [text]thevalues=[thevalues],[yourfieldhere][/text] [/founditems]This will display on field values that have not already been added to the string. (Although my example may need some tweaking/debugging.)Another, perhaps better way to do it, would be to first declare all your values in a text string, then use a listwords:[text]thevalues=[/text] [founditems] [text]thevalues=[thevalues],[hideif [thevalues]^[yourfield1here]][yourfield1here],[/hideif] ][hideif [thevalues]^[yourfield2here]][yourfield2here],[/hideif] [/text] [/founditems]Code like that will only add each unique value to the string once. Then list them with a listwords.Hope this helps. I've been out of work for about 10 days now, and am getting slightly rusty, not that I was very sharp before. ----- Original Message ----- From: Jeff Grady
To: WebCatalog Talk Sent: Thursday, September 20, 2001 12:35 PM Subject: Re: brain teaser with an advanced search > But what value do you put between [founditems]? > > --- Bob McPeak wrote: > > &group1fieldsumm=t ought to do it. > > > > > > ----- Original Message ----- > > From: Jeff Grady > > To: WebCatalog Talk > > > > Sent: Thursday, September 20, 2001 12:20 PM > > Subject: brain teaser with an advanced search > > > > > > > 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. > > > > > > 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/ > > > __________________________________________________ > 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:
Good point. Obviously you've already tried [group1] and it didn't work.I've done a solution for this problem in the past using a text declare and a hideif.Something like this:[text]thevalues=[/text] [founditems] [hideif [thevalues]^[yourfieldhere]] Display [yourfieldhere] [/hideif] [text]thevalues=[thevalues],[yourfieldhere][/text] [/founditems]This will display on field values that have not already been added to the string. (Although my example may need some tweaking/debugging.)Another, perhaps better way to do it, would be to first declare all your values in a text string, then use a listwords:[text]thevalues=[/text] [founditems] [text]thevalues=[thevalues],[hideif [thevalues]^[yourfield1here]][yourfield1here],[/hideif] ][hideif [thevalues]^[yourfield2here]][yourfield2here],[/hideif] [/text] [/founditems]Code like that will only add each unique value to the string once. Then list them with a listwords.Hope this helps. I've been out of work for about 10 days now, and am getting slightly rusty, not that I was very sharp before. ----- Original Message ----- From: Jeff Grady To: WebCatalog Talk Sent: Thursday, September 20, 2001 12:35 PM Subject: Re: brain teaser with an advanced search > But what value do you put between [founditems]? > > --- Bob McPeak wrote: > > &group1fieldsumm=t ought to do it. > > > > > > ----- Original Message ----- > > From: Jeff Grady > > To: WebCatalog Talk > > > > Sent: Thursday, September 20, 2001 12:20 PM > > Subject: brain teaser with an advanced search > > > > > > > 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. > > > > > > 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/ > > > __________________________________________________ > 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/
Bob McPeak
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:
Running 2 two WebCatalog.acgi's (1996)
Trouble with formula.db (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
catagories (1997)
problems with 2 tags shakur (1997)
version 2 for NT (1997)
WebCatalog stalls (1998)
all records returned. (1997)
WebCatalog 4.0 has been released! (2000)
About WebDNA (2006)
Country & Ship-to address & other fields ? (1997)
WebCat2.0 [format thousands .0f] no go (1997)
.html to .tpl (1998)
purchase plugin (1996)
WebCat2b13MacPlugIn - [include] (1997)
[WebDNA] Cicada (2009)
Generating unique SKU from [cart] (1997)
Sitebuilder (2004)
Saving Text Areas with Orders (1997)
using showpage and showcart commands (1996)