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 -~----------~----~----~----~------~----~------~--~---
