Typically, your query of the Contact table would look like this:
Criteria criteria = new Criteria();
criteria.add...... //add your criteria here
List results = ContactPeer.doSelect(criteria); //get the list of
results
Contact contact = (Contact)results.get(0); //get the first result
List phoneNumbers = contact.getPhoneNumbers(); //get the list of
phone numbers associated with this contact
The "contact.getPhoneNumbers()" method will be automatically generated with
your OM if your phone number table has a foreign key reference to the
contact table.
It's slick stuff.
Adam
"Kintzel Levente"
<[EMAIL PROTECTED] To:
[email protected]
ech.ro> cc:
Subject: Arrays in OM
classes
02/22/05 07:29 AM
Please respond to
"Apache Torque Users
List"
Hi!
I have a simple design question.
I want to creat a database with contact information (id, name, adress,
phone no), but the contact can have more than one phonenumber. The
simplest solution for this problem is the normalization and to create 2
tables (one with id, name and adress and one with the id and phone
numbers), but I want to be able to load automatically all phone numbers
when I load the data of one contact. In other words to have an array in
the generated ContactOM class. Is that possible? Or there are some design
solutions for this problem?
Thank You
Levente Kintzel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
