December 1999 - Zope

RE: [Zope] sequence-item and ZSQL
by Michel Pelletier 02 Dec '99

02 Dec '99

> -----Original Message----- > From: Anders Gaarsdal Holst [mailto:anders@colorweb.dk] > Sent: Thursday, December 02, 1999 3:54 PM > To: zope(a)zope.org > Subject: [Zope] sequence-item and ZSQL > > > Hi! > > > I have also tried using another var for transferring to the > ZSQL method. > > <dtml-in have> > <dtml-call "REQUEST.set('movieID', sequence-item)"> > <dtml-call change_have_want_sql> > </dtml-in> > > But Zope apperently cannot figure the " - " out in > "sequence-item", and > therefore cannot set this new var "movieID". What is the syntax for > writing this var? <dtml-call "REQUEST.set('movieID', _['sequence-item'])"> -Michel

1 0

Add Property to DTML Documents
by Steve Rauch 02 Dec '99

02 Dec '99

I uploaded 200 existing html files to a Zope folder as DTML Documents. THe files were named with a pre-Y2K scheme ala: hb980712.html I want to add a date Property that in this example would be 1998/07/12 I added a few dates manually when I decided to create a simple External Method called "hbdate" that gets self.id() and slices it and appends the 19 and the /s. In my article folder I have DTML Method that looks like this:  <dtml-unless date> <dtml-if "meta_type=='DTML Document'"> <dtml-var hbdate> </dtml-if> </dtml-unless>  and it produces the appropriate date value for all the DTML Documents. When I replace the <dtml-var hbdate> with: <dtml-call "manage_addProperty('date', hbdate, 'date')"> I get following Zope Error: Error Type: Invalid Date-Time String Error Value: In viewing the source of Zope frame I can see the values for the files, but I also see a blank double space before the first value as if the external method is evaluating some extra document that does not produce a value. What have I done wrong? Steve Rauch srauch(a)u.wahington.edu

1 0

ANNOUNCE: Zope Hispano: Resources for Spanish speaking Zope users and developers developers
by Eduardo Fernandez Corrales 02 Dec '99

02 Dec '99

Hello, I have created a website http://zope.sistelnet.es/ with resources of interest for Spanish speaking Zope users and developers. It is a site in Spanish that runs Squishdot. I hope it serves as a meeting point for people Spanish speaking poople interested in Zope. It will provide, news, resources and documentation in Spanish, Zope powered sites in Spanish, interationalization issues, python and Zope links, etc... and of course my rants from time to time. I hope some day it will become the kind of community that can be seen in the Zope main website and in zope.de A mailing list hispaZope http://zope.sistelnet.es/cgi-bin/mailman/listinfo/hispazope has also been created to support the site. Thanks. -- Eduardo Fernández Corrales eduardo(a)sistelnet.es Sistelnet Integraciones Telemáticas - http://www.sistelnet.es

2 1

Zope+IIS
by Harald Ragger 02 Dec '99

02 Dec '99

Hi there! It would be very helpful for me, when anybody could give me a more detailled installation instruction for Zope + IIs (pcgi) than the present howto. (where is the zope.cgi; example for zope.pcgi under win, ...). Thank you very much! Harald

1 0

RE: [Zope] ZMySQLDA product problem?
by Michel Pelletier 02 Dec '99

02 Dec '99

> -----Original Message----- > From: Art Hampton [mailto:arth@pacsg.css.mot.com] > Sent: Thursday, December 02, 1999 1:35 PM > To: Michel Pelletier > Cc: zope(a)zope.org > Subject: Re: [Zope] ZMySQLDA product problem? > > > Michel Pelletier wrote: > > > > > -----Original Message----- > > > From: Art Hampton [mailto:arth@pacsg.css.mot.com] > > > Sent: Thursday, December 02, 1999 12:02 PM > > > To: zope(a)zope.org > > > Subject: [Zope] ZMySQLDA product problem? > > > > > Uhm.. you do shut down the OS first before rebooting right? > > Of course, we're using shutdown -i 6 under Solaris. I had to ask. ;) Too many years of phone tech support in me... > ImportError: ld.so.1: /usr/local/bin/python: fatal: > libmysqlclient.so.6: > open failed: No such file or directory > > Looks like it doesn't know where it should be looking for the library > (/usr/local/lib/mysql in this case). What do I need to do? Set your LDPATH (LD_PATH?) env variable to contain the path to mysql shared module. In Linux, you can also edit /etc/ld.so.conf, I don't know if Solaris has such a file. -Michel

1 0

RE: [Zope] Howto access an Object not in the hierachy.
by Michel Pelletier 02 Dec '99

02 Dec '99

