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%[email protected]> > 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
