DA Search Wizard Crashes DWCS5
Been working with 6 search criteria in the wizard without a problem.
Problem has now occurred after entering and trying to save a 7th criteria.
Ive had to manually add the line as per below, but if i now open and save, same behaviour - crashes DW CS5
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: SearchMe;
//Searchpage: index.php;
//Form: AdvSearch;
$WADbSearch2_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_POST["WADbSearch2"])) && ($_POST["WADbSearch2"] != "")) {
$WADbSearch2 = new FilterDef;
$WADbSearch2->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$WADbSearch2->addComparisonFromEdit("propPostCode","postcode","AND","=",0);
//comparison list additions
$WADbSearch2->addComparisonFromList("propVal_id","aPrice","AND","=",1);
$WADbSearch2->addComparisonFromList("propStyle_id","aType","AND","=",1);
$WADbSearch2->addComparisonFromList("propCounty","aCounty","AND","=",1);
$WADbSearch2->addComparisonFromList("propTown","aTown","AND","=",1);
$WADbSearch2->addComparisonFromList("propBeds","aBeds","AND","=",1);
$WADbSearch2->addComparisonFromList("propSales","ForSaleOnly","AND","=",1);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch2_advsearchresults"]=$WADbSearch2->whereClause;
}
}
else {
$WADbSearch2 = new FilterDef;
$WADbSearch2->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch2_advsearchresults"]) && $_SESSION["WADbSearch2_advsearchresults"] != "") {
$WADbSearch2->whereClause = $_SESSION["WADbSearch2_advsearchresults"];
}
else {
$WADbSearch2->whereClause = $WADbSearch2_DefaultWhere;
}
}
else {
$WADbSearch2->whereClause = $WADbSearch2_DefaultWhere;
}
}
$WADbSearch2->whereClause = str_replace("\\''", "''", $WADbSearch2->whereClause);
$WADbSearch2whereClause = '';
?>
Odd behaviour!
Any ideas?
Thanks, Paul.