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:
DON'T use old cart file! (1997)
Copy, Move, Create Folders (1998)
emailer on Windows Beta 18 (1997)
Payments -> Bank Accounts (2005)
[WebDNA] Dynamic vertical columns (2008)
Updating shipcost (2005)
Email Problem (2006)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
File Uploads: WebCat/SiteEdit (1998)
Not really WebCat- (1997)
What am I doing wrong? (2000)
displaying 12 results 4 by 3 (2000)
Error, 101 a DNS problem ? (1997)
Secure Sever and showcart errors (1997)
b12 cannot limit records returned and more. (1997)
[WebDNA] Froala Editor working with WebDNA (2016)
Re: (1998)
Re:quit command on NT (1997)
Snake Bites (1997)
SiteGuard Use Question (1997)