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