Search in Ajax with Query Sum()

emersoncoder

Hello friends, I have a problem.

I'm using a query with sum in my select, with datatables ajax.

But, when I search any work in datatable, return for me this error : Error Number: 1111

Invalid use of group function

Why I cannot do a query with sum in datatables with ajax ?

Thanks in advanced !!!!!

emersoncoder

Other questions, How I put to ignore this column in search ? Thanks again

allan

Please don't 'shout' in the title. Also please read the forum rules and link to a test page:
http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read .

Also please don't cross post! It simply takes my time up from answering questions, meaning that I can answer less questions.

Allan