Re: [Zope] Download Large Files in Zope

2007-03-07 Thread Jary Busato
Maciej Wisniowski ha scritto: I've just installed Zope 2.8 with Apache 2 and I made a download library (a CMS site is too much for me and I can't find a simple "download area" product, so I've done it!) What about railorad: http://www.infrae.com/products/railroad

Re: [Zope] Download Large Files in Zope

2007-03-07 Thread Jary Busato
Maciej Wisniowski ha scritto: Large files aren't store in ZODB but in a shared folder connected with LOCALFS. Maybe Zope load a file in zodb before begin the download? (Are there other storage product that work only in zope - without plone?) Tramline is an Apache add-on but my problem

Re: [Zope] Download Large Files in Zope

2007-03-07 Thread Jary Busato
Maciej Wisniowski ha scritto: Looking LocalFS specs I find the issue: This version of LocalFS takes advantanges of Zope 2.7.1 http://www.zope.org/Members/hewei/zoperpms/zope2.7 's new /filestream_iterator/ feature and is believed to server large files better than before. However, my

Re: [Zope] Download Large Files in Zope

2007-03-07 Thread Jary Busato
Maciej Wisniowski ha scritto: I don't understand your paste. I'll try to describe better my situation - server A with Apache(80) and a rewrite rule to Zope(8080) - server B with a shared folder "storage" - *without any webserver* - server C with MS SQL Server - *without any webserver*

Re: [Zope] Download Large Files in Zope

2007-03-07 Thread Jary Busato
Maciej Wisniowski ha scritto: Sorry, I push the wrong button when I reply I'll try your configuration, but - where are files stored? (I dont't see server B in your post) Read http://www.infrae.com/products/tramline There is description where files are stored - it

Re: [Zope] How can run multiple query in an Z sql method

2007-03-09 Thread Jary Busato
Yes, I must do it when I need to know an autonumber PK after an insert. when DB support transaction i write: begin transaction insert foo into bar dtml-var sql_delimiter SELECT LAST_INSERT_ID() as lastid commit Then, a DTML method: dtml-in myZSQLinsertandselect() dtml-var lastid /dtml-in

Re: [Zope] How can run multiple query in an Z sql method

2007-03-09 Thread Jary Busato
My only need is to be sure to keep the right id; I did'nt use this method for other operations. You sayd that it's not recommended but I don't understand why in this simple context. Andreas Jung ha scritto: --On 9. März 2007 15:30:23 +0100 Jary Busato [EMAIL PROTECTED] wrote: Yes, I must

Re: [Zope] How can run multiple query in an Z sql method

2007-03-09 Thread Jary Busato
If I understood you're telling me that begin and commit statements are redundant. Sometimes conflicts are not correctly managed by ZTM (no rollbacks in db) Marco Bizzarri ha scritto: On 3/9/07, Jary Busato [EMAIL PROTECTED] wrote: Yes, I must do it when I need to know an autonumber PK after