4 November 2008 at 12:29pm
(Last edited: 4 November 2008 12:30pm),
I want to select values from two tables.
I was trying to use the DataObject::get syntax.
DataObject::get("ccProjects", "ccProjects.memberID = $memberID",''," left join ccImages on ccProjects.ID = ccImages.ProjectId"))
The page runs but I'm not sure why I can't get all values to output in template. The only value that outputs is the Name field from the ccProjects table. The ccImages table has a column named Name too. How do I output that field in the template?
This is all going on in a method of the ccProjects class and is referenced in the template by:
In that case, you might wanna use SQLQuery (http://doc.silverstripe.com/doku.php?id=sqlquery) instead because with DataObject you can only retrieve records from one model even thought you can join it with other tables.