We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Revo: xPDOQuery::select (help)

    • 28189
    • 47 Posts
    spikku Reply #1, 16 years, 10 months ago
    I’m not sure what I’m doing wrong, but I can’t seem to get this to work (line 2):

    http://pastebin.com/m275e3adf

    My goal is to reduce the amount of memory my object collection will require.

    Any help is greatly appreciated smiley

    Thanks!
      • 28215
      • 4,149 Posts
      splittingred Reply #2, 16 years, 10 months ago
      You need to at least select the PK of the object:

      $query = $this->modx->newQuery('modDocument');
$query->select('modDocument.id,modDocument.pagetitle');
$query->where(array(
    'modDocument.published' => 1,
    'modDocument.searchable' => 1,
));
$searchables = $this->modx->getCollection('modDocument', $query);
        shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
        • 28189
        • 47 Posts
        spikku Reply #3, 16 years, 10 months ago
        Ahh, thank you smiley