Re: [fw-db] Re: aggregete joins failing, looking for a workaround

You need to wrap your subquery in a Zend_Db_Expr object:

->join(array('licenses' => new Zend_Db_Expr('( [subquery] )'));

--
Hector

On Fri, Apr 16, 2010 at 2:19 PM, MikeD <dambrogia@gmail.com> wrote:

decided to bypass the use of select() and just pass the straight query to a
zend_db object:

$sql = "select * from table";

$config = new Zend_Config_Ini( APPLICATION_PATH . DIRECTORY_SEPARATOR .
'configs' . DIRECTORY_SEPARATOR . 'application.ini',
getenv('APPLICATION_ENV'));
$db = Zend_Db::factory($config->resources->db->adapter,
$config->resources->db->params);
$db->getConnection();
return $db->fetchAll($sql);

returns an array of rows.  not perfect but works
--
View this message in context: http://n4.nabble.com/aggregete-joins-failing-looking-for-a-workaround-tp2013446p2013595.html

Sent from the Zend DB mailing list archive at Nabble.com.