Ok, thanks for the explanation ! Regards, Mikael
On 27 oct, 20:24, Pierre-Yves LEBECQ <[email protected]> wrote: > I think the response is simply "No". > > DQL does not rely on the structure of the database but only on the generated > model files before actually querying the database. You have to define > relationships in order to have a correctly generated model and then Doctrine > will be able to parse you DQL query to make it an SQL query. > > -- > Pierre-Yves > > 2010/10/27 Mikael <[email protected]> > > > > > Hello, > > > We're working on a small website aimed at showings stats extracted > > from limesurvey (php tool to manage surveys). > > > We've decided to import the schema in order to generate the model > > classes and work with Doctrine to build our queries, but > > infortunately, the relations haven't been imported. > > > And this query fails : > > > $q = Doctrine_Query::create() > > ->select('lls.surveyls_title') > > ->from('LimeSurveysLanguagesettings lls') > > ->innerJoin('LimeSurveys ls ON lls.surveyls_survey_id = ls.sid' ); > > > with the following error : > > 500 | Internal Server Error | Doctrine_Table_Exception > > Unknown relation alias > > > So a question : is it at all possible to use DQL with joins when the > > schema does not specify relations ? > > > Regards, > > > Mikael > > > -- > > If you want to report a vulnerability issue on symfony, please send it to > > security at symfony-project.com > > > 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]<symfony-users%2bunsubscr...@goog > > legroups.com> > > For more options, visit this group at > >http://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com 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
