May 2003 - Zope - Zope lists

Wanted: links for backup, optimizing, db adaptors, gui editors, troubleshooting?
by Robert Nagle 22 May '03

22 May '03

Hi, I'm a relative newbie to the zope world and am putting together a list of favorite how-to's/articles/install/config articles. The online Zope Book is excellent, and I know some excellent how to's have been written. (For example, the excellent list on plone.org http://plone.org/documentation/howto/) But sometimes it's hard to tell what's current or interesting. And for the newbie, it's a little overwhelming to know where to start. I've pretty much looked over all the how-to's on http://www.zope.org/Documentation and was curious if anyone had articles on their own sites or know of any non-zope.org content I may have missed. In particular I'm looking for topics such as: backup optimizing performance db adaptors gui editors and zope troubleshooting product installations Feel free to throw links my way. (Actually, in the interest of reducing mailing list traffic, I would ask that you send it directly to me rather than the list, and then next week I'll post the url for the links page I put up (and forward it to anybody who responded). Thanks for your help. Robert Nagle, idiotprogrammer, Houston, Texas __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

1 0

RE: [Zope] setting date to Null in MS SQL?
by McDonnell, Larry 22 May '03

22 May '03

Hi, Sorry, this MS Access. -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Thursday, May 22, 2003 12:07 PM To: McDonnell, Larry; 'zope(a)zope.org' Subject: RE: [Zope] setting date to Null in MS SQL? Hi, thanks Are you using Microsoft SQL server? This does not submit for me without commas after the NULL and variable lines and even then it still does not insert the NULL into the database- instead 1/1/1900 Like I said, it inserts NULL for and update but not for insert I wonder if it is a microsoft thing. --Sean <dtml-if AppDelDate> <dtml-if "AppDelDate==''"> NULL, <dtml-else> <dtml-sqlvar AppDelDate type=string>, </dtml-if> <dtml-else> NULL, </dtml-if> -----Original Message----- From: McDonnell, Larry [mailto:lmcdonnell@protonenergy.com] Sent: Thursday, May 22, 2003 6:22 AM To: Kelley, Sean; 'zope(a)zope.org' Subject: RE: [Zope] setting date to Null in MS SQL? Hi, I do this within the zsql method - <dtml-if creation_date> <dtml-if "creation_date==''"> NULL <dtml-else> <dtml-sqlvar creation_date type=string> </dtml-if> <dtml-else> NULL </dtml-if> Chris Kratz provided me with this awhile ago. Hope this helps. -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Wednesday, May 21, 2003 6:38 PM To: 'zope(a)zope.org' Subject: [Zope] setting date to Null in MS SQL? I have a simple app where I need to let people set dates to null via a form. I am trying to test for an empty form field and set the value to NULL if empty. It seems to work on form submission but when I do a database query I see it is actually set to 1/1/1900 I have found a way to update a record if it already has a value and you clear the form field, but for some reason this same method does not work for an initial insert. In both of my sql methods I have: <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> What am I missing? _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] setting date to Null in MS SQL?
by Kelley, Sean 22 May '03

22 May '03

Hi, thanks Are you using Microsoft SQL server? This does not submit for me without commas after the NULL and variable lines and even then it still does not insert the NULL into the database- instead 1/1/1900 Like I said, it inserts NULL for and update but not for insert I wonder if it is a microsoft thing. --Sean <dtml-if AppDelDate> <dtml-if "AppDelDate==''"> NULL, <dtml-else> <dtml-sqlvar AppDelDate type=string>, </dtml-if> <dtml-else> NULL, </dtml-if> -----Original Message----- From: McDonnell, Larry [mailto:lmcdonnell@protonenergy.com] Sent: Thursday, May 22, 2003 6:22 AM To: Kelley, Sean; 'zope(a)zope.org' Subject: RE: [Zope] setting date to Null in MS SQL? Hi, I do this within the zsql method - <dtml-if creation_date> <dtml-if "creation_date==''"> NULL <dtml-else> <dtml-sqlvar creation_date type=string> </dtml-if> <dtml-else> NULL </dtml-if> Chris Kratz provided me with this awhile ago. Hope this helps. -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Wednesday, May 21, 2003 6:38 PM To: 'zope(a)zope.org' Subject: [Zope] setting date to Null in MS SQL? I have a simple app where I need to let people set dates to null via a form. I am trying to test for an empty form field and set the value to NULL if empty. It seems to work on form submission but when I do a database query I see it is actually set to 1/1/1900 I have found a way to update a record if it already has a value and you clear the form field, but for some reason this same method does not work for an initial insert. In both of my sql methods I have: <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> What am I missing? _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] Do While Loop Equivalent
by McDonnell, Larry 22 May '03

