Hey guys,
I have a DataObject called "Job" here's what it looks like:
static $db = array(
'Title' => 'Varchar(24)',
'Description' => 'Text',
'HoursPerWeek' => 'Text',
'Location' => 'Varchar(24)',
'RequiredRoutewayCourse' => 'Text',
'HourlyWageOrSalary' => 'Currency',
'ExpiryDate' => 'Date',
);
In "JobCategory.php" which is a page that lists all of my jobs, I would like to retrieve a list of all unique "RequiredRoutewayCourse" entries from the Job table in the database.
What is the best way to do this?
Thanks!