Run query in view rather than controller

[eluser]prestondocks[/eluser]
Could you provide the reason for running the query in the View. You are working outside of the Model, View, Controller framework if you put data access or too much logic in your views.

We may be able to help you put the query back in the model where it should be if we understand the what you are trying to do.

Simon