What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  1. Re: brain teaser with an advanced search (Samuel Renkert 2001)
  2. Re: brain teaser with an advanced search (Jeff Grady 2001)
  3. Re: brain teaser with an advanced search (Jeff Grady 2001)
  4. Re: brain teaser with an advanced search (Bob McPeak 2001)
  5. Re: brain teaser with an advanced search (Jeff Grady 2001)
  6. Re: brain teaser with an advanced search (Bob McPeak 2001)
  7. brain teaser with an advanced search (Jeff Grady 2001)
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:

Bug or syntax error on my part? (1997) WebCatalog for guestbook ? (1997) ShowIf variables (1997) Newbie trouble with [url] & [foundItems] (2000) [WebDNA] 6.2 Sorry WebDNA server not running (2015) weiered lookup (2004) Highlighting words found in a keyword search (2003) [LOOKUP] (1997) Loss in Form (1998) Snake Bites (1997) DHTML Tag Feature (2000) WebCatalog on G3 Macs? (1997) [if] (2003) [ShowNext] (1997) Examples Link? (2000) stray LF character in the email (2003) [foundItems] context problem (2000) Webdna websites (2004) Path of Events (1999) First postarg not taking in $Commands (1997)