Call controller automatically

[FERNANDO VILLARROEL]

Dear.

I have a controller that basically runs a SQL shown in their respective views.

Need is that while the user STAY in this view, the controller automatically running every 5 seconds, and so the result of the SQL refresh the view.

I could use a Refresh button, but I want it to be automatic.

How i can do?

Fernando

[Anthony]

Perhaps you could use an ajax component (see http://web2py.com/books/default/chapter/29/12#Components):

{{=LOAD(..., timeout=5000, times='infinity', ajax=True)}}

That will load the component via Ajax and refresh its content every 5 seconds indefinitely.

Anthony