[Zope] MySQL Threading

[cheng saimun]

hello, for method 2, can you provide more specific code snippets wrt to the meta thingy?
i have a form (upload.html ) which will call a dtml-method ( uploadHandler ) consisting of external methods ( python ).
So how do i display the waiting page while waiting for the uploadHandler to complete, and then returning to upload.html

thanks

----- Original Message ----- 
From: Tino Wildenhain 
Date: Tue, 23 Dec 2003 19:10:18 +0100 
To: Ralph vd Houdt 
Subject: Re: [Zope] MySQL Threading 

> Hi Ralph, 
> 
> Ralph vd Houdt wrote: 
> > Hi All, 
> > 
> > I'm currently writing an application in which an report-page is based on a 
> > heavy SQL query. The query runs about 15 seconds (the result will be stored 
> > in a session). For this reason I want to create a waiting page which checks 
> > if the SQL query has finished running. Does anybody know if I can run the 
> > SQL query in a separate thread and redirect to the report-page when the 
> > query has finished (by polling the thread). The results will be read from 
> > the session and used in the report-page. 
> 
> Forget about all the threading issue. Even if you would manage to get it 
> work in Zope, tt will not fit into HTTP call model. 
> 
> The solution is quite easy: 
> 
> 1.) simple javascript switches style in your page to change form to 
> a waiting page and then submits information. 
> User would see waiting page until information returns from database 
> and zope 
> 
> 2.) without Javascript, you call a simple waiting page, maybe with 
> anim gif or message, and in the page you have 
> 
> It only works with http-equiv headers, not with real HTTP header 
> as of response.setHeader(). 
> The next request starts immediately after loading the waiting page 
> and the user sees the waiting page until 2nd call to zope returns. 
> 
> 
> For the 2nd solution you should provide a link (maybe with the anim gif) 
> to the data page, in case someone disabled redirects and is waiting 
> forever then. 
> 
> Regards 
> Tino Wildenhain 
> 
> 
> _______________________________________________ 
> Zope maillist - Zope at zope.org 
> http://mail.zope.org/mailman/listinfo/zope 
> ** No cross posts or HTML encoding! ** 
> (Related lists - 
> http://mail.zope.org/mailman/listinfo/zope-announce 
> http://mail.zope.org/mailman/listinfo/zope-dev ) 
-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm