It looks like you have the ASC twice in your query. In your original recordset that is on this page are you filtering by a column in ascending order? Maybe you are specifying to sort by a particular column in ascending order within the DataAssist Search server behavior. If this is the case you will need to remove it from the other location it is occurring in first. Please check this out and try updating the query or the search server behavior and let us know the result.