alanyoung

I am trying to capture user input to use as the criterion in an sql, which will ultimately display the recovered records to the user. However although I can capture the user input and can apply it in an sql against the database and display the results to the user, problems arise if pagination is applied to the activeDataProvider. When multiple records are displayed and the view allows the user to display further results, instead of displaying those further results the user is returned to the initial user input view. I have tried ‘sqlDataProvider’ and 'activeDataProvider’ but always with the above result. I would appreciation any comments, as I am clearly missing something fundamental here!