Hi,

I'm new to doctrine: I have a problem with the sorting of joined records.

A sample.

I've got an Article model which is associated with a Source model in 1 <-> n. The source model has a property called 'position' with an integer value.

Now I want to fetch an article with it's sources orderes by the position. My DQL looks like this:

$q = Doctrine_Query::create()
  ->select('a.title, s.content')
  ->from('Article a')
  ->leftJoin('a.Source s')
  ->where('a.id = ?')
  ->orderBy('s.position');

The result doesn't change if I edit the position.

Best regards, Sebastian