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 couldimmediately check the contents of a prevoius record ([index]-x). If I want todo 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 descriptionford blue truckford red carford orange vanchevy grey vanchevy tan carchevy white pickupIt's easy to replace the brand name with a logo. But one of the most commonrequests I get is to eliminate redundant display of manufacturer or brand, andthat'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 justtrying to use a form variable (lastbrand) to cache the [brand] of the prevoiusrecord. Needless to say, I'm going buggy with this approach. A hostage crisismay 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 couldimmediately check the contents of a prevoius record ([index]-x). If I want todo 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 descriptionford blue truckford red carford orange vanchevy grey vanchevy tan carchevy white pickupIt's easy to replace the brand name with a logo. But one of the most commonrequests I get is to eliminate redundant display of manufacturer or brand, andthat'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 justtrying to use a form variable (lastbrand) to cache the [brand] of the prevoiusrecord. Needless to say, I'm going buggy with this approach. A hostage crisismay 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)