Re: sorting and grouping
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19546
interpreted = N
texte = Joe,Try something like this:[Search db=shops.db&neShopNamedatarq=[blank]&Statesumm=T] [FoundItems] [State]
[Search db=shops.db&eqStatedatarq=[State]&Citysumm=T] [FoundItems] [City]
[/FoundItems] [/Search]
[/FoundItems] [/Search] The basic idea is that the outer search summarizes by state, and then within each found state, it does another search to list the cities within that state. I used non-breaking spaces to achieve the indentation, but you could also use
or -DaveP.S> Is the benjerry.com site an in-house project? At 3:27 PM 8/21/98, Joe Wilkins wrote: >I'm using WebCat for a list of franchised scoop shops. I'm sorting on >state, city and then store name. Is there a way to group the cities >within their state and then skip a line or display the state name as a >header before listing the next state. > >I'd like the results to be something like this. > >Arizona > Tempe > Tucson > >California > Agora > Berkeley > Brentwood > Burbank > >etc. > >Joe Wilkins >Ben & Jerry's >joe@benjerry.com o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
Joe,Try something like this:[Search db=shops.db&neShopNamedatarq=[blank]&Statesumm=T] [founditems] [State]
[Search db=shops.db&eqStatedatarq=[State]&Citysumm=T] [founditems] [City]
[/FoundItems] [/Search] [/FoundItems] [/Search] The basic idea is that the outer search summarizes by state, and then within each found state, it does another search to list the cities within that state. I used non-breaking spaces to achieve the indentation, but you could also use