September 2002 - Zope

SEQUENCES on SAPDB
by Vitor Varalonga 11 Sep '02

11 Sep '02

Hi! Sorry for the somehow off-topic subject, but the SQL reference doc I've downloaded from SAPDB website hasn't been that helpful. I want to create a auto-incremented primary key on a table. On SQL Server it's easy since you can set an attribute to auto-increment. On Interbase it's not that easy: you have first to create a generator and then a trigger that will increment that generator on each insertion. How can I do that on SAPDB? I suspect it might have something to do with SEQUENCES, so I've just created one, but now I need to associate it with the primary key. How can I do it? Using a trigger? Sorry, but the SAPDB SQL doc is anything but "user-friendly". thanks, Vitor Varalonga

1 0

CMF Portal Catalog issue(Please Reply urgently)
by Ashish Gautam 11 Sep '02

11 Sep '02

Hello, I have a problem with ZCatalog in my CMF site. Lately i checked that the objects indexed by Portal_Catalog has increased by a very large extent. When i checked i found that the Portal Catalog has started indexing the python sripts and Page Template files which form a part of the code for my site. I dont know why these entries have started coming up. Any ideas Regards, Yaser

1 0

DTML call to self
by michael.ta�ag 11 Sep '02

11 Sep '02

Hi! I'm making an form which asks a user for his user name, password and password confirmation. If one of the boxes is empty or he placed a wrong value the page should return an error message and the form again. So I guess it's going to be a call to itself. But, how do you do that in DTML? Also, how do you call a DTML page inside DTML and inside a Python script? THANKS!!! __________________________________________________ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute

2 1

DCOracle compilation problem
by Tomasz Rutkowski 11 Sep '02

11 Sep '02

Hi, Recently i downloaded the sources of DCOracle2, and i cannot install (compile) it under my Linux. I use gcc ver. 2.96-98 compiler and python2.1 We would like to use it for Oracle 8.1.7 under Linux. But the compilation fails, and it seems, that there are some incompatibilities among the Oracle libraries and DCOracle2. I attached the error message output in the file (out.txt). Could anybody tell me what is wrong ? Have you ever compiled DCOracle2 for Oracle 8.1.7 under linux (may be it is only the compiler, libraries at my box problem)? I would be very appreciated for any help from your side. Regards Tomasz

1 0

Fwd: FWD: Your DVDs delivery.
by Patricia 11 Sep '02

11 Sep '02

Your friend has send you this offer. ------------------------------------------------------- Trial signup limited seats available. To show you how keen we are to deliver the DVDs, there is NO shipping! View unlimited DVDs. Free Trial. -------------------------------------------------------- Why buy retail? Start viewing unlimited DVDs! -------------------------------------------------------- Your F-r-e-e trial is not a dream. Grab your favorite moviews in DVD now! http://www.giftdvd.com/cgi-bin/offer.cgi?affid=892 (Offer with NO SHIPPING valid to U.S. residents only) -------------------------------------------------------- YES, F.R.E.E DVDs Trial Membership. -------------------------------------------------------- Signup for F.R.E.E and start watching unlimited DVDs. Your trial is totally F.R.E.E, and you can cancel anytime, for any reason, with no obligation. http://www.giftdvd.com/cgi-bin/offer.cgi?affid=892 -------------------------------------------------------- Signup for F-R-E-E and start watching unlimited DVDs. -------------------------------------------------------- Your trial is all F-R-E-E, and you can cancel anytime, for any reason, with no obligation. http://www.giftdvd.com/cgi-bin/offer.cgi?affid=892 (No shipping within the US only, exclude Canada) Patricia GiftDVD.com Customer Support support(a)giftdvd.com ------------------------------------------------------- This Tell-a-Friend service is available at GifvDVD.com To invite your friends to join GiftDVD, visit: http://www.giftdvd.com/cgi-bin/offer.cgi?affid=892 To unsubscribe, email: unsubscribe(a)giftdvd.com To make suggestions, email: support(a)giftdvd.com -------------------------------------------------------

1 0

