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:
cybercash on OSX - was Executing remote AppleScript (2000)
syntax question, not in online refernce (1997)
spaces in [texta] (1998)
Restart of DBserver (1997)
Credit Card Checking?? (1998)
[WebDNA] Help with iTools 9/WebDNA setup MacTel (2009)
back button loses cart (2000)
Bookmarked URL with cart (1998)
Protect (1997)
[regexp] will be renamed to [grep] in next release (2000)
two questions (1997)
Progress !! WAS: Trouble with formula.db (1997)
Help with Repost Data msg from form (1997)
Archives... (1997)
Secure Web Server (1999)
RAM variables (1997)
More on the email templates (1997)
checksum for credit cards? (1997)
WebCatalog for guestbook ? (1997)
Possible to reset Linux file permissions w/in webcat [shell] ? (2000)