am almost there,and yet so far, am having trouble, as firebug told me so

here’s what the response contains
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>
CDbException</title>
<style type="text/css">
/*<![CDATA[*/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-size:9pt;}
pre {font-family:"Lucida Console";font-size:10pt;}
.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
.message {color: maroon;}
.source {font-family:"Lucida Console";font-weight:normal;background-color:#ffffee;}
.error {background-color: #ffeeee;}
/*]]>*/
</style>
</head>
<body>
<h1>CDbException</h1>
<h3>Description</h3>
<p class="message">
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'parent_id' in 'where clause'</p>
<h3>Source File</h3>
<p>
C:\xampp\htdocs\yii\yii\framework\db\CDbCommand.php(387)</p>
<div class="source">
<pre>
00375:
00376: if($this->_connection->enableProfiling)
00377: Yii::endProfile('system.db.CDbCommand.query('.$this->getText().')','system.db.CDbCommand.query');
00378:
00379: return $result;
00380: }
00381: catch(Exception $e)
00382: {
00383: if($this->_connection->enableProfiling)
00384: Yii::endProfile('system.db.CDbCommand.query('.$this->getText().')','system.db.CDbCommand.query');
00385: Yii::log('Error in querying SQL: '.$this->getText().$par,CLogger::LEVEL_ERROR,'system.db.CDbCommand');
00386: $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
<div class="error">00387: throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</div>00388: array('{error}'=>$e->getMessage())),(int)$e->getCode(),$errorInfo);
00389: }
00390: }
00391: }
</pre>
</div><!-- end of source -->
<h3>Stack Trace</h3>
<div class="callstack">
<pre>
#0 C:\xampp\htdocs\yii\yii\framework\db\CDbCommand.php(272): CDbCommand->queryInternal('fetchAll', 2, Array)
#1 C:\xampp\htdocs\yii\yii\framework\db\ar\CActiveRecord.php(1231): CDbCommand->queryAll()
#2 C:\xampp\htdocs\yii\yii\framework\db\ar\CActiveRecord.php(1317): CActiveRecord->query(Object(CDbCriteria), true)
#3 C:\xampp\htdocs\yii\app\protected\controllers\WsmembersdetailsController.php(88): CActiveRecord->findAll('parent_id=:pare...', Array)
#4 C:\xampp\htdocs\yii\yii\framework\web\actions\CInlineAction.php(50): WsmembersdetailsController->actionDynamiccities()
#5 C:\xampp\htdocs\yii\yii\framework\web\CController.php(300): CInlineAction->run()
#6 C:\xampp\htdocs\yii\yii\framework\web\CController.php(278): CController->runAction(Object(CInlineAction))
#7 C:\xampp\htdocs\yii\yii\framework\web\CController.php(257): CController->runActionWithFilters(Object(CInlineAction), Array)
#8 C:\xampp\htdocs\yii\yii\framework\web\CWebApplication.php(324): CController->run('dynamiccities')
#9 C:\xampp\htdocs\yii\yii\framework\web\CWebApplication.php(121): CWebApplication->runController('wsmembersdetail...')
#10 C:\xampp\htdocs\yii\yii\framework\base\CApplication.php(135): CWebApplication->processRequest()
#11 C:\xampp\htdocs\yii\app\index.php(13): CApplication->run()
#12 {main}</pre>
</div><!-- end of callstack -->
<div class="version">
2010-11-27 01:35:10 Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.4</div>
</body>
</html>
my controller (based from the yii wiki dependent dropdown
public function actionDynamiccities()
{
$data = Worldareasstates::model()->findAll('parent_id=:parent_id',
array(':parent_id'=>(int) $_POST['country_id']));
$data = CHtml::listData($data,'StateID','StateName');
foreach($data as $value)
{
echo CHtml::tag('option',
array('value' => $value->StateID),CHtml::encode($value->StateName),true);
}
}
_form view
<?php echo CHtml::beginForm(); ?>
<div class="row">
<?php echo CHtml::dropDownList('country_id','$select', array(1=>'USA', 2=>'France', 3=>'Japan'),
array(
'ajax' => array(
'type' => 'POST',
'url' => CController::createUrl('wsmembersdetails/dynamiccities'),
'update' => '#StateID',
)
)
);
?>
</div>
<div class ="row">
<?php echo CHtml::dropDownList('StateName','',array()); ?>
</div>
<?php echo CHtml::endForm(); ?>
what could possibly be wrong ? ( i don’t get it )