Re: Displays by Categories

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27927
interpreted = N
texte = You need to add a test to the inner search that limits it to the current MasterCategory. Try adding this to the inner search: ...&eqMasterCategorydata=[MasterCategory]...This will limit each inner search...HTHJohn Peacock____________________Reply Separator____________________ Subject: Displays by Categories Author: (WebCatalog Talk) Date: 2/22/00 5:08 PMI 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 VinesCategory: ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAI'd like the display to be similar to this: Trees and Shrubs ACER BETULA CORNUSAnnuals BEGONIA CLEOME FUCHSIAPerrenials ACANTHUS BOLTONIA CISTUSVines 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] [Cat egory]
[/foundItems] [/search]
[/foundItems] [/search]Here's what gets displayed: Annuals ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAPerrenials ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIATrees and Shrubs ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAVines ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAThe 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Displays by Categories (jpeacock@univpress.com 2000)
You need to add a test to the inner search that limits it to the current MasterCategory. Try adding this to the inner search: ...&eqMasterCategorydata=[MasterCategory]...This will limit each inner search...HTHJohn Peacock____________________Reply Separator____________________ Subject: Displays by Categories Author: (WebCatalog Talk) Date: 2/22/00 5:08 PMI 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 VinesCategory: ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAI'd like the display to be similar to this: Trees and Shrubs ACER BETULA CORNUSAnnuals BEGONIA CLEOME FUCHSIAPerrenials ACANTHUS BOLTONIA CISTUSVines 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] [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 WISTERIAPerrenials ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIATrees and Shrubs ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAVines ACER BETULA CORNUS BEGONIA CLEOME FUCHSIA ACANTHUS BOLTONIA CISTUS ACTINIDIA CAMPSIS WISTERIAThe 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 jpeacock@univpress.com

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:

Nesting [RAW] (1998) Spreadsheet App pref. [OT] (2001) Prices Dropped (1998) Plugin or CGI or both (1997) WebCat2_Mac RETURNs in .db (1997) turning every 5th line red (1999) Q: writefile and uploads. (1998) Bug or syntax error on my part? (1997) WebCatalog for Mac 2.0.1 Released (1997) Template Security error (1997) WC2b15 File Corruption (1997) Setting up WebCatalog with Retail Pro data (1996) Moment of Thanks (1997) testing (2001) WebCat2 several catalogs? (1997) Dumb Question about Docs (1997) Re1000001: Setting up shop (1997) Hosting accounts (2006) Online reference (1997) WebCat2b13MacPlugIn - syntax to convert date (1997)