hi everybody, i have got the following design problem: i have 2 database entities a) for example 'CD' like u2, mozart) b) lets say: 'categories of CDs' like Hardrock, Hiphop, classic) the CDs are organized in categories (every entry in the CD-table has got a foreign key wich points to its category), to put it in other words, the two tables are 1:n related (a:b = 1:n) What i want to do is to write a jsp page which lists all categories (if not empty) and shows the CDs inside the categories: i have done this stuff hundred of times, but i feel i do it not in the most elegant way - so I would really like to know how you are dealing with this, what do you think is the best design guideline for these kind of things? thanks, joachim peer =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
