- Zope - Zope lists

Problems inserting into MySQL
by Ed Leafe 25 Jul '02

25 Jul '02

I'm working on a site whose data is stored in MySQL. So far I've had no problems with the database connection, but one just came up. The user fills in a form, and the submit calls a Python script that formats the data and passes it to the Z SQL Method that contains the INSERT INTO command. The only data access is this single INSERT command, and it succeeds, at least in the sense that the data is properly inserted into the table. But I get this ugly and hard to understand error message: <H2>Site Error</H2> <P>An error was encountered while publishing this resource. </P> <P><STRONG>_mysql_exceptions.NotSupportedError</STRONG></P> Sorry, a site error occurred.<p>  OK, I get that something's wrong, but how do I go about figuring out the problem? I tried using the src__=1 trick to view the generated SQL statement, and that was fine: if I plugged it into a MySQL GUI interface, it ran without problem. And even running through Zope, the data does get properly inserted into the table. So what's up with this error message? ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://foxcentral.net

2 2

How to add a property to a file system product class ?
by Orlando Sanchez Hotmail 25 Jul '02

25 Jul '02

Hi everybody, I have a file system product, it has a class with some properties, but I now need to add a new property to the class, it works ok for the new objects that get created, but the old objects doesn't have the new property added, so when I try to display it, zope gives me an error. What should I do to get the new property added to all the old objects ?. thanks a lot, Orlando Sanchez

1 0

python scripts,zsql methods and many parameters
by Jeff Sacksteder 25 Jul '02

25 Jul '02

I am beginning to experiment with python scripts and can't seem to find any code examples to do the specific operation I'm trying. To be specific, I want to insert a record into a database by calling a zsql method and passing it 8 individual parameters. Can anyone explain what exactly I'm missing. # my values are all in local variables # a = 'acme widgets' b = 'jet pack' c = '99.99' d = '07-15-2002' e = 'blue' f = '90 day' # I got an error leading me to believe that I can only list 5 parameters. # Is this syntax correct? # insert_object = container.logging_row_insert(company=a,item=b,cost=c,date=d,color=e,warranty =f) return

2 1

Send folder object from form to script
by Kristofer Bengtsson 25 Jul '02

25 Jul '02

How do I send a folder instance from a form to a script? When I test my script with this code outside a form its working fine: <div tal:replace=" python:here.addProject(python:here.projects.objectValues(['Folder','Plone Folder']))" /> The script copys Page Templates from a list of folders and adds them to context. Here is part of my form (what kind of Mime should i have?): <tbody> <metal:block tal:repeat="trx batch"> <tr class="even" tal:define="oddrow repeat/trx/odd" tal:attributes="class python:test(oddrow, 'even', 'odd')" > <td> <input type="checkbox" class="noborder" name="proj:list" value="" tal:attributes="value trx"> -------------------- the trx is the folder i want to send---------- </td> <td> <a href="" tal:attributes="href trx/absolute_url" tal:content="trx/title_or_id">Title </a> </td> </tr> </metal:block> </tbody> _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com

2 1

Trying to implement a simple mvc or how do you pass the REQUEST o bject when doing a redirect?
by Pierce, Scott 25 Jul '02

25 Jul '02

