Displays by Categories
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27925
interpreted = N
texte = I sure can use some help, please.My database contains fields for Type of Plant (called MasterCategory) andits Genus (called Category). I'd like to display the MasterCategory and havethe Categories associated with each type display below.Examples are--MasterCategory:Trees and ShrubsAnnualsPerrenialsVinesCategory:ACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAI'd like the display to be similar to this:Trees and Shrubs ACER BETULA CORNUSAnnuals BEGONIA CLEOME FUCHSIAPerrenials ACANTHUS BOLTONIA CISTUSVines ACTINIDIA CAMPSIS WISTERIAI set it up as follows:[search db=TeaRoom.db&geSKUdata=0&MasterCategorysumm=t&asMasterCategorysort=1][foundItems]
[MasterCategory]--[searchdb=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1][foundItems][Category]
[/foundItems][/search][/foundItems][/search]Here's what gets displayed:AnnualsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAPerrenialsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIATrees and ShrubsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAVinesACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAThe MasterCategory is displayed properly, but ALL Categories are displayedfor each one. I tried using a [showif] or [hideif], but have no comparisonto use.How can I get this to display ONLY the Categories associated with eachMasterCategory?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:
I sure can use some help, please.My database contains fields for Type of Plant (called MasterCategory) andits Genus (called Category). I'd like to display the MasterCategory and havethe Categories associated with each type display below.Examples are--MasterCategory:Trees and ShrubsAnnualsPerrenialsVinesCategory:ACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAI'd like the display to be similar to this:Trees and Shrubs ACER BETULA CORNUSAnnuals BEGONIA CLEOME FUCHSIAPerrenials ACANTHUS BOLTONIA CISTUSVines ACTINIDIA CAMPSIS WISTERIAI set it up as follows:[search db=TeaRoom.db&geSKUdata=0&MasterCategorysumm=t&asMasterCategorysort=1][founditems][MasterCategory]--
[searchdb=TeaRoom.db&geSKUdata=0&Categorysumm=t&asCategorysort=1][founditems][cart]&category=[url][Category][/url]&startat=1>[Category]
[/foundItems][/search]
[/foundItems][/search]Here's what gets displayed:AnnualsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAPerrenialsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIATrees and ShrubsACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAVinesACERBETULACORNUSBEGONIACLEOMEFUCHSIAACANTHUSBOLTONIACISTUSACTINIDIACAMPSISWISTERIAThe MasterCategory is displayed properly, but ALL Categories are displayedfor each one. I tried using a [showif] or [hideif], but have no comparisonto use.How can I get this to display ONLY the Categories associated with eachMasterCategory?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
Glenn Busbin
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:
Return records from another (1997)
Not really WebCat (1997)
[table] strange behaviour (2003)
Re:2nd WebCatalog2 Feature Request (1996)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Unexpected error (1997)
ErrorMessages.db (1998)
[OT] Dedicated Image Uploader/Server [/OT] (2003)
Image as submit button (2000)
RED QUESTION MARK (1999)
Nested tags count question (1997)
[WebDNA] How to code a 301 redirect (2008)
[isfile] ? (1997)
Encrypt File (2006)
[format xs] freeze (1997)
[WebDNA] mac osx permissions problem (2010)
WebCat/Typhoon Status under Windows (1998)
I got caught! (2003)
can webcat create directories on NT? (1997)
Looping a variable name with [index] (1999)