22 May '03

Hi, Thanks David, someone was fooling around and created another index that I did not know about. Once removed your statement worked. -----Original Message----- From: David Hassalevris [mailto:bluepaul@earthlink.net] Sent: Thursday, May 22, 2003 11:35 AM To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) Subject: Re: [Zope] Do While Loop Equivalent If all your keys are null then those become duplicates? Put a unique key in each. If necessary add a primary key that just gets incremental numbers. hth David ----- Original Message ----- From: "McDonnell, Larry" <lmcdonnell(a)protonenergy.com> To: "David Hassalevris" <bluepaul(a)earthlink.net>; "'Zope@Zope. Org' (E-mail)" <zope(a)zope.org> Sent: Thursday, May 22, 2003 8:18 AM Subject: RE: [Zope] Do While Loop Equivalent > Hi, > > Sorry David, Andreas, and Dennis for the short email that did not explain my > problem fully (had to go to a > meeting). I use dtml mostly but I'm starting to see the power of Python. I > am creating a web based system to collect test data during our manufaturing > process. I can generate a serial number but depending on the part the items > within a this serial number can be 4, 10, 24, 34 items. I need to create > these records first so they can update them as they are testing. With my > zsql method, I am creating records with 3 fields populated using David's > dtml-in method: > > <dtml-call "REQUEST.set('cell_number', 0)"> > <dtml-in "_.range(10)"> > <dtml-call "REQUEST.set('cell_stack_number', cell_number+1)"> > > <dtml-call expr="create_atp_fields_record(REQUEST)"> > </dtml-in> > > But an error message: > > Error Type: sql.error > Error Value: ('23000', -1605, '[Microsoft][ODBC Microsoft Access Driver] The > changes > you requested to the table were not successful because they would create > duplicate values > in the index, primary key, or relationship. Change the data in the field or > fields that > contain duplicate data, remove the index, or redefine the index to permit > duplicate entries > and try again.') > > I have no indexes or primary key set. Any sugesstions? Thanks. > > -----Original Message----- > From: David Hassalevris [mailto:bluepaul@earthlink.net] > Sent: Wednesday, May 21, 2003 4:05 PM > To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) > Subject: Re: [Zope] Do While Loop Equivalent > > > <dtml-in "_.range(9)"> > ... add block of records > > </dtml-in> > Was that what you wanted? > David > ----- Original Message ----- > From: "McDonnell, Larry" <lmcdonnell(a)protonenergy.com> > To: "'Zope@Zope. Org' (E-mail)" <zope(a)zope.org> > Sent: Wednesday, May 21, 2003 12:55 PM > Subject: [Zope] Do While Loop Equivalent > > > > > > Hi, > > > > I have been searching for a while but I am coming up empty. I am writing a > > module that needs to create a block of records in the db so they can be > > updated at a later time. In the good old days, I would use a do while loop > > (do something while x < 10). How can this be done? And as always any > > pointers will be appreciated, thanks. > > > > > > Larry McDonnell > > > > Proton Energy Systems > > 10 Technology Drive > > Wallingford, CT 06492 > > (203) 678-2181 > > Email:lmcdonnell@protonenergy.com > > www.protonenergy.com > > > > > > _______________________________________________ > > Zope maillist - Zope(a)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 )

1 0

RE: [Zope] Do While Loop Equivalent
by McDonnell, Larry 22 May '03

22 May '03

