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:

Thanks ! (1997) Un[url]ize (1999) bug in [SendMail] (1997) Simple form with picture upload (2005) [URGENT] Different Results From Math Tag Depending On OS (2006) combine search (1998) Emailer port change (1997) [OT] HTML Table Cell Problem (2003) Search or Lookup before Append (1998) NetScape problem (1999) multiple replace sku data (2003) Date Sorting (1997) customizing the color of user's pages (1997) [shell] (2003) PIXO support (1997) Date problems-more (1997) I think WebDNA-Talk died ... :( (1997) Problems with [Search] param - Mac Plugin b15 (1997) problems with 2 tags (1997) filtering [founditems] (2004)