Re: Summary layout

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14933
interpreted = N
texte = > >I've tried a summary sort on manufacturer and a nested search, repeating the > >search args from the original search form. > > > >This is slow because the search has to be repeated for every match. > > > >Is there a better way of sorting results underneath each summarized catagory? > > 2.1b2 is very slow with this kind of thing. Is 2.0.1 acceptable?It's quite a bit better speed-wise. > We're considering future methods of caching search results, too, to speed interior searches like this.It just needs a function to cache the prevoius x records. Then you could immediately check the contents of a prevoius record ([index]-x). If I want to do a layout like:Brand: Ford Blue Truck Red Car Orange VanBrand: Chevy Grey Van Tan Car White PickupI should just be able to hide the brand if it didn't change from the last record.It's simple to do: brand description ford blue truck ford red car ford orange van chevy grey van chevy tan car chevy white pickupIt's easy to replace the brand name with a logo. But one of the most common requests I get is to eliminate redundant display of manufacturer or brand, and that's where I get tangled up with nested searches.I'm currently trying this approach:[founditems][showif [index]=1] [brand] [/showif][showif [index]>1] [showif [index]\2] [showif [brand]![math]lastbrand[/math]] [brand] [/showif] [/showif] [hideif [index]\2] [showif [brand]![math]lastbrand[/math]] [brand] [/showif] [/hideif] [/showif][description][/founditems] I haven't debugged this so I don't know if it toggles properly, but I'm just trying to use a form variable (lastbrand) to cache the [brand] of the prevoius record. Needless to say, I'm going buggy with this approach. A hostage crisis may be at hand.Regards, Pat Associated Messages, from the most recent to the oldest:

    
  1. Re: Summary layout (Marty Schmid 1997)
  2. Re: Summary layout (Pat McCormick 1997)
  3. Re: Summary layout (Marty Schmid 1997)
  4. Re: Summary layout (Pat McCormick 1997)
  5. Re: Summary layout (Pat McCormick 1997)
  6. Re: Summary layout (Grant Hulbert 1997)
  7. Summary layout (Pat McCormick 1997)
> >I've tried a summary sort on manufacturer and a nested search, repeating the > >search args from the original search form. > > > >This is slow because the search has to be repeated for every match. > > > >Is there a better way of sorting results underneath each summarized catagory? > > 2.1b2 is very slow with this kind of thing. Is 2.0.1 acceptable?It's quite a bit better speed-wise. > We're considering future methods of caching search results, too, to speed interior searches like this.It just needs a function to cache the prevoius x records. Then you could immediately check the contents of a prevoius record ([index]-x). If I want to do a layout like:Brand: Ford Blue Truck Red Car Orange VanBrand: Chevy Grey Van Tan Car White PickupI should just be able to hide the brand if it didn't change from the last record.It's simple to do: brand description ford blue truck ford red car ford orange van chevy grey van chevy tan car chevy white pickupIt's easy to replace the brand name with a logo. But one of the most common requests I get is to eliminate redundant display of manufacturer or brand, and that's where I get tangled up with nested searches.I'm currently trying this approach:[founditems][showif [index]=1] [brand] [math]lastbrand=[brand][/math]> [/showif][showif [index]>1] [showif [index]\2] [showif [brand]![math]lastbrand[/math]] [brand] [math]lastbrand=[brand][/math]> [/showif] [/showif] [hideif [index]\2] [showif [brand]![math]lastbrand[/math]] [brand] [math]lastbrand=[brand][/math]> [/showif] [/hideif] [/showif][description][/founditems] I haven't debugged this so I don't know if it toggles properly, but I'm just trying to use a form variable (lastbrand) to cache the [brand] of the prevoius record. Needless to say, I'm going buggy with this approach. A hostage crisis may be at hand.Regards, Pat Pat McCormick

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:

WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) AND/OR searches in WebCat 3.07 (2003) Re:Non-technical messages ... (1997) New WebCatalog site! (1997) webcat2b12 CGI -- Date comparisons (1997) OT: CT Scan might have saved my life!! (2006) Databases going to sleep (1998) [Announce]: Web server security and password protection (1997) Auto entering Friday's date in a field (2002) Opinion: [input] should be called [output] ... (1997) taxTotal (1997) Windows 2.1b2 Append Bug? (1997) GetWords (2004) problems with 2 tags (1997) Dynamic PDFs? (2002) [WebDNA] OAuth - anybody done this yet? (2009) [BoldWords] WebCat.acgib15Mac (1997) group searching problem (2002) Building Calendars (1997) TcpConnect get files on ver. 5.x BUG BUG BUG (2004)