Hi, Sorry David, Andreas, and Dennis for the short email that did not explain my problem fully (had to go to a meeting). I use dtml mostly but I'm starting to see the power of Python. I am creating a web based system to collect test data during our manufaturing process. I can generate a serial number but depending on the part the items within a this serial number can be 4, 10, 24, 34 items. I need to create these records first so they can update them as they are testing. With my zsql method, I am creating records with 3 fields populated using David's dtml-in method: <dtml-call "REQUEST.set('cell_number', 0)"> <dtml-in "_.range(10)"> <dtml-call "REQUEST.set('cell_stack_number', cell_number+1)"> <dtml-call expr="create_atp_fields_record(REQUEST)"> </dtml-in> But an error message: Error Type: sql.error Error Value: ('23000', -1605, '[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.') I have no indexes or primary key set. Any sugesstions? Thanks. -----Original Message----- From: David Hassalevris [mailto:bluepaul@earthlink.net] Sent: Wednesday, May 21, 2003 4:05 PM To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) Subject: Re: [Zope] Do While Loop Equivalent <dtml-in "_.range(9)"> ... add block of records </dtml-in> Was that what you wanted? David ----- Original Message ----- From: "McDonnell, Larry" <lmcdonnell(a)protonenergy.com> To: "'Zope@Zope. Org' (E-mail)" <zope(a)zope.org> Sent: Wednesday, May 21, 2003 12:55 PM Subject: [Zope] Do While Loop Equivalent > > Hi, > > I have been searching for a while but I am coming up empty. I am writing a > module that needs to create a block of records in the db so they can be > updated at a later time. In the good old days, I would use a do while loop > (do something while x < 10). How can this be done? And as always any > pointers will be appreciated, thanks. > > > Larry McDonnell > > Proton Energy Systems > 10 Technology Drive > Wallingford, CT 06492 > (203) 678-2181 > Email:lmcdonnell@protonenergy.com > www.protonenergy.com > > > _______________________________________________ > Zope maillist - Zope(a)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 )

2 1

FYI: ZOPE RPMs for RedHat 8.0 and 9, SuSE 8.x, Debian/woody
by Marcus Schopen 22 May '03

22 May '03

Hi, Wondering why RedHat doesn't provide RPMs for Zope, I spent a weekend to make one of the most popular web application servers availible for one of the most popular linux distributions. You can download RPMs for RedHat 8.0 and 9, SuSE 8.x and Debian/woody deb from my member site http://www.zope.org/Members/medienlabor/packages or from the mirror of German/Deutsche Zope User Group (DZUG) http://www.dzug.org/Download Feel free to use this service. Any bugreport and feedback is welcome. Please send to mschopen at dzug org. be zoped Marcus Schopen -- Marcus Schopen (0> P.O. Box 10 25 25 //\ Deutsche Zope User Group D-33525 Bielefeld V_/_ www.dzug.org mschopen(a)dzug.org

1 0

RE: [Zope] setting date to Null in MS SQL?
by McDonnell, Larry 22 May '03

22 May '03

Hi, I do this within the zsql method - <dtml-if creation_date><dtml-if "creation_date==''">NULL<dtml-else> <dtml-sqlvar creation_date type=string></dtml-if><dtml-else>NULL</dtml-if> Chris Kratz provided me with this awhile ago. Hope this helps. -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Wednesday, May 21, 2003 6:38 PM To: 'zope(a)zope.org' Subject: [Zope] setting date to Null in MS SQL? I have a simple app where I need to let people set dates to null via a form. I am trying to test for an empty form field and set the value to NULL if empty. It seems to work on form submission but when I do a database query I see it is actually set to 1/1/1900 I have found a way to update a record if it already has a value and you clear the form field, but for some reason this same method does not work for an initial insert. In both of my sql methods I have: <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> What am I missing? _______________________________________________ Zope maillist - Zope(a)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 )

1 0

The trouble with cookies....
by Jeremy Cook 22 May '03

22 May '03

The trouble with cookies that I am finding is that when I set a cookie from the server, it takes a finite amount of time to transmit it and then read back the new value. It at least takes longer than it takes to display a page. This causes a problem in the logic of my site because I rely on the cookie to tell me something about the user. I need to be able to set a cookie (or some other state variable?). Then when I show the next web page I want the contents to reflect the new value of the cookie, however when I read the just-set cookie back, it has not yet been set to the new value! You can see what I mean by going to this page: http://kalandskolemusikk.no/?page=video If you click on 'hare', you have to do it twice (or click once and then reload) to get the title text to change blue (the same goes for 'snegle' to get it to change green) because when the cookie is sent on the first click, it has not been received back by the time the text is redisplayed. An obvious solution would be to have a 'parallel' local logic that changes the color anyway without checking the cookie but I am reluctant to do this because you are supposed to be able to come back to this page with the cookie already set from a previous session. Is there some way to do a 'blocking' setCookie, or is there some other way to set a session based state variable? -- Jeremy Cook <Jeremy.Cook(a)ii.uib.no> Parallab

2 1

Re: [Zope] Save Zope (and me) before Citrix!
by Jaroslav Lukesh 22 May '03

22 May '03

: Odesílatel: Dylan Reinhardt <zope(a)dylanreinhardt.com> : The trick is not to bill it that way. Bill out cost of ownership, not : parts and labor. : Let's say you could deploy a just-as-good solution in half the time : using Zope. Having stipulated that such a solution is worth $20,000 to : the client, you maintain that price. Now you've got: : : Licensing fees ........... $ 0 : Labor ..(100 hours @ 100) $10,000 : Pure profit .............. $10,000 : : But on the client's invoice it says: : : Excellent software ....... $20,000 That is problem with tax. Because software is owned (by invoice as in your example), so cost of OpenSource ownership is higher than M$ with your example. If cost of software is zero, then cost of service hours does not have any negative aspect to tax and cost of company. Because from cost of company (ie., sum of all things that company own) is calculated tax. : > But I will try to push my chief to selling solutions from me, not service : > hours. Chief sells mainly service hours (he have simple calculator: much : > time = much money). : : See if his calculator does this function: : : Same price - lower overhead = more money I was talk about this problem with our accountant, but she does not say me anythink positive. Because why peoples that serving Microsoft solutions with very $$$ trainings and certificates may have less money per hour than one people without many costly and acredited certificates? I think that it is the core of the problem. Maintaining of good level of human relations. Dont forget, I am from Czech, not from western democracy country. Communists thinking and equalitarian will here live for long time. Ech... but so - I spend time at my company and try to save some money, then I buy leased line to internet with server and try to make my own business with Zope. For example - by allowing to access customer to WYSIVIG manage pages, I was spend about 2 hours together with finding of right method to client's data conversion/formatting, writing documentation and online training plus some DTML scripts. I say to chief that it may sell this "access" for 10x more than my cost per hour. He says me that client know how many hours I was spend on this solution, so client will not want to pay more than in service agreement is defined. : Support contracts also work better if you charge a monthly support fee : instead of billing out incidents hourly. Moving away from hourly : billing for support tends to increase client satisfaction a lot, too. : The easier a product is to support, the more support can become a profit : center instead of a cost to avoid. Absolutelly great idea, but my chief have in 180 degree different. It is due to transfer liability for M$ software to client side, not our side, which will if client will pay monthly constant fee. Damned Microsoft! I will try to speak with chief about it. Many thanks to all for great ideas. J. Lukesh

1 0

Returned mail: see transcript for details
by Mail Delivery Subsystem 22 May '03

22 May '03

The original message was received at Thu, 22 May 2003 21:50:51 +0900 (KST) from swjh(a)[61.34.141.219] ----- The following addresses had permanent fatal errors ----- <zotggulrina(a)kebi.com> (reason: addressee unknown) ----- Transcript of session follows ----- ŸÆÀÌµð zotggulrinaÀº(ŽÂ) Ä³ºñ žÞÀÏ¿¡ ŸøŽÂ ŸÆÀÌµðÀÔŽÏŽÙ. ŸÆÀÌµð°¡ Á€È®ÇÑÁö ŽÙœÃ È®ÀÎÇØ ÁÖœÊœÃ¿À. 550 5.1.1 <zotggulrina(a)kebi.com>... User unknown

1 0