activeTextField/activeDropDownList

Yii 1.1 General Discussion
1

I have a question.

Why if I use the textfield i don’t have mistake to salve the data in the db, but if I use the activeDropDownList

i have error in the db?

For example




<div class="row" align="left">

		<?php echo CHtml::activeLabelEx($model,'CONVENZIONE'); ?>

		<br />

		<?php //echo CHtml::activeDropDownList($model,'CONVENZIONE',array(1=>'',2=>'SI',3=>'NO'));?>

		<?php echo CHtml::activeTextField($model,'CONVENZIONE'); ?>

		<?php echo CHtml::error($model,'CONVENZIONE'); ?>

	</div>





 <?php echo CHtml::activeTextField($model,'CONVENZIONE'); ?>

…i don’t have error


 <?php //echo CHtml::activeDropDownList($model,'CONVENZIONE',array(1=>'',2=>'SI',3=>'NO'));?>

…i have problem…

can you help me???

2

What is the error you are getting?

3

the error is

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2290 OCIStmtExecute: ORA-02290: check constraint (ORA02.AVCON_1047570130_CONVE_000) violated

(ext\pdo_oci\oci_statement.c:146)INSERT INTO organizzazione (RAGIONE_SOCIALE, CODICE_FISCALE, PARTITA_IVA, INDIRIZZO_LEGALE, CAP, COMUNE_COMUNE_ID, INDIRIZZO_OPERATIVO, CAP_OPER, TELEFONO_1, TELEFONO_2, TELEFONO_3, FAX, E_MAIL, URL, TIPOLOGIA_ENTE, DIPENDENTI, CONVENZIONE, NOTE, ORGANIZZ_ID) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18) RETURNING ORGANIZZ_ID INTO :RETURN_ID

ORA02.AVCON_1047570130_CONVE_000 is the name of the constraint in the db