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:
How true is this? (1999)
Email (1998)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
SET and C-SET (1998)
remotely add + sign (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
'does not contain' operator needed ... (1997)
New NT beta available (1997)
In Digest Dijon (2000)
Whats going on with my SERIAL NUMBER??? (1998)
pc (1997)
message forum question (2005)
Can't Update records (1997)
WebCatalog NT beta 18 problem (1997)
WebCatalog 3 for Macintosh (1998)
service stop and restart (1997)
[WebDNA] Combining searches with blank and zero values? (2011)
PCS Frames (1997)
Ken's Data Manager (was dbQuickView 2.0) (2005)
iTools and 3.0.8 (2000)