hoping someone can help me on this error. all 3 of these functions generate this error-- here's the code:
//Prepare Method @5-B2596CE8
function Prepare()
{
$this->wp = new clsSQLParameters($this->ErrorBlock);
$this->wp->AddParameter("1", "urls_product_name", ccsText, "", "", $this->Parameters["urls_product_name"], "", false);
$this->wp->AddParameter("2", "urls_series_name", ccsText, "", "", $this->Parameters["urls_series_name"], "", false);
$this->wp->AddParameter("3", "urls_model_name", ccsText, "", "", $this->Parameters["urls_model_name"], "", false);
$this->wp->AddParameter("4", "urlproduct_category", ccsInteger, "", "", $this->Parameters["urlproduct_category"], "", false);
$this->wp->AddParameter("5", "urls_is_recommended", ccsInteger, "", "", $this->Parameters["urls_is_recommended"], "", false);
$this->wp->Criterion[1] = $this->wp->Operation(opContains, "product_name", $this->wp->GetDBValue("1"), $this->ToSQL($this->wp->GetDBValue("1"), ccsText),false);
$this->wp->Criterion[2] = $this->wp->Operation(opContains, "series_name", $this->wp->GetDBValue("1"), $this->ToSQL($this->wp->GetDBValue("1"), ccsText),false);
$this->wp->Criterion[3] = $this->wp->Operation(opContains, "model_name", $this->wp->GetDBValue("1"), $this->ToSQL($this->wp->GetDBValue("1"), ccsText),false);
$this->wp->Criterion[4] = $this->wp->Operation(opEqual, "store_products.category_id", $this->wp->GetDBValue("2"), $this->ToSQL($this->wp->GetDBValue("2"), ccsInteger),false);
$this->wp->Criterion[5] = $this->wp->Operation(opEqual, "is_recommended", $this->wp->GetDBValue("3"), $this->ToSQL($this->wp->GetDBValue("3"), ccsInteger),false);
$this->Where = $this->wp->opAND(false, $this->wp->opAND(false, $this->wp->Criterion[1], $this->wp->Criterion[2]), $this->wp->Criterion[3]);
}
//End Prepare Method
//Open Method @5-AF6C1DD2
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
$this->CountSQL = "SELECT COUNT() " .
"FROM store_products LEFT JOIN store_categories ON store_products.category_id = store_categories.category_id";
$this->SQL = "SELECT store_products., category_name " .
"FROM store_products LEFT JOIN store_categories ON store_products.category_id = store_categories.category_id";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
$this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
$this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
$this->MoveToPage($this->AbsolutePage);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
$this->CountSQL = "SELECT COUNT() " .
"FROM spa_series LEFT JOIN series_models ON spa_series.category_id = store_categories.category_id";
$this->SQL = "SELECT store_products., category_name " .
"FROM spa_series LEFT JOIN series_models ON spa_series.category_id = store_categories.category_id";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
$this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
$this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
$this->MoveToPage($this->AbsolutePage);
}
//End Open Method
//SetValues Method @5-ABFA6BA0
function SetValues()
{
$this->product_name->SetDBValue($this->f("product_name"));
$this->series_name->SetDBValue($this->f("series_name"));
$this->model_name->SetDBValue($this->f("model_name"));
$this->category_id->SetDBValue($this->f("category_name"));
$this->price->SetDBValue(trim($this->f("price")));
$this->is_recommended->SetDBValue(trim($this->f("is_recommended")));
}
//End SetValues Method