DQL Query fails
I've got 2 tables in an MySQL DB, im using doctrine 1.2 and symfony 1.4.4
Installedbase and Spare
Installedbase:
ib_id
app_id
location
and
Spare:
spare_id
app_id
amount
Now i want to join the to tables to show how many of the app are in the spare.
eg
$q = self::createQuery("l")
->select('i.*, s.*')
->from('InstalledBase i, Spare s')
->execute();
return $q;
Doctrine knows there is a relation between the tables on the app_id field but i get the error
500 | Internal Server Error | Doctrine_Hydrator_Exception
"Spare" with an alias of "s" in your query does not reference the parent component it is related to.
yaml: http://pastey.net/137237 I cant figure this one out, does anybody know what doctrine is complaining about?
->from('InstalledBase i, i.Spare s')
... "Spare" with an alias of "s" in your query does not reference the parent component it is related to.
Do add some further criteria to this query not to return everything from both tables.
从外观上看,你并没有告诉学说这两张表是相关的。
链接地址: http://www.djcxy.com/p/46118.html上一篇: HTML中的内联水平间距
下一篇: DQL查询失败