ZOPE 2.6 / 2.7
by David Marko 11 Sep '02

11 Sep '02

Dones anybody know when ZOPE 2.6 is planned to be released? Regards, David Marko (IT specialista/konzultant, Certified Lotus Specialist) -------------------------------------------------------------------------------------------------------- TCL-DigiTrade s.r.o., areal VUHZ, 739 52 Dobra 240 tel. 0658 601 767, fax. 0658 601 754 http://www.tcl-digitrade.com http://www.lnscan.com

1 0

Windows vs. Linux
by Daryl Middleton 11 Sep '02

11 Sep '02

I am interested in developing with Zope. Is there a distinct advantage as to using Windows or Linux as a desktop system for development. I am willing to use either system. Thank You.

25 34

Zope on local machine and ZSynched to a server - could it be like Radio Userland?
by Heimo Laukkanen 11 Sep '02

11 Sep '02

Blob, I believe in throwing ideas and dreaming together. After seeing Andy's Plone windows installer I began to wonder, would it be possible in future to have content providers running local Zope instances and replicate with xml-rpc to the web server. And with possible I mean as easy to use as radio. First features would be. 1) Easy to setup on local machine, doubleclick to setup, click clickety click and local service is up and running 2) Person can start to create local content right away, wether it is a blog or articles or news items 3) When ready and connected to the net, user can upload and send selected files or changes to designated server either published right then or possibly to a person's own Inbox from which user can select to publish them This would make the authoring experience same also offline. It would be nice to be able to be offline with laptop, make the content and layouts ready and just send everything to the server when connected. Think about email, while offline you can do the emails ready and then just upload your 'outbox' to the email server. This would be enough for offline editing - either for people who depend on dialup connections afrom home or are doing reportage for example on the run via GSM or GPRS. ( For you americans GPRS is packet switched mobile phone network, which allows also higher bandwith than normal GSM data ). Why am I interested in this idea? Well first of all the authoring on the run. With same tools and interfaces as online. Otherwise the content creation tools would be - most likely MS Office or similar. For content creators I believe it would be best, if the processes and tools are same - no matter where you do your publishing, online or offline. In a year or two or three or whenever - it would be nice to have something like Lotus Notes' replication, meaning user could download snapshots / replicate parts from the server to local machine. Edited objects would be replicated back to the server and edit conflicts resolved. This kind of replicated storage would kick ass and would make possible to create applications that could be taken to field within laptops and then again replicated to main database when back at the office. Any thougths. -- Heimo Laukkanen Oy Fountain Park Ltd Hämeentie 153 B, 00560 Helsinki, Finland tel. +358 9 777 68 161, gsm +358 40 759 1110, fax +358 9 777 68 100 http://www.fountainpark.org

2 3

(no subject)
by James White 11 Sep '02

11 Sep '02

I need help with using zpt's to provide arguments to Z Sql methods.

2 1

ZCGI errors Please help
by Mark Poole 10 Sep '02

10 Sep '02

