Re: brain teaser with an advanced search
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38791
interpreted = N
texte = Here is what I tried to no avail: [search db=db/aboards.db&grFIELD1datarq=0&FIELD1summ=T&FIELD1sort=1] [founditems][FIELD1]
[/founditems][/search] [!]This returns a summary of all values in the FIELD1 field[/!][!]Now summarize all values in FIELD2 that are not in FIELD1[\!] [search db=db/aboards.db&grFIELD2datarq=0[search db=db/aboards.db&grFIELD1datarq=0&FIELD1summ=T&FIELD1sort=1][founditems] &neFIELD2datarq=[FIELD1] [founditems][/search]&FIELD2summ=T&FIELD2sort=1] [FIELD2]
[founditems][/search]This for some reason does not work. Still stumped. --- Bob McPeak
wrote: > 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/ __________________________________________________ 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/
Associated Messages, from the most recent to the oldest:
Here is what I tried to no avail: [search db=db/aboards.db&grFIELD1datarq=0&FIELD1summ=T&FIELD1sort=1] [founditems][FIELD1]
[/founditems][/search] [!]This returns a summary of all values in the FIELD1 field[/!][!]Now summarize all values in FIELD2 that are not in FIELD1[\!] [search db=db/aboards.db&grFIELD2datarq=0[search db=db/aboards.db&grFIELD1datarq=0&FIELD1summ=T&FIELD1sort=1][founditems] &neFIELD2datarq=[FIELD1] [founditems][/search]&FIELD2summ=T&FIELD2sort=1] [FIELD2]
[founditems][/search]This for some reason does not work. Still stumped. --- Bob McPeak wrote: > 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/ __________________________________________________ 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/
Jeff Grady
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:
Sorry Off Topic! (1998)
Weird Math and SV Bad News (1997)
Separate SSL Server (1997)
problem: type 2 errors (1997)
Grouping search fields, etc. (1997)
Web DNA... (2007)
(2001)
Comments in db? (1997)
HTML encoding in URLs (1997)
[ShowNext] (1997)
Opinion: [input] should be called [output] ... (1997)
filemaker - orderfile (1997)
Checkbox question (1997)
Superfilous Characters (1998)
Random Number Generator works for Ranges of Numbers (1997)
WebDNA 5.0 Enterprise Edition (2003)
unique ascending numbers (2003)
[recordrank]? (2000)
Summing fields (1997)
Sorting Dates (2000)