hi, i dunno what’s going on, but i think my sql statement’s quotes and commas are in correct places, but when i run this code
$query = "INSERT INTO MYTABLE (ADID,COMPLAINID,STATUS,CREATEDDATE,CREATEDBY,UPDATEDDATE,UPDATEDBY) VALUES('".$adid."','10','7',CURRENT_DATE,'1',CURRRENT_DATE,'1')"; Yii::app()->db->createCommand($query)->execute();
am getting a "COLUMN NOT ALLOWED HERE" error from oracle, any idea why?
what’s the Yii way to get rid of this error and let me pass through this ?
NOTE: there’s an autoincrement field that I left,because in mysql, if there’s a PK that has an auto-increment, we can ommit it from the insert statement…i don’t know in oracle