Keith,
Perhaps I am not understanding correctly, but it sounds like a query within
which you group the results is the way to go.
You can handle the grouping in a couple of different ways. I would start by
reading the help on the CFOUTPUT tag, looking at the group parameter.
HTH,
Matthieu
Hi.
You could keep to pretty much the same, but instead of doing a
database query inside the loop speed it up by doing a query of query.
Outside the loop you will need an extra query to get all the data for
the sub-query to use as the query you are going to query, but this
will increase the execut
2 matches
Mail list logo