Re: [Zope] Re: Problem with keep-alive timeout

2005-06-23 Thread Ralph
On Thursday 23 June 2005 19:33, Dieter Maurer - [EMAIL PROTECTED] wrote:
 It has nothing to do with a request timeout!

 So whats the reason that this f***ing browser using HTTP1.0?

 Zope understands large parts of HTTP 1.1, among others
 the Keep-Alive header, but it is not fully HTTP 1.1 compliant.
 Therefore, it uses HTTP 1.0 in its responses.
 That's probably the reason why your browser uses HTTP 1.0
 for its requests...

Ok as I understand, my solution to wait on a database report is not the best, 
because HTTP in general isn't designed to hold connections over a long time.

But what could be a solution for such a problem? Writing the report values 
with a sessionid in the database, while the is looking at a page with an 
reload metatag until I have the results? Or writing code to store a values in 
a session? This is needing a lot of work and the resulting structure will be 
getting ugly. Is there a class or something else to make it easier?

Btw. I'm using PostgreSQL with zpsycopgda 1.15 and Zope2.80, a very basic 
interface. I tried psycopg 2.00B3 but this version had problems with testing 
in the databaseadapter, so  I decided to go back to 1.15. The hole 
databaselayer in Zope is very basic, you have to take care about things, that 
should be a part of a module. I.e. it could be a great thing to put in a 
databasedefinition plus handlingdefinition to get out a complete set of 
pages, including checks on fields.

I'm worked in 1991 at a company that had a DB-RAD-System called Unique4GL 
(from Norway) that worked in a such manner with the output on a terminal. 
Since then I had never find a similar system. You had to describe the screen 
and the part of the used databasestructure and this was all.  1:n and join 
relations to display it on one screen regarding all constraints took not more 
then 10min.  Could it be possible to make such a system with Zope, based on 
the logic of HTTP?


___
Zope maillist  -  Zope@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 )


[Zope] Re: Problem with keep-alive timeout (zope: addressed to exclusive (zope: addressed to exclusive sender for this address) sender for this address)

2005-06-22 Thread Ralph
On Tuesday 21 June 2005 23:28, Tres Seaver - [EMAIL PROTECTED] wrote:
  No that's not possible with HTTP1.0. The problem is, why IE is using
  HTTP1.0? With HTTP1.1 its possible to change keepalive-timeout.

 'keepalive' only refers to the lenght of time that the browser-webserver
 connection stays open between the completion of one request and the
 beginning of another to the same server.

 The behavior we are discussing here is that IE (or sometimes Apache in
 the middle) is configured to time out a single request after a period of
 time;  Mozilla and derived browsers don't do that by default.

MS says:

By default, HTTP 1.1 is enabled in Internet Explorer except when you establish 
an HTTP connection through a proxy server. When HTTP 1.1 is enabled, HTTP 
connections remain open (or persistent) by default until the connection is 
idle for one minute or until the value that is specified by the 
KeepAliveTimeout value in the registry is reached. You can modify HTTP 1.1 
settings in Internet Explorer by using the Advanced tab in the Internet 
Options dialog box.(http://support.microsoft.com/default.aspx?kbid=813827)

I interpret this so: You have to use HTTP1.1 . 

So whats the reason that this f***ing browser using HTTP1.0?



___
Zope maillist  -  Zope@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 )


Re: [Zope] Problem with keep-alive timeout (zope: addressed to exclusive sender for this address)

2005-06-21 Thread Ralph
On Tuesday 21 June 2005 19:16, Dieter Maurer - [EMAIL PROTECTED] wrote:
 Ralph wrote at 2005-6-20 22:36 +0200:

 The easiest way would be to use a different browser ;-)

 I think IE can be customized to use a different timeout (I do not
 know as I use Mozilla -- by default without timeout).
No that's not possible with HTTP1.0. The problem is, why IE is using HTTP1.0? 
With HTTP1.1 its possible to change keepalive-timeout.



___
Zope maillist  -  Zope@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 )


[Zope] Problem with keep-alive timeout

2005-06-20 Thread Ralph

I made a small and simple database applikation with some reports on a large 
database. But surprise, IE 6.0 (WinXP,SP2) is getting always a timeout after 
60seconds, because IE communicates with Zope through the HTTP1.0-protocoll. 
My reports needing always 40s-120s, so is there someone that could give me a 
solution for this annoying timeout problem?

___
Zope maillist  -  Zope@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 )


[Zope] Zope programms for databases

2005-06-18 Thread Ralph
I'm new to Zope and made a small database application with zope (mostly DTML) 
to learn the idea behind Zope, but I'm not satisfied with the structure of my 
application.

