This because the search criteria are store in a session variable look for this code in your page
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_*SESSION_NAME*"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch1_*SESSION_NAME*"]) && $_SESSION["WADbSearch1_*SESSION_NAME*"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_*SESSION_NAME*"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
what is happening is that the code is checking for the presence of the session variable and the including the contents in the where clause of the recordset
What I do is include a check for the "search button" like so
//save the query in a session variable
if ((isset($_GET["WADbSearch1"])) && ($_GET["WADbSearch1"] != "")) {
$_SESSION["WADbSearch1_*SESSION_NAME*"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if ((isset($_GET["WADbSearch1"])) && ($_GET["WADbSearch1"] != "")) { // button check
if (isset($_SESSION["WADbSearch1_tbl_*SESSION_NAME*"]) && $_SESSION["WADbSearch1_tbl_categories"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_*SESSION_NAME*"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
this ensures the search code is only processed if the search button is pressed, be warned though this mod will mean that the DA Search code will no longer appear in your server behaviours panel and you will have to remove it if you want to edit it.