I have a product that I am attempting to do something like this: def controller(self): """ This will implement a MVC type paradigm for user administration. """ req = self.REQUEST f = req.form controldict = {'adduser': self.CreateUser, 'viewuser': self.ViewUser, 'edituser': self.EditUser, 'None': MessageDialog(title='Error: Action not Recognized', message='The action you took is not recognized', action='Admin')} controldict[f.get('controlaction','None')]() It would work except calling the dtml method like this causes there to be no traverse_subpath in the REQUEST object and I use that like this: def parseSubPath(self): """ Parses the subpath and gives us access to the variables contained therein """ set = self.REQUEST.set subpath = self.REQUEST.traverse_subpath idx = len(subpath)-1 jdx = 0 while jdx < idx: set(subpath[jdx],subpath[jdx+1]) jdx += 1 this allows me to put variables in the URL (it seems like there is another way of doing this but.... i don't know what it is). This code is called in standard_html_header and breaks with the controller code above. So, I either need to fix the parseSubPath code (there is a LOT of code that uses this so major refactoring to change) or I could change the controller method to do a redirect but then I need to be able to pass the REQUEST object from the controller method to the redirected object. The question is, how do you pass the REQUEST object when doing a redirect? Scott Pierce Sonopress US - Digital Services 828.658.6157

2 1

Serving Files from Filesystem
by Thomas Guettler 25 Jul '02

25 Jul '02

Hi! I want to make files from the filesystem down- and uploadable via browser. It is needed for a python product. No TTH editing, dtml or zpt. Which products are available? A quick search revealed: +ExtFile +ExternalFile What are the pros and cons? thomas

6 8

DateTime Problem
by Dean Grubb 25 Jul '02

25 Jul '02

Hi, I'm having problems with the date on zope... I have two system both running zope 2.3.2, one is running on a debian server the other is running on windows 2000, the debian zope incorrectly shows the timezone as US/Eastern where the windows zope shows it as GMT+10 (correct), which is not a big problem. The problem is when I do; (real time = 2002/07/25 13:24:01) <dtml-var expr="ZopeTime().strftime('%A, %d %B %Y')"> shows Wednesday, 24 July 2002 <dtml-var expr="ZopeTime().toZone('GMT+1000').strftime('%A, %d %B %Y')"> shows Thursday, 25 July 2002 doing a <dtml-var "_.DateTime('GMT')"> shows 2002/07/25 03:24:01 ten hours behind sure I could use the toZone function all the time but there must be an easy fix? Why does the debian zope think it's 10 hours behind, the date on the server is correct. is it a configuration setting somewhere? Dean.

2 1

small RFC : how to enhance zopistas' web experience
by alet＠unice.fr 25 Jul '02

25 Jul '02

Hi, Now that there are lots of web sites dedicated to Zope and its community, for example : zope.org zopezen.org zopenewbies.net zopelabs.com zopera.org zopegurus.de etc... I've noticed that most of them, if not all, invite the user to open an account before being able to do something useful (post a news message, a document of some sort, etc...) Considering that most Zope users are interested in most of these sites, except when the language is not english, and that some want to really participate, I think this registration process quickly becomes very boring, and remembering all the different passwords is difficult, unless you always use the same which is insecure. Couldn't it be possible that all these servers share the same authentication mechanism, i.e. only usernames and passwords, and do all their local stuff on their own (roles, possible actions, homepages, etc...), in one word (ok, two) : Centralized Authentication For example I suppose it would be possible, if every webmaster agrees, to use the very same LDAP directory, which might be replicated for redundancy reasons, to check username+pw when an user tries to authenticate. This would have the great benefit of checking not if someone is part of myownlittlezopecommunity.org but the WHOLE Zope community, this would also better solder this sparse community IMHO. Of course I understand there are strong security drawbacks to this approach, but anyway this might be very good to make a real network of web sites strongly related to Zope, and could only strenghten the Zope community presence on the web. <mode thispostshouldalsoincludeanMSrant="ON"> I know it's not better than what Mickey$oft plans to do, but while I trust the Zope Community (and ZC) I really don't trust the above named monopolist. </mode> Any comment or flame ? thank you for reading, anyway Jerome Alet

8 12

initalising zcom
by Greg Conway 25 Jul '02

25 Jul '02

Hi all, I'm trying to initialise zcom, to try and perform a mail merge with word! I'm following the instructions here: http://www.zopelabs.com/cookbook/993002968 and I'm stuck of course! When I try to start zope now, I get the following error: [root 2.5.0]# ./start Traceback (most recent call last): File "/home/zope/2.5.0/z2.py", line 468, in ? import ZServer File "/usr/local/zope/2.5.0/ZServer/__init__.py", line 80, in ? from HTTPServer import zhttp_server, zhttp_handler File "/usr/local/zope/2.5.0/ZServer/HTTPServer.py", line 43, in ? from PubCore import handle File "/home/zope/2.5.0/ZServer/PubCore/__init__.py", line 1, in ? import zcom File "/home/zope/2.5.0/lib/python/zcom.py", line 16 def init(): ^ SyntaxError: invalid syntax This looks okay to me! and it's the same as in the link above... anybody got any ideas what's going wrong here?!!! Also, if I do ever get it working (and maybe this is the problem), the link above goes on to say.... * now you have access to COM, you still need to copy the winXX files from your python distribution (or win32all extensions by Mark Hammond). What are these? Where can I find them? many thanks for any help! Regards, Greg Conway. This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us by return and delete the same. Further enquiries/returns can be posted to postmaster(a)gmlnt.com Thank you.

2 1

How to intregrate an image in a DTMLDocument
by andre 25 Jul '02

25 Jul '02

Hi How can i make an object in Zope, so i can intregrate an image in it. I want to make a simple catalog for different items. Sometimes there is a picture, sometimes not. Regards Jens Bjerre

3 2