[Problem] ModExt combo box [semi-solved] left join query problem [solved]

- 275 Posts
skndn60 Reply #11, 13 years, 2 months ago
You can debug your query with:
```
$modx->log(modX::LOG_LEVEL_ERROR, $c->toSql());
```
This will show the generated SQL statement in the MODx error log in the manager.

Take it from there to see whether your query runs as expected in PHPMYADMIN or equivalent.
MODx Revolution / MAMP / OS X

116 Posts

theboxer Reply #12, 13 years, 2 months ago

I fixed my sql problem with this code:

$c = $modx->newQuery('Indication'); 
$c->bindGraph('{"IndicationType":{}}');

$c->sortby($sort,$dir); 

$indications = $modx->getCollectionGraph('Indication', '{"IndicationType":{}}', $c);

Hope it is fast enought and don’t slow my web...

--
John
@theboxer