Sort problem changed
I had made sure there was no sort set up before begining this process. The only change I made from the last post was that I left the RecNum field as being the primary key which before I had switched to Suite#.
Once again I believe I followed all the correct procedures but the result is different.
I now get - Unknown column 'Ambeau' in 'order clause' - which is the entry in the first record for Last_Name.
The Sever markup is now as follows -
//WA DataAssist Sort (Copyright 2007, WebAssist.com)
//Recordset: WADAOwner_List;
$WADA_Sort_1 = new WADA_SortObject();
$WADA_Sort_1->DefaultSort = "";
$WADA_Sort_1->ColumnList = "".((isset($_GET["sort"]))?$_GET["sort"]:"") ."^SuiteNum^Last_Name";
$WADA_Sort_1->SortOrderList = "Ascending^Ascending^Ascending";
$WADA_Sort_1->ToggleOn = true;
if ((((isset($_GET["sort"]))?$_GET["sort"]:"") != "")) {
$WADA_Sort_1->SetToClause = $WADA_Sort_1->getDefaultSetToClause();
if ($WADA_Sort_1->ToggleOn && isset($_SESSION["WADA_OrderClause_Owner_List_Results"])) {
$WADA_Sort_1->ToggleClause = $_SESSION["WADA_OrderClause_Owner_List_Results"];
}
}
else if (isset($_SESSION["WADA_OrderClause_Owner_List_Results"])) {
$WADA_Sort_1->SetToClause = $_SESSION["WADA_OrderClause_Owner_List_Results"];
}
$WADA_Sort_1->initialize();
$_SESSION["WADA_OrderClause_Owner_List_Results"] = $WADA_Sort_1->SetToClause;
$_SESSION["WADA_OrderClause_Owner_List_Results"] = $WADA_Sort_1->SetToClause;
I'm sorry about this as I seem to get different results by changing something I'm not aware of.
The database has 5 fields,
RecNum (Primary key)
SuiteNum - not indexed
Last_Name - not indexed
FirstNames - not indexed
Phone# - not indexed
My report uses all of them except the RecNum