Zomar
|
| Posted: 11/20/2004, 2:54 PM |
|
I would like to have a way to display in the grid tasks with a NULL {task_finish_date} and tasks which IS NOT NULL Another words pending tasks and finished tasks. Preferably a checkbox in the search bar.
I am trying to convert ASP code to php and this is what I got, but there is a problem with line 16 which is line 6 below:
function tasks_ds_BeforeBuildSelect() {
//dim $CHK;
//dim $sSQLWhere;
$sSQLWhere = tasks.$ds.$where;
$CHK = $getCheckBoxValue[$GetParam["chk_pending"], "1", "0", "Integer"];
//Response.Write "tasks.ds.where: '" & sSQLWhere & "'<HR>"
//Response.Write "CHK: " & CHK & "<HR>"
//response.end
if ($CHK == 1) {
if ($sSQLWhere == EMPTY) {
$sSQLWhere = " task_finish_date IS NULL";
} else {
$sSQLWhere = $SQLWhere." AND task_finish_date IS NULL";
}
} else {
if ($sSQLWhere == EMPTY) {
$sSQLWhere = " task_finish_date IS NOT NULL";
} else {
$sSQLWhere = $SQLWhere." AND task_finish_date IS NOT NULL";
}
}
//Response.write "SQLWhere: " & sSQLWhere & "<BR>"
tasks.$ds.$where = $sSQLWhere;
}
Please help
|
|
|
 |
|