I have for each table a Form (DTML-method) with 3 buttons (new,update,delete). 
Each button triggers a DTML-script actionTable

actionTable calls either a DTML-method to display a form (update, insert) or 
calling the zsql-method to delete a data record. The disadvantage with this 
structure is, that it is difficult to maintain  programs like this. I wish to 
have optimistic locking but to send variables to the next DTML-method is a 
hell. 

Example: I you have a database table with the rows id,name and desc I have to 
send all record values through all methods after the user is triggering 
update to secure that there is no concurrent update. But with my design 
approach it's not possible.

Is there someone who has a better design approach or an idea?



___
Zope maillist  -  Zope@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 )


Re: [Zope] Problem with namespace (zope: addressed to exclusive sender for this address)

2005-06-18 Thread Ralph
On Thursday 16 June 2005 19:24, Dieter Maurer - [EMAIL PROTECTED] wrote:
 Ralph wrote at 2005-6-15 20:59 +0200:

 For details, please the the Calling DTML objects section in

Thank you for the answer. It was a simple programming failure, after 12h of 
working. 


___
Zope maillist  -  Zope@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 )


[Zope] Problem with namespace

2005-06-15 Thread Ralph
I have these objects:

A is calling B is calling (D and E)

My directory layout is:

/map/
/map/sql 
/map/util
/map/report/report1
/map/report/report2
/map/report/report3

Method A in report1 is rendering B in util. B is rendering a ZSQL-object 
in sql and in the tag dtml-in  is rendering C (python-method) in util, 
to render a table cell, but this isn't working, because E is unknown and I 
don't know why.

Example: 

DTML-Method A:
dtml-in sql.list_mytable prefix=pre
 dtml-var util.B(index=pre_index)
/dtml-in

DTML-Method B
td
dtml-var expr=C(index=index)   
/td

Here is Zope breaking because Zope can't find method C. Could someone help?

Ralph





___
Zope maillist  -  Zope@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 )


RE: [Zope] Does anyone care whether we deprecate ZClasses?

2005-04-05 Thread Arenz, Ralph
SOS

This would mean a disaster for us. We've created a lot products using
ZClasses in 
production environment (internet,intranet,eai and so on) since zope-2.1.4.
In short our complete developement in Zope is heavily based on ZClasses. 

We plan to use ZClasses in the future, too. For us ZClasses are a essential
part 
of zope and they works very well. It is quite impossible for us to migrate
all our 
Products to python-products or somethong else and i guess that this is not
wanted by
you!?

I think that going away from ZClasses will let many other people with
legacy-software
running in the same problems. 

regards

ralph
___
Zope maillist  -  Zope@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 )


[Zope] Re:[SybDA]Connection : how does it work ?

2000-11-28 Thread Ralph Heinkel

Hi,

Which Zope version are you using? V 2.2.0 had a bug with the connection
of the DB. I just looked into V 2.2.4 and the problematic code seems to be
fixed although I've not tried this version yet. Maybe you should upgrade.
If this is not the case, then ... hmm no idea.

Ralph


On Fri, 24 Nov 2000, you wrote:
 Hello,
 
 I am running Zope 2.1.6 under Linux/RH6.2 on a PC. The Sybase server is
 version 11.9.2 on a Solaris station with DNS name "sybstat" on port 2040
 (or sybase server name "sybtest") and the database is named "picsou".
 When I try filling in the form to add a new Sybase DA connection, the
 result is always: Invalid connection string. I have try with this
 parameters :
 1-database: picsou, password: mypasswd, server: sybstat, user: myuser
 2-database: picsou, password: mypasswd, server: sybstat:2040, user:
 myuser
 But this give the same answer ...
 
 On Linux, I have the libraries, include files and all running client for
 Sybase and I can run isql from my PC on the Sybase server on the solaris
 station very well using the parameters of the (2-) set. So the
 connection to the Sybase server seems to work ...
 
 How could I check what happens inside Zope, or am I mistaken for the
 parameters values ?
 
 Thanks for any help.
 Tony
 
 
 
 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists - 
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )
-- 
--
Ralph Heinkel  Cenix Bioscience GmbH
Director of the IT-UnitTel  : +49 6221/387 915
Meyerhofstr. 1 Fax  : +49 6221/387 971
69117 Heidelberg, Germany  eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Sybase (again?)

2000-11-13 Thread Ralph Heinkel

Hi,

We are using 
Zope 2.1.6, Sybase 11.9.2, Sybase DA 2.00b2 on Suse Linux 6.4 and 7.0, 
stored procedures just work fine. Zope 2.2.x has a problem with
Sybase, a patch has been submitted and should come with the next
release.

Ralph 



