Re: Need help on designing a project

2005-12-07 Thread Magnus Lycka
Mardy wrote: > This works, but my problem is that SQL connections (MySQL or sqlite) don't > get closed when the script execution finishes, and at the next execution > of a CGI they may lock the database (this is especially true with sqlite, > but even mysql on Windows gave me these problems). You

Re: Need help on designing a project

2005-12-04 Thread Mardy
Le die Fri, 02 Dec 2005 11:34:45 +, Steve Holden ha scribite: > Note that if you are using execfile()then the best structure for your > scripts would be something like: > > conn = db.open() > try: > #do CGI stuff > finally: > conn.close() That was of great help! Thanks! -- S

Re: Need help on designing a project

2005-12-02 Thread Steve Holden
Mardy wrote: > Hi all, > I'm starting to think the way I've implemented my program > (http://www.mardy.it/eligante) is all wrong. > Basically, what I want is a web application, which might run as CGI > scripts in apache (and this is working) or even as a standalone > application, in which case it

Need help on designing a project

2005-12-01 Thread Mardy
Hi all, I'm starting to think the way I've implemented my program (http://www.mardy.it/eligante) is all wrong. Basically, what I want is a web application, which might run as CGI scripts in apache (and this is working) or even as a standalone application, in which case it would use it's own inter