waygee
|
| Posted: 10/09/2002, 11:27 AM |
|
I have an application where the result set returned from a search could be
potentially hundreds of records. I want to make it more user friendly by
grouping the results in either a tree or some other mechanism. Does anyone
have any ideas or suggestions on how to do this? I have started to look
into 3rd party active x Grid or Tree controls but this is another set of
problems.
Thanks,
WayGee
|
|
|
 |
Dave Rexel
|
| Posted: 10/09/2002, 5:35 PM |
|
Assume -the page chokes with the sheer mass of query results
#first run some raw SQL to see where the DB bends
-Then check application to see where the display hangs
(using CCS paging I've yet to choke it bad)
But its quite simple in any script run outside CCS as well
Here's the logic for a very basic example for both
# try to throttle the search query result by
1-in default SQL only showing expanded records from the category with most
results in initial grid
2-in result-set array do a search within the rest of the results for
category names and
3-draw these category names as links to same page but with the category
result as parameter
4-subsequent SQL now showing expanded records from the chosen category but
the same search input
#the search is now shown grouped
"waygee" <waygee@pobox.com> wrote in message
news:ao1sdv$kpe$1@news.codecharge.com...
> I have an application where the result set returned from a search could be
> potentially hundreds of records. I want to make it more user friendly by
> grouping the results in either a tree or some other mechanism. Does
anyone
> have any ideas or suggestions on how to do this? I have started to look
> into 3rd party active x Grid or Tree controls but this is another set of
> problems.
>
> Thanks,
> WayGee
>
>
|
|
|
|
|
