Search

on a search or sorting may not be the

this.api().table.row(1).select(); should be: this.api().row(1).select(); http://live.datatables.net/fezodoza/7/edit Also note that row data index 1 is on the second page of the table with default sorting. Allan

I modify my sql query with where condition,after getting the sorting data,the number of entries in the datatable not changed.

original unformatted data for sorting and filtering. It takes

new $.fn.dataTable.Api( settings ).row( index ).node(); Probably worth sorting the API instance in a variable so it doesn't need to be recreated every time that the function is run. Allan

Hi, Thanks for posting back - good to hear you've got this sorted out :-) Allan

using zebra stripping, and sorting, you have to handle

taken account of when sorting and filtering unless their

a custom solution of sorts is required. Would you

Ok, I think I've sorted it. I just called the validation function twice Field::inst( 'tblpatron.EmailAddress' ) ->validator( 'Validate::unique', array( "message" => "This email address is already in use" ) ) ->validator( 'Validate::required', array( "message" => "An email address is required" ) ),