- Zope - Zope lists

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

Delivery Status Notification (Failure)
by postmaster＠emrxeag2iicloo2 22 May '03

22 May '03

This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. zoxl(a)dreamwiz.com

1 0

Delivery failure
by MAILER-DAEMON＠yahoo.com 22 May '03

22 May '03

Message from yahoo.com. Unable to deliver message to the following address(es). <zorcerer(a)yahoo.com>: Sorry your message to zorcerer(a)yahoo.com cannot be delivered. This account has been disabled or discontinued [#102]. <zork119(a)yahoo.com>: This user doesn't have a yahoo.com account (zork119(a)yahoo.com) [-5] --- Original message follows. X-Rocket-Spam: 61.34.141.219 X-YahooFilteredBulk: 61.34.141.219 X-Rocket-Track: 6736: 20 X-Rocket-Server: 66.163.174.40 Return-Path: <zope(a)zope.org> Received: from 61.34.141.219 (EHLO emrxeag2iicloo2) (61.34.141.219) by mta129.mail.sc5.yahoo.com with SMTP; 22 May 2003 05:38:19 -0700 (PDT) Received: from 61.34.141.219 ([211.190.213.252]) by emrxeag2iicloo2 with Microsoft SMTPSVC(5.0.2195.5329); Thu, 22 May 2003 21:37:23 +0900 from:±îÆäÁÖÀÎÀå Subject:Ã€ÆÃÇÏžéŒ Æ÷-ž£-³ë ºž±â Content-Type:text/html Content-Transfer-Encoding:7bit Bcc: Return-Path: zope(a)zope.org Message-ID: <EMRXEAG2IICLOO2GJ2T0000000f@emrxeag2iicloo2> X-OriginalArrivalTime: 22 May 2003 12:37:23.0546 (UTC) FILETIME=[E4E0D3A0:01C3205E] Date: 22 May 2003 21:37:23 +0900 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=euc-kr"> </head> <body> <table width="81%" height="39" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="95%"><div align="center"><strong><font size="2">ŽõÀÌ»ó Æ÷ž£³ë ÀÎÃŽ ÇÏŽÂ<font color="#0000CC"> ±¹³»»çÀÌÆ®</font>¿¡ ŒÓÁö ž¿œÃŽÙ¡Ú ®œº žÞŽÏŸÆ°¡ Àû±Ø ÃßÃµÇÏŽÂ <font color="#FF0000">ÇØ¿ÜÇöÁö¿¡Œ Á÷Á¢ ÁŠÀÛÇÏŽÂ <font color="#66CC00" size="3">¿Àž®Áö³¯ Æ÷ž£³ë</font></font></font></strong></div></td> </tr> </table> <table width="81%" height="468" border="1" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td width="59%" height="80"><div align="center"><font size="2"><a href='http://588bozi.com/broker.html?p_id=Tkawlghkdlxl' target='_blank'> </a><br> <a href="http://www.billmon.com/barors/RsCheck?s=10000000219&r=10000015163"><img src="http://live69tv.com/69_img/banner/main_banner_1.jpg" width="519" height="167" border="0"></a><br> </font></div></td> <td width="41%"> <div align="center"> <h4> </h4> <h4><strong><font color="#FF0000" size="3">ÇØ¿ÜÆ÷ž£³ë»çÀÌÆ®Áß °¡Àåž¹Àº PJ ºžÀ¯</font></strong></h4> <h4><br> <font size="2" face="±Œž²ÃŒ">»çÁøžž ÁžÀçÇÏ°í ¹æŒÛ Ãâ¿¬Àº ÇÏÁö ŸÊŽÂ ±×·± œÎÀÌÆ®°¡ ŸÆŽÕŽÏŽÙ. 100% Ãâ¿¬ : ÇÇÁŠÀÌµéÀÇ ÀÎ»çž»Àº ¹«·áÀÔŽÏŽÙ.</font></h4> <h4><font color="#990000" size="2" face="±Œž²ÃŒ"><strong>PJ œÇœÃ°£ »ý¹æŒÛ ÃâÇö</strong></font></h4> <p><strong><font color="#0000CC">°Ãß</font></strong><font color="#FF0000">¡Ú¡Ú¡Ú¡Ú¡Ú</font><br> </p> </div></td> </tr> <tr> <td height="140" bgcolor="#FFFFFF"><div align="center"><font size="2">  <a href="http://www.billmon.com/barors/RsCheck?s=10000008896&r=10000015230"><img src="http://www.sexquire.com:8080/ss/images/index_02.gif" width="417" height="89" border="0"></a></font></div></td> <td><div align="left"> <p><strong><font color="#0000FF" size="2">ÇØ¿Ü Àü°Ý »çÀÌÆ® Áß ŸÆÁÖ ŽÙŸçÇÑ(ÇÏµåÄÚŸî,žô·¡Ä«žÞ¶ó,</font></strong><font color="#0000FF" size="2"><strong>ÇØ¿ÜžôÄ«,ÁýŽÜŒº±³ µîµî) ®œº ÄÁÅÙÃ÷ ºžÀ¯</strong></font></p> <p align="center"><font color="#FF0000" size="2"><strong>ÃßÃµ</strong></font><font color="#FF0000">¡Ú¡Ú¡Ú¡Ú¡Ú</font></p> </div></td> </tr> <tr> <td height="140"><div align="center"><font size="2">  <a href="http://links.verotel.com/cgi-bin/showsite.verotel?vercode=10351:98040000004…"><img src="http://www.xxxdol.com/banner/x03.gif" width="300" height="67" border="0"></a></font></div></td> <td><div align="left"> <p align="center"><strong><font color="#000000" size="2">Àú·ÅÇÑ °¡°ÝÀž·Î Áñ±æ Œö ÀÖŽÂ Œ¹ÎÇü Æ÷ž£³ë</font></strong></p> <p align="center"><font color="#FF0000" size="2"><strong>ÃßÃµ</strong></font><font color="#FF0000">¡Ú¡Ú¡Ú¡Ú</font></p> </div></td> </tr> </table> <table width="81%" height="100" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="100"><ol> <div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font> </div> </ol></td> </tr> </table> <p> </p> </body> </html> .

1 0

Delivery Status Notification (Failure)
by postmaster＠emrxeag2iicloo2 22 May '03

22 May '03

This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. zope(a)zope.org 550 (see RFC 2822, sections 3.6.5, 2.2.1) ING 250 HELP ZE 250-DSN 250-ONEX 250-ETRN 250-XUSR 250 HELP 111(a)dreamx.net> ecord) assigned. addresses which 220 have no reverse-DNS (PTR record) assigned. ddresses which 220 have no reverse-DNS (PTR record) assigned. which 220 have no reverse-DNS (PTR record) assigned. ions from IP addresses which 220 have no reverse-DNS (PTR record) assigned.