On Fri, 10 Nov 2000, Chris McDonough wrote:
 SybaseDA AFAIK does not support stored procedures.
 
 "Manuel Amador (Rudd-O)" wrote:
  
  Well,
  
  After no one else answered my last email about zope, I've decided to
  summarize what's going on with the ZSybaseDA so as to see if someone
  takes interest.
  
  STORED PROCEDURES DO NOT WORK.  Anything else, however, does.  Once a
  stored procedure was called, the db object is blocked till zope
  restarts.
  
  Any patches, solutions, suggestions?
  
 Manuel
   
 -- 
 Chris McDonough
 Digital Creations, Publishers of Zope
 http://www.zope.org
 
-- 
--
Ralph Heinkel  Cenix Bioscience GmbH
Director of the IT-UnitTel  : +49 6221/387 915
Meyerhofstr. 1 Fax  : +49 6221/387 971
69117 Heidelberg, Germany  eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Zope and Sybase Stored Procedures

2000-11-06 Thread Ralph Heinkel

Hi,

we are using Zope 2.1.6 with Sybase 11.9.2 on Suse Linux, and calling
stored procedures just works fine. 

e.g. 
create procedure csp_add_barcode
@tableName varchar(12), @barcode numeric(8) OUT
AS
insert into BarcodeItem (tableName) values (@tableName)
select @barcode = @@identity

This is a stored procedure that inserts one row into the table 'BarcodeItem'
and returns an automatically created unique identity key as a result named
'barcode'.

The ZSQL methods takes one parameter 'tableName' and returns the resulting
'barcode' like a normal select statement does.

The query template simply is:

csp_add_barcode dtml-sqlvar tableName type=string


Hope that helps. Btw, Zope 2.2.0 has a bug in connecting to SybaseDA which
is reported to digicool. Should be fixed in the next release. If interested
for the fix, send me a mail.

Ralph



--
Ralph Heinkel  Cenix Bioscience GmbH
Director of the IT-UnitTel  : +49 6221/387 915
Meyerhofstr. 1 Fax  : +49 6221/387 971
69117 Heidelberg, Germany  eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] SybaseDA and ASA

2000-10-12 Thread Ralph Heinkel

On Thu, 12 Oct 2000, you wrote:
 I've installed zope 2.2.2, and compiled sy_occ.so for SybaseDA against
 sybase-common-cantrememberversion.rpm from Sybase.  (I assume it's the
 latest one).  Loading python and importing sy_occ works perfectly.
 
 BUT, I can't create a SybaseDA SQL connection object .  Specifically,
 trying to create it sez connection failed.  I've tried EVERY POSSIBLE
 parameter combination on the creation form.  None worked.
 
 By the way, I'm using Adaptive Server Anywhere for linux, 6.0.3.  It is
 NOT ASE.  It is ASA.
 
 Does sy_occ work with ASA, or only with ASE?  Any experiences?


Last week I was trying to upgrade from Zope V 2.1.6 (with working sybase
adapter) to a 2.2.x version, and my sybase adapter stop working (yes I
recompiled it). We are using ASE 11.9.2 on a linux box. Seems like Zope has
introduced some incompatibilities which no one has discovered so far.

Ralph


--
Ralph Heinkel  Cenix Bioscience GmbH
Director of the IT-UnitTel  : +49 6221/387 915
Meyerhofstr. 1 Fax  : +49 6221/387 971
69117 Heidelberg, Germany  eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Integers in ZSQLMethod

2000-10-04 Thread Ralph Heinkel

On Wed, 04 Oct 2000, you wrote:
 Hi,
 
 Is it possible to use following code in ZSQLMethod :
 
   !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int --,
 
 But also allow null as value for the integer? (Thus not filled in)
 

use 
!--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int optional--
or the newer syntax
dtml-sqlvar MRSEQS.PAR_FLIPANGLE type=int optional
Ralph


--
Ralph Heinkel  Cenix Bioscience GmbH
Director of the IT-UnitTel  : +49 6221/387 915
Meyerhofstr. 1 Fax  : +49 6221/387 971
69117 Heidelberg, Germany  eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] howto force rendering of a dtml doc

2000-09-19 Thread Ralph Heinkel

Hi,

having a structure like
FolderA
  DocA
FolderB
 DocB

I try to display DocA from within DocB using

dtml-var "FolderA.DocA"

which basically works, except that HTML code from DocA is not rendered but
printed as plain ascii (e.g. I can see the br statements as these 4
characters).
Is there a way to force rendering?

Thanks,

Ralph


 -- 
--
Ralph Heinkel
MPI-CBG, Group Echeverri
Meyerhofstr. 1
69012 Heidelberg
Tel. 06221/387 915
Fax. 06221/387 971
eMail: [EMAIL PROTECTED]

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )