SQL bermasalah

International Indonesian
1

Saya ingin menampilkan view tertentu ketika fungsi actionIndex() dijalankan… namun saya mengalami kesulitan

karena hasilnya adalah muncul pesan error :




CDbCommand failed to execute the SQL statement: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "memo" does not exist

LINE 1: SELECT * FROM memo LIMIT 10

^. The SQL statement executed was: SELECT * FROM memo LIMIT 10

codingan saya adalah :




public function actionIndex()

	{

$sql="SELECT namaMemo, NIP FROM MEMO WHERE status=0";

	$dataProvider=new CSqlDataProvider($sql,array(

			'keyField' => 'kodeMemo',

		));

		$this->render('index',array(

			'dataProvider'=>$dataProvider,

		));

}

terima kasih

2

I guess this should be moved to Indonesian forum

3

Thanks for your caution, Mr. Petra.

i really did not know bout my understanding till i’ve read your comment…

i’ll change it soon.

4

NOTE: moved to Indonesian forum