Posted by Pedro Graca on 09/30/26 11:37

Rich wrote:
>
> "Pedro Graca" <hexkid@dodgeit.com> wrote in message
> news:slrndsgfi4.gck.hexkid@ID-203069.user.individual.net...
>
> <snip>
>
>> If your table has 1000 names you'd do 1001 queries (one for the
>> DISTINCT names and 1000 for the classes)
>
> You're right. If there were 1000 names you should loop through the results
> of 1 query. But there were only 5.

Usually people post a stripped-down example of their problem.
Just because the example posted by the OP contained 5 rows, that's no
reason to assume the real problem happens only with a small amount of
data.

>> Yes, it gets the desired results, but at a *very large* cost!
>>
>> <snip>
>
> I took a few minutes out of my busy day to give the OP some *ideas* on how
> to handle his problem, not do it for him. I never stated that it was
> production-quality code. It was a hack to deal with an improperly formatted
> table of data.
>
> It took all of 5-10 minutes to cut and paste, was very ugly, and there were
> a lot of things wrong with the code but it worked and it showed the results
> that *could* be accomplished.
>
> Feel free to optimize, test, debug, and repost, as you (apparently) have
> more free time on your hands than I.
>
> Thanks for the critique,

Don't take my criticism personally, I never intended it that way.
I can't speak for anyone else on these groups, but I'm sure all of us
appreciate your posts.


--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!

[Back to original message]