Re: brain teaser with an advanced search
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38792
interpreted = N
texte = Oops. It really looks like this: [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][founditems] [FIELD2]
[/founditems][/search] --- Jeff Grady
wrote: > 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: > === message truncated === __________________________________________________ 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:
Oops. It really looks like this: [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][founditems] [FIELD2]
[/founditems][/search] --- Jeff Grady wrote: > 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: > === message truncated === __________________________________________________ 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:
WC2.0 Memory Requirements (1997)
process SSI (1998)
Securing/hiding database file (2000)
format_to_days on NT (1997)
[input] [/input] (1997)
Allow-Deny: Solved with [Getchars] (1998)
rotating thumbnails (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Search/sort in URL Was: GuestBook example (1997)
WebCat2b15MacPlugin - [protect] (1997)
Re:Help name our technology! (1997)
Subtotal help (1997)
WebCatalog 4.0.2b5 available (2000)
security problem (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
[LOOKUP] (1997)
emailer (1997)
Possible Bug in 2.0b15.acgi (1997)
Using WC for Bulk Emailings (1997)
bug in [SendMail] (1997)