This is the search code currently:
<cfscript>
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAdbotblDonations;
//Searchpage: tblDonations_Search.cfm;
//Form: WADASearchForm;
WADbSearch1_DefaultWhere = "";
WADbSearch1_SetSession = "";
if (isDefined("URL.Search.x") AND URL.Search.x NEQ ""){
WADbSearch1 = FilterDef("SQL SERVER");
//keyword array declarations
//comparison list additions
WADbSearch1 = addComparisonFromEdit(WADbSearch1,"last_name","S_donorID","","Includes",0);
WADbSearch1 = addComparisonFromEdit(WADbSearch1,"company","S_company","OR","Includes",0);
//end comparison additions
if (1 EQ 1){
WADbSearch1_SetSession = "WADbSearch1_tblDonations_Results";
}
}
else {
WADbSearch1 = FilterDef("SQL SERVER");
if (1 EQ 1){
if (IsDefined("Session.WADbSearch1_tblDonations_Results")){
//get session query
WADbSearch1.whereClause = Session.WADbSearch1_tblDonations_Results;
}
else{
//use default query
WADbSearch1.whereClause = WADbSearch1_DefaultWhere;
}
}
else{
//use default query
WADbSearch1.whereClause = WADbSearch1_DefaultWhere; }
}
WADbSearch1.whereClause = WA_Replace(WADbSearch1.whereClause, 'WHERE');
</cfscript>