Hi guys,
although i read the tutorials i guess i missed something.
I'm trying to show data from a database table on a page.
I've defined a Holder "ListingHolder" and a Page "ListingPage".
The ListingPage defines a table via static $db, nothing complex, just some fields.
The ListingPage controller has a method named ShowAllEntries.
In there i call DataObject::get('ListingPage') and expect to get all entries from the table ListingPage_Live.
Sadly, I only get the first row.
I've digged a bit deeper and found the reason for this:
The SQL Query generated fetches only Pages that have an entry in SiteTree_Live.
To summarize what I want to achieve:
When the Page "ListingPage" is called in the Browser, Silverstripe should generate a List of all entries in a table (atm ListingPage_Live), regardless if they belong to a page.
Why? I want to fill the table from an external data source, so I don't need a page per entry plus the amount of data is huge, so it would probably slow down the admin interface a lot.
Could you please give me a hint how to dump out the table data?
Thanks in advance, goosejan :)