- Zope - Zope lists

SQL7 connector?
by Loren Stafford 17 Jan '00

17 Jan '00

-----Original Message----- From: Loren Stafford [mailto:lstafford@icompression.com] Sent: Monday, January 17, 2000 10:31 To: ozric Subject: RE: [Zope] SQL7 connector? One possibility you might consider is to run a secondary copy of Zope on the NT server where it can use the win32 ODBC adapter. Then access the secondary Zope from your primary Zope on Linux using client.py (as outlined in the How-To http://www.zope.org/Members/lstaffor/ZClientMethod. This is what I do to retrieve data from MS Access applications on NT. -- Loren > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of ozric > Sent: Saturday, January 15, 2000 06:58 > To: Zope List > Subject: [Zope] SQL7 connector? > > > Does anyone know if and/or how to connect to a MS SQL7 database? > I am still trying to make my Dept see the light and let me set up a > production server using Zope and Linux. The biggest problem is that we > and currently moving from Sybase on HPUX to SQL7 on NT (don't say > it.. please). > I need to reassure them that Zope will be able to get to the SQL7 > server now or > sometime soon. I am going to use MySQL as the demo but they are > just going to > say "what about the SQL7 stuff". Any help or advice would be splendid. > > -- > "...I'm not one of those who think Bill Gates is the devil. > I simply suspect that if Microsoft ever met up with the devil, > they wouldn't need an interpreter." > -- Nick Petreley > > Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email > address may not be added to any commercial mail list with out my > permission. Violation of my privacy with advertising or SPAM will > result in a suit for a MINIMUM of $500 damage per incident. > > _______________________________________________ > Zope maillist - Zope(a)zope.org > 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 ) >

1 0

Custom Property Sheet Look
by James W. Howe 17 Jan '00

17 Jan '00

I've been playing around a little bit with ZClasses. I've created a ZClass with a small number of properties. When I create an instance of my ZClass I can edit properties via a standard property editing page. If I don't like the look of this page, how easy is it to develop a custom property page for my ZClass? What and where would I need to make changes? Thanks. James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey: http://ic.net/~jwh/pgpkey.html Ann Arbor, MI 48103

2 1

Where does zope store temporary files?
by Farzad Farid 17 Jan '00

17 Jan '00

When I do a file upload to a Zope method where is the temp file stored on the server? /tmp, /var/tmp, or the directory containing Data.fs? I need to know this because the system we're setting up will receive large file uploads and I need to dimension the partitions correctly. Thanks -- Farzad FARID <farzy(a)via.ecp.fr> Ingénieur Informatique Libre Alcôve - http://www.alcove.fr/

1 0

dtml-return question
by James W. Howe 17 Jan '00

17 Jan '00

I want to add a DTMLMethod to a folder which will be used to return a subset of the items in the folder. I've written a method called allNewsArticles which looks like this: <dtml-return "objectValues('NewsArticle')"> I have a method in another folder which references the result of this method and it looks like this: <dtml-in allNewsArticles> <... do stuff here...> </dtml-in> When I execute the DTMLMethod containing the code above, I get no output for the dtml-in. However, if I do the following in the method above (instead of using the allNewsArticles method), I do get output: <dtml-in "PARENTS[1].objectValues('NewsArticle')"> <... do stuff here ...> </dtml-in> I don't want to use the PARENTS approach because I don't know for sure that the immediate predecessor will have the news articles. Is there a way for a DTMLMethod to return a collection of items which are usable by a dtml-in tag? Thanks. James W. Howe AppNet Inc. 650 Avis Dr. Suite 100 mailto:james.howe@appnet.com Ann Arbor, MI 48108 http://www.appnet.com

4 3

Re: [Zope] caching problem.
by Hung Jung Lu 17 Jan '00

17 Jan '00

jerome alet <ale-(a)unice.fr> wrote: >unfortunately I'm facing a caching problem which doesn't seem to stop if I >stop then relaunch Zope (standalone) or if I try to flush cache with the >Zope menu. Have you tried holding the SHIFT key and then clicking on the RELOAD button of your Netscape? On Internet Explorer, it is CONTRL key and the REFRESH button. Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

caching problem.
by Jerome ALET 17 Jan '00

17 Jan '00

Hi there, I'm just beginning to use Zope, and I'm making some tests with it since yesterday only. unfortunately I'm facing a caching problem which doesn't seem to stop if I stop then relaunch Zope (standalone) or if I try to flush cache with the Zope menu. Here's what I do, maybe I'm wrong: I define a dtml method, let's call it my_method this way: ------- my_method ------- <dtml-var standard_html_header> <dtml-var my_logo> <p> Here's some HTML text, but if you want you can view the <a href="my_method_pdf">PDF version</a> </p> <dtml-var standard_html_footer> ------- my_method ------- and I define a Zpdfdocument this way: ------- my_method_pdf -------  and <dtml-var> ? I've tried to repeat the database example contained in QuickStart and it didn't work until I replaced all  with <dtml-var> . thanks for your time. Jerome ALET - alet(a)unice.fr - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

2 1

Re: [Zope] dtml-return question
by James W. Howe 17 Jan '00

17 Jan '00

At 12:24 PM 1/17/00 -0500, you wrote: >On Mon, 17 Jan 2000, James W. Howe wrote: > > > I want to add a DTMLMethod to a folder which will be used to return a > > subset of the items in the folder. I've written a method called > > allNewsArticles which looks like this: > > > > <dtml-return "objectValues('NewsArticle')"> > > > > I have a method in another folder which references the result of this > > method and it looks like this: > > > > <dtml-in allNewsArticles> > > <... do stuff here...> > > </dtml-in> > > > > When I execute the DTMLMethod containing the code above, I get no output > > for the dtml-in. However, if I do the following in the method above > > (instead of using the allNewsArticles method), I do get output: > > > > <dtml-in "PARENTS[1].objectValues('NewsArticle')"> > > <... do stuff here ...> > > </dtml-in> > > > > I don't want to use the PARENTS approach because I don't know for sure >that > > the immediate predecessor will have the news articles. Is there a way for > > > a DTMLMethod to return a collection of items which are usable by a > > dtml-in tag? > >[...] > >I think your DTML Method (allNewsArticles) is getting acquired into the >folder that is calling it, which probably contains no news items. Without >seeing more of your site structure, I, unfortunately, can't suggest how to >fix it. > >That's my guess, anyway. > > > James W. Howe > >--Jeff What you are saying makes some sense now that I think about it. My URL is something like this: /RootTop/NewsSite/20001001/CurrentIssue Both 20001001 and CurrentIssue are folder objects. The 20001001 contains news articles. The CurrentIssue contains information on how to format news articles. What I wanted to have happen is I wanted my code in CurrentIssue to be able to dynamically get a collection of NewsArticle objects which it could then format into a table of contents. I wanted to invoke a method which I new would be implemented by an object higher in the acquisition tree, but I wanted the invoked method (allNewsArticles) to generate a list of articles contained in the folder which defined the allNewsArticles method itself. What seems to be happening, based on my limited knowledge of Zope plus your comments above, is that my CurrentIssue is acquiring the allNewsArticles method and then executing it over the CurrentIssue contents, rather than the 20001001 contents. Since CurrentIssue has no NewsArticles, there is nothing to loop over. Does this sound correct? What I want to be able to do is ask an object to answer some results from the perspective of the object being asked. However, I don't know (or want to know) where in the acquisition hierarchy this object resides. I want to be able to send a message out into the acquisition ether, as it were, and if an object responds to the message I want that object to execute it and return its results. Of course, I'm open to other solutions as long as I can keep the knowledge of how to format an object separate from the knowledge of the content. Thanks James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey: http://ic.net/~jwh/pgpkey.html Ann Arbor, MI 48103

1 0

RE: [Zope] dtml-return question
by David Salgado 17 Jan '00

17 Jan '00

>When I execute the DTMLMethod containing the code above, I get no output >for the dtml-in. However, if I do the following in the method above >(instead of using the allNewsArticles method), I do get output: > ><dtml-in "PARENTS[1].objectValues('NewsArticle')"> > <... do stuff here ...> ></dtml-in> I had a problem which might be similar -- instead of the returned value, my reference to the method was dropping the source-code of the method into the calling script! My problem went away when I wrapped the dtml-in in a dtml-let. i.e. <dtml-let foo=allNewsArticles> <dtml-in foo> <... do stuff here...> </dtml-in> </dtml-let> ...sorted my problem, but YMMV. HTH David

1 0

importing Site Summaries
by Timothy Wilson 17 Jan '00

17 Jan '00

Hi everyone, I've got a problem using Site Summary because of a problem with a URL I'm trying to retrieve, not directly because of the Site Summary product. I'm trying to get some of the news feeds from moreover.com, but their URLs look like: http://h.moreover.com/cgi-local/page?index_techlatest+rss The '?' in the URL really confuses things when I try to update the Site Summary instance using the prescribed method of calling importFromURL like this: http://www.mysite.com/mySummary/importFromURL?url=http://h.moreover.com/cgi… Evan Simpson suggested creating a method in the directory where I keep my Site Summary instances that looks like: <dtml-with moreover.com_techlatest) <dtml-call expr="importFromURL(this(), REQUEST, url='http://h.moreover.com/cgi-local/page?index_techlatest+rss')"> </dtml-with> and then my updating script (using cron) would be: #!/bin/sh lynx -source http://localhost/headlines/grabNews Unfortunately, doing what I just described doesn't work and produces the following traceback: Traceback (innermost last): File /usr/local/src/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/src/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/src/Zope-2.1.2-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/src/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/src/Zope-2.1.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: grabNews) File /usr/local/src/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: grabNews) File /usr/local/src/Zope-2.1.2-src/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: grabNews) File /usr/local/src/Zope-2.1.2-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: grabNews) File /usr/local/src/Zope-2.1.2-src/lib/python/DocumentTemplate/DT_With.py, line 132, in render (Object: moreover.com_techlatest) KeyError: (see above) Does anyone have any ideas? Perhaps you've gotten this to work with another strategy. Thanks. -Tim -- wilson(a)visi.com <dtml-var pithy_quote>

1 0

New Roles and New ZClasses...
by Darren Boyd 17 Jan '00

17 Jan '00

Hi, I have a Document Repository 'Product' that looks like this: (Made from ZClasses...) DRBase (ZObject, _ZClass_for_CatalogAware, ZObjectManager, _ZClass_for_Folder) DRDoc (ZObject, _ZClass_for_CatalogAware, _ZClass_for_File) The DRBase subobjects include 'file' and 'Document' Note, Document is a DRDoc. - I create a folder called 'test' under the root folder. - In test, I create a Document Repository called docs. - In the folder test, I remove 'acquire permissions' for everything. - In the folder test, I have a user folder (the default acl_users). - In that user folder I create a new role called Project Manager. - I give the Project manager every possible permission. - I create a user (dboyd) in the User Folder, and make dboyd a project manager. I now suspect dboyd should be able to do everything. However, dboyd cannot do the following: - add a new document repository to the folder test. - add a DRDoc to the Document Repository called docs. dboyd can add a file to the Document Repository called docs. Anyone know what I did wrong? Thanks, Darren -- Darren Boyd http://www.dbebiz.com/ .................................................................... Don't worry about people stealing your ideas. If your ideas are any good, you'll have to ram them down people's throats. - Howard Aiken

1 0