Hi, Maybe you should tell us what the error returned by symfony actually is.
On 28 avr, 12:22, 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 -~----------~----~----~----~------~----~------~--~---
