WORepetition
WORepetition
- Subject: WORepetition
- From: "A. Uchida" <email@hidden>
- Date: Thu, 24 Apr 2003 18:25:17 +0100
Hi,
I am a newbie and have got a problem about WORepetition.
I tried to make a list of records from DB using nested WORepetition, but
the records in which to-many related table isn't retrieved.
I don't think WORepetition cannot be nested, but once I put the nested
WORepetition out from the outer WORepetition. The records are properly
shown in a table.
If I did something wrong, I would like advices. THe details are as
follows.
OS : MacOSX 10.1.5
WebObjects 5.0
Postgresql 7.2.1
Table1: Quotes
dataID >> Customer.dataID (To many relation)
products
quantity
createdDate
salesperson
....
Table2 : Customer
dataID > Quotes.dataID(To one relation)
firstname
lastname
...
WebObjects builder
WORepetition1 (List:Quotes.DisplayObjects, item:aQuotes) {
aQuotes.dataID
aQuotes.salesperson
WORepetition2 (list:Customer.DisplayObjects, item:aCustomer) {
aCustomer.firstname
aCustomer.lastname
aCustomer.address
}
aQuotes.CreatedDate
...
}
WORepetition2 setting was set Master/Detail key as...
Master Entity : Quotes
Detail key : arrayCustomer
Fetch on
Entity per batch : 10
When I tried to send SQL commands to the database, the database returns
the data properly including relational records.
--SELECT Quotes.dataID, Quotes.salesperson, Customer.firstname, ......
--WHERE Quotes.dataID = Customer.dataID
Thanks in advance for your help.
Atsushi Uchida
email@hidden
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.