well this seems to be returning something now.
$criteria->bindGraph('{"MarketZone":{}}');
$zones = $this->modx->getCollectionGraph('Countries','{"MarketZone":{}}',$criteria);
and the query is looking like this:
SELECT `Countries`.`id` AS `Countries_id`, `Countries`.`Country` AS `Countries_Country`, `Countries`.`abbreviation` AS `Countries_abbreviation`, `Countries`.`zone` AS `Countries_zone`, `MarketZone`.`id` AS `MarketZone_id`, `MarketZone`.`zone` AS `MarketZone_zone`, `MarketZone`.`abbreviation` AS `MarketZone_abbreviation` FROM `modx_countries` AS `Countries` LEFT JOIN `modx_market_zone` `MarketZone` ON `Countries`.`zone` = `MarketZone`.`id` WHERE `Countries`.`abbreviation` = 'CA' ORDER BY `Countries`.`id` ASC
It's not returning an object yet - but I'll have to tinker with it tomorrow.
Still driving me nuts that we have to manually specify the join/binding. [arrgh!!]
*** Not just websites, we also create signage, banners, print, trade show displays and more! ***
Sean Kimball CLP, CLS.
Technical Director / Sr. Developer | BigBlock Studios
._______________________________________________.
Bigblock Studios
http://www.bigblockstudios.ca Web site design & development.
27-1300 King Street East. Box 167 Oshawa, Ontario L1H8J4 Canada.
phone/fax: 905-426-5525