1 0

Re: [Zope] zope stopp accept http requests
by Gilles 22 May '03

22 May '03

Hello How do you check that zope is not hanged? My experience is that when zope doesn't respond anymore it's because all the threads are busy. Gilles ----- Original Message ----- From: <einar(a)hf.ntnu.no> To: <zope(a)zope.org> Sent: Thursday, May 22, 2003 4:51 AM Subject: [Zope] zope stopp accept http requests > > > > > We have big problems with zope stopping to accept http-requests. > > Zope stalls after a few minutes of running, and we simply cannot determine the > cause. It does'nt crash or hangs, it just stops accepting http requests. > > We have to stop it manually and start it again to continue, and then it will > stopp responding after awhile again. The time between starting zope and the lack > of response can vary with from 5 seconds to up to 10 minutes. > > Our zope lives behind apache with proxypass. > When turning off apache zope does not hang, but this could be because of the > lost traffic (since no one but those who uses the port 8080 directly reaches > zope) > > Any ideas? > > > The > > _______________________________________________ > 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 ) >

3 2

kerberos authentication
by Heimo Laukkanen 22 May '03

22 May '03

> Is there any way to authenticate users using kerberos? Haven't seen / needed, but in general what ever your authentication need is - check out first the exUserFolder, and what plugins it has. exUserFolder has some neat-o-plugins and you can also extend it with your own plugins. -huima

2 1

Need help!! Compile error "ld: fatal: library -lmysqlclient: not found"
by Tri Quach 22 May '03

22 May '03

Hello, Below is my compile output. What shoud I do to fix this error? Thank you for your help, Tri. leka(root)# /usr/local/Zope-2.5.0/Zope-2.5.0-solaris-2.6-sparc/bin/python setup.py build running build running build_py not copying CompatMysqldb.py (output up-to-date) not copying _mysql_exceptions.py (output up-to-date) not copying MySQLdb/__init__.py (output up-to-date) not copying MySQLdb/converters.py (output up-to-date) not copying MySQLdb/connections.py (output up-to-date) not copying MySQLdb/cursors.py (output up-to-date) not copying MySQLdb/sets.py (output up-to-date) not copying MySQLdb/times.py (output up-to-date) not copying MySQLdb/constants/__init__.py (output up-to-date) not copying MySQLdb/constants/CR.py (output up-to-date) not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying MySQLdb/constants/ER.py (output up-to-date) not copying MySQLdb/constants/FLAG.py (output up-to-date) not copying MySQLdb/constants/REFRESH.py (output up-to-date) not copying MySQLdb/constants/CLIENT.py (output up-to-date) running build_ext building '_mysql' extension skipping _mysql.c (build/temp.solaris-2.8-sun4u-2.1/_mysql.o up-to-date) gcc -shared build/temp.solaris-2.8-sun4u-2.1/_mysql.o -L/usr/local/mysql/lib/libmysqlclient.a -lmysqlclient -lz -o build/lib.solaris-2.8-sun4u-2.1/_mysql.so ld: fatal: library -lmysqlclient: not found ld: fatal: File processing errors. No output written to build/lib.solaris-2.8-sun4u-2.1/_mysql.so collect2: ld returned 1 exit status error: command 'gcc' failed with exit status 1

2 1