shishirca
Posts: 1
|
| Posted: 07/19/2007, 8:36 PM |
|
hi
i am using the following code to populate the listbox (html control on a php page) on "before show" event -
$NewPage1->ListBox1->DataSource = new clsDBConnection_Project();
$NewPage1->ListBox1->ds = & $NewPage1->ListBox1->DataSource;
$NewPage1->ListBox1->DataSource->SQL = "SELECT col1, col2 \n" .
"FROM table1 {SQL_Where} {SQL_OrderBy}";
$NewPage1->ListBox1->DataSource->wp = new clsSQLParameters();
$NewPage1->ListBox1->DataSource->wp->Criterion[1] = "id=". CCGetSession("ID");
$NewPage1->ListBox1->DataSource->Where =
$NewPage1->ListBox1->DataSource->wp->Criterion[1];
$NewPage1->ListBox1->Required = true;
this code does not give any error but the listbox does not populate.
any suggestion for the problem
reena
|
 |
 |
|