June 2000 - Zope - Zope lists

images in access database
by Terry Kerr 02 Jun '00

02 Jun '00

Hi, I would like to be able to have gifs/jpgs stored in an MS access database and then pull the out using zope and display them in rendered documents. I am completely new to access. I have successfully installed the ODBCDA into zope, and are able to connect to an access database and pull ordinary text data out of tables. I have created a table in access with a column of type 'OLE object' and put a gif image in as data. This is the only way I know how to get an image into the table. The problem I think with this is that it is a link to the gif on the HDD, and doesn't actually have the data in the table? Anyway, when I pull the data out of the table from zope, access puts a header and footer around the gif binary data, and hence a simple <dtml-var blah> wont work to display the image. Has anyone else every pulled images from an access database. Will I have to write a method to strip the header and footer from the returned data before displaying the gif? terry. -- ----------------------------- Terry Kerr (terry(a)adroit.net) Adroit Internet Solutions http://www.adroit.net/ 03 9563 4461 0414 938 124

1 0

Python and Zope Question
by Scott Burton 01 Jun '00

01 Jun '00

Major newbie here. I am wanting to create a python method that iterates over items in a folder object in Zope. I am struggling with how to access objects in the ZODB in python. Here's the script in the simplest form. for x in folderObject : return x I am going to do things to the items once I have access to them, I just can't figure out how to reference ZODB objects in Python. I have done searches on the zope site and looked through the zdp but could not find anything. I am calling the method from a <DTML-var pythonMethodName> with no args. My assumption is that since this is a Python Method, it has access to the ODB structure without having to pass it anything. Am I wrong here? Thanks, Scott B. Voice: 661-325-0288 Business: www.launchpoint.net Weblog Portal: www.blogthis.com

3 2

RE: [Zope] Strange Zope behavior/Instability (Zope going down)
by Marcus Collins 01 Jun '00

01 Jun '00

> -----Original Message----- > From: Rob Sporleder [mailto:rsporleder@openave.com] > Sent: 31 May 2000 21:55 > To: Jason Spisak > Cc: zope(a)zope.org > Subject: RE: [Zope] Strange Zope behavior/Instability (Zope > going down) > All of the python z2.py processes are still running. I > haven't checked if I can get to it using http://localhost. The > server is offsite. However, I did try an http get from the command > line and it did not respond. Hi! I had similar problems some time ago (which have not been entirely resolved -- I'm still trying to tie them down -- but now seem to be less frequent), which seemed to be related to particular page accesses. Are you able to identify from your logs any pages/methods that have repeatedly been called prior to Zope going down? See the Wiki at: http://www.zope.org/Members/tseaver/Projects/HighlyAvailableZope/TwistingInT heWindProblems and take a look at DiagnosingHangProblems for some suggestions. Perhaps you could post the details of your own situation there as well? hth, -- Marcus

2 1

RE: [Zope] ODBC connection to Oracle
by Theodore Patrick 01 Jun '00

01 Jun '00

We have had mixed results depending on the ODBC driver you use to make your DSN. Here is what I found. 1. Microsofts ODBC Driver for ORACLE on NT4.0, NT2000 -CREATE DSN -OK -ZOPE ZODBC -OK -ZSQL METHODS -OK 2. ORACLE ODBC DRIVER on NT 4.0, Especially NT2000 -CREATE DSN -OK -ZOPE ZODBC CONNECTION -OK Visually! On First Query it will break. -ZSQL METHODS -Broken When in doubt use the MICROSOFT DRIVER for ODBC! That is our rule. You will also find that this same problem exists in using ORACLE drivers when viewing databases via ACCESS. It will typically crash Access and potentially more. Theodore E. Patrick Ishophere.com - Indigo Networks -----Original Message----- From: vsbabu(a)mamlegault.mamlegault.com [mailto:vsbabu@mamlegault.mamlegault.com] Sent: Thursday, June 01, 2000 12:16 PM To: zope(a)zope.org Subject: [Zope] ODBC connection to Oracle Hi there, Has anyone tried connecting using ZODBC from a WinNT machine to an Oracle database? The ODBC connection works. But when I create a ZODBC connection from ODBC dsn, it doesn't. I give the connect string as DSN userid password as mentioned under ZODBC add screen... Any help? Thanks Babu http://vsbabu.csoft.net _______________________________________________ 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

Zope on Windows NT
by Luis Cortes 01 Jun '00

01 Jun '00

Hello, Does anybody know how to change the Port that Zope uses on Windows NT when it is installed as a Service??? I know how to change it when it is installed as standalone - but that doesn't work when I run it as a service. Thanks for your help, Luis.

2 1

How do I detect in DTML when I'm in the management interface?
by Jason Byron 01 Jun '00

01 Jun '00

I have a ZClass that I would like to be able to create using the management interface and in DTML from the users end with the same DTML script. I believe I need something like this to get it to work: (if in management interface) <dtml-call "create_my_zclass(_.None, _)"> (else) <dtml-with "manage_addProduct['my_zclass']"> <dtml-call "create_my_zclass(_.None, _, NoRedir=1)"> </dtml-with> and create_my_zclass has this code in it: <dtml-with "my_zclass.createInObjectManager(REQUEST['id'], REQUEST)"> <dtml-call "propertysheets.my_zclass_info.manage_editProperties(REQUEST)"> </dtml-with> ... How do I create the first if else? Is there a better/easier way of doing this? __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

1 0

ODBC connection to Oracle
by vsbabu＠mamlegault.mamlegault.com 01 Jun '00

01 Jun '00

Hi there, Has anyone tried connecting using ZODBC from a WinNT machine to an Oracle database? The ODBC connection works. But when I create a ZODBC connection from ODBC dsn, it doesn't. I give the connect string as DSN userid password as mentioned under ZODBC add screen... Any help? Thanks Babu http://vsbabu.csoft.net

1 0

<dtml-tree> <div> issue from this morning.
by Patrick Keane 01 Jun '00

01 Jun '00

The problem is the order. Netscape apparently likes to see URLS like http://www.my.com/this.html#foo?var=data not http://www.my.com/this.html?var=data#foo It chokes on the first, and is happy with the 2nd. IE is happy with either. Any chance this can be checked in as a revision to the tree code to be tested and confirmed? PS - Which is the standard format of the two (as per ww3 or whatnot?) pk

1 0

Re: [Zope] something missing in my Oracle setup?
by Justin Sheehy 01 Jun '00

01 Jun '00

I wanted to thank Jens and Anthony for the pointers. I ended up doing the full server install. The only other thing required was to put $ORACLE_HOME/lib in my ld.so.conf and run ldconfig. Things seem to work fine now, though I haven't really hammered on DCOracle yet. Thanks again, -Justin

2 1

RE: [Zope] ANN: Perl For Zope
by Chris McDonough 01 Jun '00

01 Jun '00

This is pretty silly. > Very soon we'll be forced, 'cause most Products will be in > Perl (yse, > I've read the FAQ and saw "no Perl Products"; it's temporary, > mark you).

14 18