> -----Original Message----- > From: Felipe Alvarez Harnecker [mailto:felipe@qlsoft.cl] > Sent: Thursday, December 02, 1999 11:37 AM > To: zope(a)zope.org > Subject: [Zope] Howto access an Object not in the hierachy. > > > > Suppose this scenario > > > /--| > |-foo-| > | |- DTML Object 1 > | > |-bar-| > | |- DTML Object 2 > > > > I need to access Object1 from Object2. > > Something like <dtml-var foo.Object1> in Object 2 You're close, <dtml-var "foo.Object1"> will work (because it's a python expression with the "", and Zope acquires 'foo') or: <dtml-with foo> <dtml-var Object1> </dtml-with> Is similar, Zope acquires 'foo', then sees object1. -Michel

2 1

XMLDocument question
by Jim Harrison 02 Dec '99

02 Dec '99

I'm beginning to work with XMLDocument and I have a question. I'm a pretty green Zope newbie, so please excuse me if this is naive. I'm able to import XML documents to form a tree of elements and access those elements based on their 'e#' id notation; attributes also get parsed correctly into properties. I've modified a display method from the Examples files to return the text content of any element in response to a url request, so things seem to be working correctly. What's the strategy behind the id notation approach to access? It's pretty unwieldy given that you must view the document's display in the management interface to see what ids are there, and ids change when the document is edited. Is there a way to use the tag names in a url to target particular parts of the document? The alternate access method based on the numerical sequence of elements through the hierarchy is useful for iteration and documents of rigid structure, but less useful than tag names with more flexible documents when a particular element or subtree is desired. Since the slideshow example uses tag names along with objectValues to target particular document content for display, the names are clearly there (somewhere) and usable ... maybe I'm just thinking about this the wrong way. If someone could post some additional example code dealing with tag name manipulation, it would probably be really helpful to me. Jim ________________________________________________________________________ James H. Harrison, Jr., MD, PhD University of Pittsburgh Health System C920 PUH, 200 Lothrop Street Pittsburgh, PA 15213 jhrsn(a)pop.pitt.edu | voice: 412-647-5529 | fax: 412-647-9588 "If you want sense, you'll have to make it yourself!!"-Norton Juster ________________________________________________________________________

2 2

RE: [Zope] can't update integer values in oracle
by Michel Pelletier 02 Dec '99

02 Dec '99

> -----Original Message----- > From: Adam Gotheridge [mailto:adam@foxvalley.net] > Sent: Thursday, December 02, 1999 12:10 PM > To: zope > Subject: [Zope] can't update integer values in oracle > > > If I have a form variable in a dtml document like > <input type="hidden" name="milestoneid" value=43> <input type="hidden" name="milestoneid:int" value=43> otherwise it marshals 43 into a string. -Michel

1 0

can't update integer values in oracle
by Adam Gotheridge 02 Dec '99

02 Dec '99

If I have a form variable in a dtml document like <input type="hidden" name="milestoneid" value=43> and when I try to run the sql method(below) to update the db form a form submission (to another dtml doc which calls the sql method) I get "Invalid integer value for milestoneid " My sql method looks like this: update task set milestoneid=<dtml-sqlvar milestoneid type=int>, task_name=<dtml-sqlvar task_name type=string>, description=<dtml-sqlvar description type=string>, task_date=<dtml-sqlvar task_date type=string>, hours=<dtml-sqlvar hours type=string>, username=<dtml-sqlvar username type=string>, status=<dtml-sqlvar status type=string> WHERE taskid=<dtml-sqlvar taskid type=int> Another intersting fast is that when I test the sql method in the management interface, I get the result shown below, but the update statement in fact succeeds. " This was not a query. " SQL used: update task set milestoneid=43, task_name='test', description='test update', task_date='', hours='', username='bryant', status='OPEN' WHERE taskid=233 Please help. Adam

2 1

ZMySQLDA product problem?
by Art Hampton 02 Dec '99

02 Dec '99

We've been having problems with the ZMySQLDA product, as installed using the instructions at http://yyy.zope.org/Members/alanpog/zmysqlda_steps . The product seems to break for some unknown reason. I've seen it happen as a result of the following events: o Rebooting the machine (while Zope is running) o Installing another product (including stopping and restarting Zope) We get the following message in our SQL DB connection: _______ This object is broken because the ZMySQLDA product that created it is no longer installed or is installed incorrectly. Please contact your product vendor for assistance. Note that the data associated with this product has not been lost, and will be accessible again if the product is reinstalled. _______ If we remove the ZMySQLDA product tree and then follow the instructions referenced above, it works again after restarting Zope. Has anyone else had this problem? Is this a known bug? Any suggestions? Thanks.

1 0