Re: sorting and summarizing

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 18994
interpreted = N
texte = Yes, the summary feature will use the date value for the first record of each unique library. Unfortunately, the summarizing is done as the same time as the search so you can't sort the results before the summary takes place within a single search. Here's a way of doing it (it hasn't been tested, so you may have to play with it a bit) that will work by building a separate database periodically, and then building the list from that:file=lib_list.inc[showif ][include file=build_lib_list.inc][/showif][search db=lib_list.db&neLIBdatarq=find_all&deMODsort=1][founditems][/founditems][/search]file=build_lib_list.inc[closedatabase lib_list.db][search db=lib_list.db&neLIBdatarq=find_all][search ...eqLIBRARYdatarq=[LIB]&deTRUEDATEsort=1&max=1][founditems][replace db=lib_list.db&eqLIBRARYdatarq=[LIB]]mod=[TRUEDATE][/replace][/founditemes][/search][/search]>I have a field (Library) that I summarize to display a table of thumbnails>of the libraries. I add files to some of the libraries periodically, and I>want to sort by descending date, so the libraries with the most recent>additions float to the top.>>Using ...&detruedatesort=1&librarysumm=t sorts almost correctly, except>that it uses the date value of the first alphabetical library record, so if>I add new entries, unless the first alphabetical entry is one of the new>ones, that library won't float to the top.>>Using ... &dlibrarysort=1&detruedatesort=2&librarysumm=t just sorts them>alphabetically.>>Using ... &detruedatesort=1&dlibrarysort=2&librarysumm=t sorts them like>the first example.>>Am I overlooking something here?>>Thanks,>>Terry Wilson>>Terry Wilson>terryw@rainbowcreek.com John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

Re: sorting and summarizing (Terry Wilson 1998)
Re: sorting and summarizing (John Hill 1998)
re: sorting and summarizing (Terry Wilson 1998)
sorting and summarizing (Terry Wilson 1998)

Yes, the summary feature will use the date value for the first record of each unique library. Unfortunately, the summarizing is done as the same time as the search so you can't sort the results before the summary takes place within a single search. Here's a way of doing it (it hasn't been tested, so you may have to play with it a bit) that will work by building a separate database periodically, and then building the list from that:file=lib_list.inc[showif ][include file=build_lib_list.inc][/showif][search db=lib_list.db&neLIBdatarq=find_all&deMODsort=1][founditems][/founditems][/search]file=build_lib_list.inc[closedatabase lib_list.db][search db=lib_list.db&neLIBdatarq=find_all][search ...eqLIBRARYdatarq=[LIB]&deTRUEDATEsort=1&max=1][founditems][replace db=lib_list.db&eqLIBRARYdatarq=[LIB]]mod=[TRUEDATE][/replace][/founditemes][/search][/search]>I have a field (Library) that I summarize to display a table of thumbnails>of the libraries. I add files to some of the libraries periodically, and I>want to sort by descending date, so the libraries with the most recent>additions float to the top.>>Using ...&detruedatesort=1&librarysumm=t sorts almost correctly, except>that it uses the date value of the first alphabetical library record, so if>I add new entries, unless the first alphabetical entry is one of the new>ones, that library won't float to the top.>>Using ... &dlibrarysort=1&detruedatesort=2&librarysumm=t just sorts them>alphabetically.>>Using ... &detruedatesort=1&dlibrarysort=2&librarysumm=t sorts them like>the first example.>>Am I overlooking something here?>>Thanks,>>Terry Wilson>>Terry Wilson>terryw@rainbowcreek.com John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com John Hill

DOWNLOAD WEBDNA NOW!

Re: sorting and summarizing

1998

Top Articles:

Related Readings: