Not Null Values

Yii 1.1 General Discussion
1

Hi folks

I am trying to get a result from the database using yii framework.

I have written a query which is working fine. But the requirement is I should get only not null values.

Like select * from emp where managerid != ‘’ .

so I want to apply the not null condition in sql query.If any body has already done on this, please reply me.

and my query is $get_words = Yii::app()->db->createCommand()

			->select('*')


			->from('vocab')


			->where('sourcelanguage=:sourcelanguage', array(':sourcelanguage'=>$srcId))


			->Where(array('IN','word_meaning_id',$word_stack))


			->queryAll();

and i want to add not null constraint as well to this query.

Regards

Shaik

2

[list=1]

[*] Try to use one ->where() only

[*] part of the condiction should be ‘AND managerId IS NOT NULL’

[/list]

3

hey sourceror

Thanks for the reply and i have applied that IS NOT NULL but its giving error.

Can you please tell how to apply that in where clause i.e in the yii standard.

Regards

Shaik

4

Erm … which field should not be null precisely? I just realized now that there probably is no field called managerId.