relation with condition

relation with condition Rate Topic:

#1 as_lh

Newbie

Group: Members
Posts: 17
Joined: 05-January 10

Posted 12 February 2010 - 09:20 AM

Hi,

i have those two tables that both have the attribute `languagecode` and also both have the attribute `description_id`.
Now i want to get the related entries using the relations attribute of one of their models.

so in "relations()" in model1 i added:

	
'descriptionType'	=> array(
	self::HAS_MANY, 
	'hotel_description_types', 
	'descriptiontype_id',
	'condition'=>'hotel_description_types.languagecode=:lang',
	'params' => array(':lang'=>'de'),
), ...

Now yii tells me:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hotel_description_types.languagecode' in 'where clause'

... though it DOES exist in the Database! I tripple checked!

What could be the problem?

#2 Mike

Elite Member

Group: Members
Posts: 2,992
Joined: 06-October 08
Location:Upper Palatinate

Posted 12 February 2010 - 09:55 AM

Use this condition instead, the table will get an alias that is the same as the relation name:

'condition'=>'descriptionType.languagecode=:lang',

#3 tri

Elite Member

Group: Moderators
Posts: 1,628
Joined: 20-November 08
Location:Stockholm, Sweden

Posted 12 February 2010 - 09:57 AM

as_lh, on 12 February 2010 - 09:20 AM, said:

	
'descriptionType'	=> array(
	self::HAS_MANY, 
	'hotel_description_types', 
	'descriptiontype_id',
	'condition'=>'hotel_description_types.languagecode=:lang',
	'params' => array(':lang'=>'de'),
), ...

Now yii tells me:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hotel_description_types.languagecode' in 'where clause'

... though it DOES exist in the Database! I tripple checked!

What could be the problem?

Try

	
'descriptionType'	=> array(
	self::HAS_MANY, 
	'hotel_description_types', 
	'descriptiontype_id',
	'condition'=>'descriptionType.languagecode=:lang',
	'params' => array(':lang'=>'de'),
), ...

(not tested)
/Tommy

Don't forget to read The Definitive Guide to Yii (en) (sv) | The class reference has the details

#4 as_lh

Newbie

Group: Members
Posts: 17
Joined: 05-January 10

Posted 12 February 2010 - 10:15 AM

tri, on 12 February 2010 - 09:57 AM, said:

Try

	
'descriptionType'	=> array(
	self::HAS_MANY, 
	'hotel_description_types', 
	'descriptiontype_id',
	'condition'=>'descriptionType.languagecode=:lang',
	'params' => array(':lang'=>'de'),
), ...

Didn't work either

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'descriptionType.languagecode' in 'where clause'