Re: Grouping Fields in Context

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24638
interpreted = N
texte = Hi... > Group is only important in the search string. Inside [founditems] you only use > the field names [quote1], etc. > > JOhn.If I use the field name quote1 in the found items, it will only pull in the specific field I call, correct? So, in other words, it won't randomly pull in a quote from any of the other fields (quote2, quote3, quote4). Can I not accomplish what I am trying to accomplish by grouping fields?Tim >> Hi Webcats: >> >> Well, after having struggled with this one for several hours, it's time to >> give the list a shot :-) >> >> Here's the challenge. I have a database that contains music reviews. Each >> record contains a single review, plus 4 fields for quotes from that review >> (quote1, quote2, quote3, quote4). I want to be able to randomly display a >> single quote from any of the quotes found within the database. I want this >> to display on the first page of the website. (see the site at >> http://www.marylydiaryan.com) >> >> Here is the code that I have tried, but which is not working. >> >> [search >> db=newsite/mlrreviews.txt&group1field=quote1+quote2+quote3+quote4&negroup1da >> ta=0&group1sort=1&group1sdir=ra&max=1] >> [foundItems][group1][/founditems][/search] >> >> I have been guessing as to what I should place within [founditems] as this >> information is not listed in any of the documentation nor mentioned in any >> of the searchable archives. I have tried both [group1] and [group1field]. >> >> I am successfully accomplishing a similar search to pull in a random quote >> based on a single quote field: >> >> [search >> db=newsite/mlrreviews.txt&nequote1data=0"e1sort=1"e1sdir=ra&max=1] >> [foundItems] >> [quote1] >> [/foundItems] >> [/search] >> >> Any help will be greatly appreciated. >> >> Timothy W. Killian >> --------------------------- >> wb: http://www.eventure.com >> ph: 206.559.2200 >> --------------------------- >> >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > > > --------------------------------- > John A. Hill > Smith Micro Software > Internet Solutions Division > eCommerce / Consulting / Hosting > http://www.smithmicro.com > (formerly Pacific Coast Software) > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Grouping Fields in Context (Josh Tiger 1999)
  2. Re: Grouping Fields in Context (John Hill 1999)
  3. Re: Grouping Fields in Context (Timothy W. Killian 1999)
  4. Re: Grouping Fields in Context (John Hill 1999)
  5. Grouping Fields in Context (Timothy W. Killian 1999)
Hi... > Group is only important in the search string. Inside [founditems] you only use > the field names [quote1], etc. > > JOhn.If I use the field name quote1 in the found items, it will only pull in the specific field I call, correct? So, in other words, it won't randomly pull in a quote from any of the other fields (quote2, quote3, quote4). Can I not accomplish what I am trying to accomplish by grouping fields?Tim >> Hi Webcats: >> >> Well, after having struggled with this one for several hours, it's time to >> give the list a shot :-) >> >> Here's the challenge. I have a database that contains music reviews. Each >> record contains a single review, plus 4 fields for quotes from that review >> (quote1, quote2, quote3, quote4). I want to be able to randomly display a >> single quote from any of the quotes found within the database. I want this >> to display on the first page of the website. (see the site at >> http://www.marylydiaryan.com) >> >> Here is the code that I have tried, but which is not working. >> >> [search >> db=newsite/mlrreviews.txt&group1field=quote1+quote2+quote3+quote4&negroup1da >> ta=0&group1sort=1&group1sdir=ra&max=1] >> [founditems][group1][/founditems][/search] >> >> I have been guessing as to what I should place within [founditems] as this >> information is not listed in any of the documentation nor mentioned in any >> of the searchable archives. I have tried both [group1] and [group1field]. >> >> I am successfully accomplishing a similar search to pull in a random quote >> based on a single quote field: >> >> [search >> db=newsite/mlrreviews.txt&nequote1data=0"e1sort=1"e1sdir=ra&max=1] >> [founditems] >> [quote1] >> [/foundItems] >> [/search] >> >> Any help will be greatly appreciated. >> >> Timothy W. Killian >> --------------------------- >> wb: http://www.eventure.com >> ph: 206.559.2200 >> --------------------------- >> >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > > > --------------------------------- > John A. Hill > Smith Micro Software > Internet Solutions Division > eCommerce / Consulting / Hosting > http://www.smithmicro.com > (formerly Pacific Coast Software) > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Timothy W. Killian

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:

Using Web* mail instead of Emailer? (1999) WebCatalog 2.0 b 15 mac (1997) WC 2.0 frames feature (1997) Format question WC Mac f3 (1997) File upload woes (1998) all records returned. (1997) PCS Emailer's role ? (1997) Navigator 4.01 (1997) WC2.0 Memory Requirements (1997) WebDNA deletes major DB data big time (2004) [ConvertChars] problem (1997) [WebDNA] suggestion: listwords return xth word (2017) Tab Charactor (1997) WebDNA Writer Needed (1997) Cleaning up all the shopping carts (2000) Problem (1997) Carts & Refering URLs (1997) Initiating NewCart (1997) bad time on my email was [url] issue (2000) Re:Need help... (1997)