oasisp
Posts: 48
|
| Posted: 09/28/2010, 4:49 PM |
|
i trying to do similar Many-to-Many Relations via CheckBox List with text value
http://examples.codecharge.com/ExamplePack/ManyToManyCh...anyCheckbox.php
insted of using project_id i am using project_name for Bound Column and description for Text Column Property and Text in the Data Type property.
I am able insert text record value into table using guide. but when i clcik on ID from grid to to view for update/delete the checkbox option that checked value not there. value are in database but not checked on check box.
does it has to integer for insert value?
before show code is below
==============================================
global $employees_record;
$ArrayProject = array();
$ProjectConnection = null;
//Populate the multi-select project CheckBox list
if($employees_record->EditMode) {
//Create a new database connection object
$ProjectConnection = New clsDBIntranetDB();
$ProjectConnection->query("SELECT project_id FROM projects_employees WHERE emp_id =".$ProjectConnection->TOSql(CCGetParam("emp_id", 0),ccsInteger));
while($ProjectConnection->next_record()) {
array_push($ArrayProject,$ProjectConnection->f("project_name"));
}
$employees_record->ProjectList->Multiple = true;
$employees_record->ProjectList->Value = $ArrayProject;
//Close and destroy the recordset
$ProjectConnection->close();
}
|
 |
 |
|