Hello, I have configured my zope site according to this doc: http://www.zope.org/Members/Mamey/PHP Which is a doc on how to run cgi¹s within the zope site to maintain consistency across my site. ³Serve PHP/Perl within Zope² I have the scripts running called ³DirectToCGIContent² and ³ServeCGIContent² similar to what the scripts recommend (my cgi¹s are perl). I have installed a siteroot at the local directory ( user home dir) because I am only running Zope on port 80 and apache running on port 8080. My ultimate goal is to be able to run perl/cgi scripts inside zope with one look and feel across the site no matter if I am running cgi¹s or zope. I am running the latest ver of Plone , CMF 1.3 If it matters I am running zope on Solaris 9. Here are my scripts: DirectToCGIContent script: from string import join def DirectToCGIContent ( self ): if self.REQUEST.path: # Build up a list of what is contained in self.REQUEST.path since # you are going to redirect the user to /CGIContent/index_html. Start # by adding the way you can access the CGI tree outside of Zope originalRequestPath = ['http://24.x.x.x:8080/cgi-bin/'] # is the user asking for a cgi script? if self.REQUEST.path[0][-5:] == '.cgi': # pop paths of REQUEST.path until its empty while self.REQUEST.path: # Remember the path components before you pop them originalRequestPath.append( self.REQUEST.path[-1] ) self.REQUEST.path.pop() # Is there a query string being passed to the script also? if self.REQUEST.environ['QUERY_STRING']: originalRequestPath[ -1 ] = originalRequestPath[ -1 ] + '?' \ + self.REQUEST.environ['QUERY_STRING'] # Create a full url to pass to index_html cgiScript = join( originalRequestPath, '/' ) # self.REQUEST.path is now empty so the user is going to be # directed to /CGIContent/index_html. That method needs to # know what the original request is, so pass it a REQUEST # variable self.REQUEST.set('cgiScript', cgiScript) # you also may want to redirect image requests to the CGI tree elif self.REQUEST.path[0][-3:] in ['gif', 'png']: while self.REQUEST.path: originalRequestPath.append(self.REQUEST.path[-1]) self.REQUEST.path.pop() # This is an image, so give it to a DTMLMethod that will # just serve up images self.REQUEST.path.append('ServeImageInCGITree') self.REQUEST.set('imagePath', join(originalRequestPath, '/')) ServeCGIContent script: def ServeCGIContent(url="http://24.x.x.x:8080/cgi-bin/" , username=None , Passwor d=None): return Client.call (url,username,password)[1] INDEX_HTML <standard_html_header> <dtml-if "REQUEST.has.key('cgiScript')"> < dtml-var "ServeCGIContent(REQUEST['cgiScript'])"> </dtml-if> <standard_html_footer> TRACEBACK ERROR section: Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: CGIContent) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: index_html) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: index_html) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in __call__ (Object: index_html) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: index_html) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: REQUEST.has.key('cgiScript')) (Info: REQUEST) File <string>, line 2, in f File /usr/local/zope/lib/python/AccessControl/DTML.py, line 29, in guarded_getattr (Object: index_html) File /usr/local/zope/lib/python/AccessControl/ZopeGuards.py, line 47, in guarded_getattr File /usr/local/zope/lib/python/ZPublisher/HTTPRequest.py, line 853, in __getattr__ AttributeError: (see above) Z2.log output: HTTP/1.1" 200 369 "http://24.x.x.x/custb/CGIContent/index_html" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" INDEX.HTML-Source-output <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>U-View - CGIContent</title> <base href="http://24./custb/CGIContent/standard_error_message" />  <link rel="Stylesheet" type="text/css" href="http://24./custb/ploneBasicNS.css" /> <link rel="Stylesheet" type="text/css" href="http://24./custb/ploneStructureNS.css" /> <link rel="Stylesheet" type="text/css" href="http://24./custb/ploneWidgetsNS.css" /> <link rel="Stylesheet" type="text/css" href="http://24./custb/ploneCalendarNS.css" />  <style type="text/css" media="all"> @import "http://24./custb/ploneBasic.css"; @import "http://24./custb/ploneStructure.css"; @import "http://24./custb/ploneWidgets.css"; @import "http://24./custb/ploneCalendar.css"; </style>  <link rel="stylesheet" type="text/css" media="print" href="http://24./custb/plonePrint.css" />  <link rel="stylesheet" type="text/css" media="projection" href="http://24./custb/plonePresentation.css" /> <meta http-equiv="imagetoolbar" content="no" />   <meta http-equiv="pragma" content="no-cache" /> <script type="text/javascript" src="http://24./custb/plone_javascripts.js"></script> <script language='javascript' type='text/javascript' > function formtooltip(el,flag){ elem = document.getElementById(el); if (flag) { elem.parentNode.parentNode.style.zIndex=1000; elem.parentNode.parentNode.style.borderRight='0px solid #000'; // ugly , yes .. but neccesary to avoid a small but very annoying bug in IE6 elem.style.visibility='visible'; } else { elem.parentNode.parentNode.style.zIndex=1; elem.parentNode.parentNode.style.border='none'; elem.style.visibility='hidden' }; } </script> </head> <body> <div> <div class="top"> <div class="searchBox"> <form name="searchform" action="http://24./custb/search"> <input id="searchGadget" name="SearchableText" type="text" size="20" /> <input class="context" type="submit" value="Search" /> </form> </div> <a href="http://24./custb"> <img src="http://24./custb/logo.png" class="logo" alt="Plone" border="0" /> </a> </div> <hr size="" class="netscape4" /> <div class="tabs"> <a href="http://24./custb" class="plain"> Welcome </a> <span class="netscape4">·</span> <a href=" http://24./custb/news" class="plain"> News </a> <span class="netscape4">·</span> <a href=" http://24.2/custb/helpdesk/login" class="plain"> Helpdesk </a> <span class="netscape4">·</span> <a href=" http://24./custb/CGIContent/scan_results" class="plain"> Scan Results </a> <span class="netscape4">·</span> <a href=" http://24./custb/CGIContent/netstat" class="plain"> Network Status </a> <span class="netscape4">·</span> </div> <div class="personalBar">  <span>you are not logged in</span> <a href="http://24./custb/login_form"> <img src="http://24./custb/linkOpaque.gif" alt=">" border="0" /> Login </a> <a href=" http://24./custb/join_form"> <img src="http://24./custb/linkOpaque.gif" alt=">" border="0" /> Join </a> </div> <hr size="" class="netscape4" /> <div class="pathBar"> You are here: <span> <a href="http://24.x.x.x/custb">home</a> <strong> » </strong> </span> <span> <strong>CGIContent</strong> </span> </div> <hr size="" class="netscape4" /> </div> <table class="columns"> <tbody> <tr> <td class="left"> <table class="box" summary="Navigation" cellpadding="0" cellspacing="0"> <thead> <tr><th>Navigation</th><th class="empty"> </th></tr> </thead> <tbody> <tr class="odd"> <td colspan="2"> <strong>CGIContent</strong> </td> </tr> <tr class="odd"> <td colspan="2"> <a href="http://24.x.x.x/custb"> <img src="http://24.x.x.x/custb/linkTransparent.gif" alt=">" border="0" /> Up one level</a> </td> </tr> </tbody> </table> </td> <td class="main"> <div class="document"> <div> <div> <div> <h1 i18n:translate="">Site error</h1> <p i18n:translate=""> This site encountered an error trying to fulfill your request. The errors were: </p> <div class="group"> <span class="legend" i18n:translate="">Error Details</span> <div class="row"> <div class="label" i18n:id="error_type"> Error Type </div> <div class="field">AttributeError</div> </div> <div class="row"> <div class="label" i18n:id="error_message"> Error Message </div> <div class="field"></div> </div> <div class="row"> <div class="label" i18n:id="error_value"> Error Value </div> <div class="field">has</div> </div> </div> </div> </div> </div> </div> </td> </tr> </tbody> </table> <hr size="" class="netscape4" /> <div class="footer"> Ltd. Copyright © 2001-2002. All rights reserved.<br /> <hr class="netscape4" /> <strong class="netscape4"> If you can read this text, it means you are not experiencing the U-View Portal design at its best. </strong> </div> </body> </html> <PRE> Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: CGIContent) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: index_html) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: index_html) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in __call__ (Object: index_html) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: index_html) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: REQUEST.has.key('cgiScript')) (Info: REQUEST) File <string>, line 2, in f File /usr/local/zope/lib/python/AccessControl/DTML.py, line 29, in guarded_getattr (Object: index_html) File /usr/local/zope/lib/python/AccessControl/ZopeGuards.py, line 47, in guarded_getattr File /usr/local/zope/lib/python/ZPublisher/HTTPRequest.py, line 853, in __getattr__ AttributeError: (see above) </PRE> --0-432207886-1031631482=:16387-- The CGIContent redirects are what I want to happen , but all the scripts are not there yet , only one script is there from the portal menu. Any help would be greatly appreciated! Thanks, Mark

1 0