2009年2月28日星期六

Re: [fw-db] Column ambiguously defined


Trust me I tried everything with Zend  and nothing works.
Actually, it's a bug with Oracle database : http://framework.zend.com/issues/browse/ZF-3168

I have to deliver my web application for Monday... Bad weekend expected!

--
Thomas VEQUAUD          http://thomas.vequaud.free.fr/
Expert EPITECH en Ingénierie Informatique
Tél : +33(0)6.50.39.28.10  Fax: +33(0)9.58.46.10.07


On Fri, Feb 27, 2009 at 11:40 PM, PHPScriptor <contact@phpscriptor.com> wrote:

Oh yeah, I see it, didn't look good enough... anyway. You should rename one
of the id's.

e.g. the one from INDIVIDUS: IND_ID AS BLABLA. But better I think, you
should only let the select, select one of the two id's.

e.g.
$select->joinInner(array("AFF" => "EAI_TA_AFFECTATIONS"),
    'INDIVIDUS.IND_ID = AFF.IND_ID',array('field1','field2','field3));
so the 3the parameter is the fields you want to select from this table.
Select them all but not IND_ID.

http://www.phpscriptor.com/tutorial/zend/zend.db.select.html#zend.db.select.building.join
http://www.phpscriptor.com/tutorial/zend/zend.db.select.html#zend.db.select.building.join


Thomas VEQUAUD wrote:
>
> Yep I have an IND_ID in each tables... That's why I don't understand this
> issue...
> If you've got another idea... Just show me the right way! ;)
>

没有评论: