Hello to all,

I have en existing pager where a form search form is integrated. There are many field in this form, the Where condition is generated .

If ($_POST["submit"] {
…
$sql = "SELECT fields From table WHERE… "
} else {
$sql = "SELECT fields From ….WIHTOUT WHERE"
}
The results have the same fields.

Now I want the grid with the Data

$grid = new …..
$grid->SelectCommand = $sql;

But in every Case I get the result of the SQL Statement without WHERE. With echo $sql I checked the Statements…they are correct.

Is it possible to use the grid this Way?

Thanks for your help