Recordsets not sorted correctly in DA

Hi, inside a DA created page, one of my recordsets doesn't sort correctly. I have it set to 'ORDER BY tblcases.CaseID Desc' in query manager and if tested in there it shows correctly. If I then view in page it does 'ORDER BY tblcases.CaseID Asc',

I do have 2 other recordsets in the page but I dont think they are affecting this one, they simply provide data for menus created by DA wizard..

Any ideas where I am going wrong, the page is attached..

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

++Update++
In case this happens to anyone else, Jason & Ray from support have found the issue. Its a conflict between DA & DataTables plugin [].

From support "The jquery data table has its own sorting functionality that uses javascript and is overriding the main sort from DA in the server side code.

The two could probably be used together, but they are basically working in two different worlds. Client side javascript for the jquery and Server Side php for DA, so it would take some careful configuration to make them play nice together."

Thanks for helping me identify this issue, getting round it is another problem but at least I know now ehere the problem lies, would have taken me months to find that!

Regards

Gary

Another update, original diagnosis may have been incorrect. When using datatables you can add this value to sort any column or multi column.. Just change column number to desired one..

$(document).ready(function() {
$('#example').dataTable( {
"aaSorting": [[ 4, "desc" ]]
} );
} );

Hope it helps someone..

Gary