Yes, I see this is tricky because web2py closes the database connection once the response is returned, yet if you return a generator that is iterating through database queries, the connection must remain open. Do you have a suggestion for how this can be achieved (i.e., something the framework could do differently)?
Anthony On Friday, December 4, 2015 at 3:42:00 PM UTC-5, Brian Craft wrote: > > Ah, I see. I'm not sure that helps me, because I want the browser to > download the result. The problem from the UX perspective is this huge delay > between when the user clicks the download button & when the browser brings > up the "save" dialog. That delay is determined by when the server sends the > headers for the response. Because of the delay, it looks like the button > isn't working, and the user may click on it several more times. There's no > place to inject an ajax query in the built-in browser 'download' > functionality. > > There are various horrible work-arounds, like using cookies to determine > when the download has started. It's tempting to try writing a controller > that creates a thread which submits another request, where the db query > runs. > > Perhaps there should be a link to LOAD in the view docs, since it's a view > expression. > > On Thursday, December 3, 2015 at 4:27:19 PM UTC-8, Anthony wrote: >> >> On Thursday, December 3, 2015 at 5:37:51 PM UTC-5, Brian Craft wrote: >>> >>> I don't know what this means. >>> >> >> He's saying to load a parent page (that does not run the query or return >> any data), and once the parent page has loaded, then request the data via >> Ajax. >> >> >>> Also, I can't find docs for LOAD(). >>> >> >> >> http://web2py.com/books/default/chapter/29/12/components-and-plugins#Components--LOAD-and-Ajax >> >> Anthony >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.