SQL syntax on sort
Sorry to be such a bother.
When I have the multicolumn sort set up and just before adding the Sort Server Behavior all is well and shows fine in the testing server.
When I add this behavior I get the following error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, ASC LIMIT 0, 1000' at line 1.
I'm in Windows 7 and DataAssist 2.07 beta.
The server markup for this sort is 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;
I've attached the form I filled out to produce this code.