Sorry man, I can not see anything wrong if the query is runing fine in mysql db. But if you really can not figure out the error, you may not have to use join, just retrieve all the CatReq objects, and then use getDes() and getEmp() on each object. Good luck
On Tue, Apr 28, 2009 at 6:22 AM, Pooja <[email protected]> wrote: > > Hi Frank > This SQL query is going fine in MYSQL this is giving me results but in > symfony i m having problem.......plz help > Regards Pooja > > On Apr 27, 5:54 pm, Frank He <[email protected]> wrote: > > I sugest you first use $c->toString() to print out the query and see > where > > is the error. > > > > On Mon, Apr 27, 2009 at 8:11 AM, Pooja <[email protected]> wrote: > > > > > Hi All i have tired to convert below Sql query in symfony........It is > > > reporting Error > > > Sql Query is...... > > > select d.dest_name,e.emp_name,c.date from destination_table d, > > > emp_table e, cab_req_table c where e.emp_id=c.emp_id AND > > > c.dest_id=d.id; > > > > > In SYmfony: > > > $c=new criteria(); > > > $c->addJoin(CabReqTablePeer::DEST_ID,DestinationTablePeer::ID); > > > $c->addJoin(CabReqTablePeer::EMP_ID,EmpTablePeer::EMP_ID); > > > $c->addSelectColumn(EmpTablePeer::EMP_NAME); > > > $c->addSelectColumn(DestinationTablePeer::DEST_NAME); > > > $c->addSelectColumn(CabReqTablePeer::DATE); > > > $rs=CabReqTablePeer::doSelect($c); > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
