You have an error in your SQL syntax

Hi.

I am trying to set up Dataassist Sort with one of my pages. Everything seemed to be going well then I got this error suddenly;

(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 'name_tb' at line 1)

I have added the page and hope some one can find the problem because I am not able to.

Thanks

(Update)

Something is very strange, I am using Firefox 29.0.1, and every now and then when I clear my history (testing my site on the local server) I get the ou have an error in your SQL syntax error but then a couple of minutes later, without doing any thing to my pages, the page suddenly starts working correctly and there is no errors.

I uploaded the test page to my website and there I also get the same error.

Was able to re-create the error.

1: I select either name or price to sort my columns.
2: I then cleared my history.
3: Removed the ?sort=name_tb in the URL.
4: Pressed enter and wham, the error comes up.

If I add the ?sort=name_tb after getting the error my page shows normally once again. If on my website I enter all-tiger-nut-related-products-Results1.php?sort=price_tb instead of all-tiger-nut-related-products-Results1.php the page displays. I can then remove the ?sort=price_tb and the page displays normally. I have no clue what could cause this problem.

I'll need to troubleshoot directly, see the private message section.

See private msg.

Hi Jason.

I found the problem.

I had my code as:

$WADA_Sort_1 = new WADA_SortObject();
$WADA_Sort_1->DefaultSort = "name_tb";
$WADA_Sort_1->ColumnList = "".((isset($_GET["sort"]))?$_GET["sort"]:"") ."";
$WADA_Sort_1->SortOrderList = "Ascending";
$WADA_Sort_1->ToggleOn = false;


Then changed ($WADA_Sort_1->DefaultSort) to

$WADA_Sort_1 = new WADA_SortObject();
$WADA_Sort_1->DefaultSort = "ORDER BY name_tb ASC";
$WADA_Sort_1->ColumnList = "".((isset($_GET["sort"]))?$_GET["sort"]:"") ."";
$WADA_Sort_1->SortOrderList = "Ascending";
$WADA_Sort_1->ToggleOn = false;

Now it seems to be working. Did I do it correctly or not? Don't want any problems later on.

Thanks

yes, that is correct for the default sort.