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
2 matches
Mail list logo