[Solved]PROBLEM IN USING WHERE CLAUSE

Yii 1.1 General Discussion
1

I AM TRYING TO USE A WHERE CLAUSE IN THE CODING SO THAT I CAN USE THAT TO POPULATE THE DROP-DOWN BOX


<div class="row">

		<?php echo $form->labelEx($model,'EMP_FIRM_ID'); ?>

		<?php echo $form->dropdownlist($model,'EMP_FIRM_ID',CHtml::listData(PmValueSet::model()->findAll('VS_TYPE=FIRMSIZE'), 'VS_ID', 'VS_VALUE','VS_TYPE')); ?>


		<?php echo $form->error($model,'EMP_FIRM_ID'); ?>

	</div>

CAN SOMEONE POINT OUT THE MISTAKE I HAVE DONE

2

sorry guys… i solved it


<?php echo $form->dropdownlist($model,'EMP_FIRM_ID',CHtml::listData(PmValueSet::model()->findAll('VS_TYPE="FIRMSIZE"'), 'VS_ID', 'VS_VALUE','VS_TYPE')); ?>
3

I think


CHtml::listData(PmValueSet::model()->findAll('VS_TYPE=FIRMSIZE'), 'VS_ID', 'VS_VALUE','VS_TYPE')

code should be that:




    CHtml::listData(PmValueSet::model()->findAll('VS_TYPE=:VS_TYPE',array("VS_TYPE"=>"FIRMSIZE")), 'VS_ID', 'VS_VALUE')

html select can handle two thing: value and text:


<option value="1">First</option>

so in your example it is gonna be


<option value="VS_ID">VS_VALUE</option>

that is why I removed VS_TYPE.

4

thank you … this is working for me





CHtml::listData(ModelName::model()->findAll('FieldName="search name"'), 'FieldName', 'FieldName')