| Re: How to make a list2 on a non existing child table [message #1906 is a reply to message #1905] |
Tue, 09 December 2008 07:45   |
AJM
Messages: 2361
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
Anything is possible, but you need to know how Radicore works in order to know when it will do what you want as standard, or will need some custom code somewhere.
The description of a LIST2 pattern clearly states that after retrieving a single row from the OUTER table it will retrieve all associated rows from the INNER table. It does this by extracting the primary key of the OUTER row and passing it to the INNER table in the $where string. This assumes that the primary key of OUTER is also used as a foreign key on INNER. It will use this string in the getData() method to populate its data array, and the contents of this data array will be loaded into the screen.
If there are too may records being displayed then you need to adjust the $where string accordingly, or manually adjust the contents of the data array.
It is also possible to skip the getData() altogether and populate the data array manually.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
