yep, I only selecting a foreign key column
mmm... this seems to work
$result = $sqlQuery->execute()->column();
Yep so I think its because execute() return a Query which implements Iterator interface, so you can loop through it. Yep, so need to use SQLSelect for this particular use case
Im using it to get a list of ids and then trying to pass those IDs to a filter()... then I get this:
Mmmm.... it seems to be returning a query?
Anyone know if there is another way for turning the results of an SQLSelect into an array, other than looping through the results and pushing them to a new array?
Does SiteTree have to be namespaced @sutherlandesign? So like
Anyone know how I can retrieve a DataObject that's been archived? Would I have to compare records in the _live and _versions table?