Can I do this?
Posted by:
Kunal Shah
Date: October 29, 2004 01:15AM
I need some help here...
MySQL/Tomcat 5/JDBC
table Events contains information about various events including a column called 'OrgIDs' which is a comma separated list of the IDs of the organizations which are sponsoring an event in Events and a column 'FullName' with the full name of the organization (the sponsor)
table Organizations contacts information about the organizations including ID
I would like to display all the Events and the information about the event including the FullName(s) of the Orgs
TABLE Events ( ID, FullName)
TABLE Organizations (EventID, EventTitle, OrgIDs, EventDescription)
the output:
Event 1: The Really Big Cool Event!
Sponsor IDs: 1,2
Sponsor Names: The Cool Organization, The Big Organization
Description: Blah blah blah blah
............
So I guess my question is how can I associate a list of IDs (which I can turn into a array datatype if neccessary) with the names?
Subject
Written By
Posted
Can I do this?
October 29, 2004 01:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.