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:
RE: Cart Template (1997)
Sorting by date (1997)
[BoldWords] WebCat.acgib15Mac (1997)
Support ?? (1997)
off-topic - printinglib 68K (1997)
Outsourcing partnership ... (2005)
eMail volume (2000)
Help name our technology! (1997)
bypassing typo's (1998)
In Digest Dijon (2000)
Multiple prices (1997)
Multiple 'Users.db' files not possible (1997)
FTP and [shell] (2003)
Error Lob.db records error message not name (1997)
Server Load (2000)
FEATURE REQUEST: Auto Resizing of images (2002)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
WebCatalog can't find database (1997)
Members register & gain access system (1998)
Emailing html (1998)