Hi all... I have a question about what type of container I should use for a project I'm working on.. Basically, I am grabbing data from a database for use on a webpage. There is a varying list of application names, and each application could have multiple versions. If I did a SELECT DISTINCT on the table I would get output similar to the following...
App Name Version
-------- -------
App1 1
App1 2
App2 1
App3 5
App3 4
I want to have this data in one container. Basically I want to be able to print out all of the distinct app names as well as the distinct version numbers. I need an easy way to iterate though this list. Basically, I want to look up App1, and print 1,2. Look up App2, and print 1. Any ideas on how this can be done? Any help would be greatly appreciated. Thanks.
Doug
App Name Version
-------- -------
App1 1
App1 2
App2 1
App3 5
App3 4
I want to have this data in one container. Basically I want to be able to print out all of the distinct app names as well as the distinct version numbers. I need an easy way to iterate though this list. Basically, I want to look up App1, and print 1,2. Look up App2, and print 1. Any ideas on how this can be done? Any help would be greatly appreciated. Thanks.
Doug