Hi Bill,
Thank you for your reply.
I'm sorry complete newbie here so I forgot to mention that I'm using
Doctrine version 1.2.3 I've tried your suggested method as shown below but
it does not return any records.
public function groomappointserviceAction()
{
$this->_helper->layout->disableLayout();
$this->getHelper('viewRenderer')->setNoRender(true);
// get a list of all grooming services IDs and related procedures
$gqry= Doctrine_Query::create()
->select('g.groomServicesID AS iden , p.groomprocedure AS name')
->from('PetManager_Model_Groomservices g')
->leftJoin('g.PetManager_Model_Groomprocedures p');
$result = $gqry->fetchAll();
//generate and return JSON string
$data = new Zend_Dojo_Data('iden',$result);
echo $data->toJson();
}
I receive the following errors in Firebug
Error: Unable to load /groomappointments/appointment/groomappointservice
status:500
(1234 out of range 505)
bootstrap.js (line 1234)
dijit.form.FilteringSelect: Error: Unable to load
/groomappointments/appointment/groomappointservice status:500
(646 out of range 104)
On digging down on the 646 I get an error response text of "".
I've used the fetchArray method in all my other queries for my Dojo
FilteringSelects without this issue arising, is the issue arising because of
the joined tables??
many thanks for your reply,
I.S.
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/Help-needed-creating-filteringselect-from-joined-tables-tp3470508p3527237.html
Sent from the Zend Framework mailing list archive at Nabble.com.
--
List: [email protected]
Info: http://framework.zend.com/archives
Unsubscribe: [email protected]
