Re: Displays by Categories

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27928
interpreted = N
texte = Your sub-search: [search db=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1]id searching for everything that has an SKU greater than zero.Try using: [search db=TeaRoom.db&eqMasterCategorydata=[MasterCategory]&asCategorysort=1]This says that any record that has the current master category matching the outer search should be listed. -Chuck- At 5:08 PM 2000/02/22, Glenn Busbin wrote:>I sure can use some help, please. > >My database contains fields for Type of Plant (called MasterCategory) and >its Genus (called Category). I'd like to display the MasterCategory and have >the Categories associated with each type display below. > >Examples are-- >MasterCategory: >Trees and Shrubs >Annuals >Perrenials >Vines > >Category: >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >I'd like the display to be similar to this: >Trees and Shrubs > ACER > BETULA > CORNUS > >Annuals > BEGONIA > CLEOME > FUCHSIA > >Perrenials > ACANTHUS > BOLTONIA > CISTUS > >Vines > ACTINIDIA > CAMPSIS > WISTERIA > > >I set it up as follows: > >[search >db=TeaRoom.db&geSKUdata=0&MasterCategorysumm=t&asMasterCategorysort=1] >[foundItems] >[MasterCategory]--
> >[search >db=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1] >[foundItems] >href=Results.tpl?cart=[cart]&category=[url][Category][/url]&startat=1>[Cat >egory]
>[/foundItems] >[/search] > >
>[/foundItems] >[/search] > >Here's what gets displayed: >Annuals >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Perrenials >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Trees and Shrubs >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Vines >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >The MasterCategory is displayed properly, but ALL Categories are displayed >for each one. I tried using a [showif] or [hideif], but have no comparison >to use. > >How can I get this to display ONLY the Categories associated with each >MasterCategory? > >TIA, >Glenn > > >------------------------------------------------------------- >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 >__________________________________________________________________________ Chuck Rice ------------------------------------------------------------- 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: Displays by Categories (Glenn Busbin 2000)
  2. Re: Displays by Categories (Chuck Rice 2000)
  3. Re: Displays by Categories (jpeacock@univpress.com 2000)
  4. Re: Displays by Categories (Matt Helbing 2000)
  5. Displays by Categories (Glenn Busbin 2000)
Your sub-search: [search db=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1]id searching for everything that has an SKU greater than zero.Try using: [search db=TeaRoom.db&eqMasterCategorydata=[MasterCategory]&asCategorysort=1]This says that any record that has the current master category matching the outer search should be listed. -Chuck- At 5:08 PM 2000/02/22, Glenn Busbin wrote:>I sure can use some help, please. > >My database contains fields for Type of Plant (called MasterCategory) and >its Genus (called Category). I'd like to display the MasterCategory and have >the Categories associated with each type display below. > >Examples are-- >MasterCategory: >Trees and Shrubs >Annuals >Perrenials >Vines > >Category: >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >I'd like the display to be similar to this: >Trees and Shrubs > ACER > BETULA > CORNUS > >Annuals > BEGONIA > CLEOME > FUCHSIA > >Perrenials > ACANTHUS > BOLTONIA > CISTUS > >Vines > ACTINIDIA > CAMPSIS > WISTERIA > > >I set it up as follows: > >[search >db=TeaRoom.db&geSKUdata=0&MasterCategorysumm=t&asMasterCategorysort=1] >[founditems] >[MasterCategory]--
> >[search >db=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1] >[founditems] >href=Results.tpl?cart=[cart]&category=[url][Category][/url]&startat=1>[Cat >egory]
>[/foundItems] >[/search] > >
>[/foundItems] >[/search] > >Here's what gets displayed: >Annuals >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Perrenials >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Trees and Shrubs >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >Vines >ACER >BETULA >CORNUS >BEGONIA >CLEOME >FUCHSIA >ACANTHUS >BOLTONIA >CISTUS >ACTINIDIA >CAMPSIS >WISTERIA > >The MasterCategory is displayed properly, but ALL Categories are displayed >for each one. I tried using a [showif] or [hideif], but have no comparison >to use. > >How can I get this to display ONLY the Categories associated with each >MasterCategory? > >TIA, >Glenn > > >------------------------------------------------------------- >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 >__________________________________________________________________________ Chuck Rice ------------------------------------------------------------- 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 Chuck Rice

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:

Dr. Watson Error (1998) FAX orders (1996) emailer w/F2 (1997) [WebDNA] Encrypted Templates - Includes (2014) [ot] Webserver monitoring (2001) HELP WITH DATES (1997) Server problem? (1998) WebCatalog.acgi quitting with error Type 2 (1998) Banner DNA (1997) creative use of webcatalog (1998) Micro-managing External Links (2006) Force a number (1998) NT [delete] (1998) [WebDNA] Hosting Solution (2013) Making webcam movies (2003) Summing fields (1997) Where's Cart Created ? (1997) Pithy questions on webcommerce & siteedit (1997) apparent variable variable display? (2000) The Guru Speaks-very long reply (1998)