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:
> >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:
Searching using numbers (1998)
Re:2nd WebCatalog2 Feature Request (1996)
summ=T (2003)
Multiple radio buttons (1998)
Execute Applescript (1997)
Relay link (2002)
PCS Frames (1997)
Hairy Shipping Monster (2006)
appending to my last post (1999)
Setting up WebCatalog with Retail Pro data (1996)
WebCat2b13MacPlugIn - syntax to convert date (1997)
More Applescript (1997)
setLineitem blues (2000)
[WebDNA] Fresh Snow Leopard install (2009)
Forms Search Questions (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
FYI: virus alert (1996)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Error:Too many nested [xxx] contexts (1997)
Search Engines (2002)