July 2002 - Zope - Zope lists

a simple question about find
by Brad Knotwell 12 Jul '02

12 Jul '02

Hello all-- I've successfully added a catalog to search for my attributes in my custom ZClass. Zope finds and displays my objects correctly. However, the URL to access the object is broken. The object IDs are not URL-encoded correctly and the spaces in some of my object IDs cause problems. Are spaces disallowed as object IDs (so far, Zope has only complained when I tried to add an object with a forward slash in the name)? Or (more likely IMO), is this a configuration option that I've missed? Thanks in advance. --Brad

1 1

copy/paste from PythonScript
by G�l L�szl� 12 Jul '02

12 Jul '02

Hi! I have a PytonScript with proxy role 'Manager', and it's ok, it can add any product to the container, but container.manage_copyObjects, manage_pasteObjects and manage_clone ask for manager password. Is it a bug? Thanx Lac

2 1

Simple query using ZMySQLDA => (1064, "You have an error in your SQL syntax near ' LIMIT 1000' at line 2")
by Davis Marques 12 Jul '02

12 Jul '02

Thomas; You've probably already received a response on this, but you need to use <dtml-sqlvar VARNAME> instead of <dtml-var VARNAME> in the query. For example: select * from elope_moviereviews where emr_id = <dtml-sqlvar emr_id> I wasn't clear on what you intended with the <dtml-var sql_delimiter>, so I've left it out here. Davis -- McCall Design Group 550 Kearny Street, Suite 710 San Francisco California USA 94108

1 0

Simple query using ZMySQLDA => (1064, "You have an error in your SQL syntax near ' LIMIT 1000' at line 2")
by Thomas Weholt 12 Jul '02

12 Jul '02

I'm trying to use a very simple SQL query against a MySQL database, a sql-method called sqlViewMovieReview taking one parameter emr_id, an integer-value: select * from elope_moviereviews where emr_id = <dtml-var emr_id><dtml-var sql_delimiter> It works great then tested in the ZMI-test interface, but fails when used in a page, like when i test it like so : http://localhost:8080/MovieReviews/dmMovieReviewDetails?emr_id=4 Error reported : (1064, "You have an error in your SQL syntax near ' LIMIT 1000' at line 2") The DTML Method used over : <dtml-with expr="sqlViewMovieReview(emr_id='<dtml-var emr_id>')"> <dtml-var title> </dtml-with> Looked around on the net and found some references to the error, for instance http://linux.bryanconsulting.com/stories/storyReader$75. Added the <dtml-var sql_delimiter> but the error is still there. I'm using Zope 2.5.1 and ZMySQLDA 2.0.9. Any clues ?? Best regards, Thomas Weholt

2 1

renaming users
by Bryan C. Andregg 12 Jul '02

12 Jul '02

I've been asked to change the usernames of our users from something stand-alone to their email address. Searching the web I didn't find anything related to this. I figure if I can get the password (I am the Admin) then I can at least delete and re-add. Has anyone done this before or does anyone know how to get at this? -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

2 1

zope on win 2k
by David Walker 12 Jul '02

12 Jul '02

Hello - I've just discovered Zope. I read Reuven Lerner's introduction article in Linux Journal http://www.linuxjournal.com/article.php?sid=5619 and I am excited about Zope!! I visited your download page and found ver2.51 for win32 platform. Will this version work with Windows 2000 pro? If not, which version should I download? Thank you in advance David Walker dw(a)pzaz.net

3 2

quoting dtml in manage_edit
by Bryan C. Andregg 12 Jul '02

12 Jul '02

I'm using the input from a form to generate an email for a manager to either approve or reject a specific action. I thought the easy way to do this would be to create a random named DTML document, fill it with logic, and then put an ACCEPT and a REJECT link to it in the email. This works fine as long as I don't need to use quotes in the data string for manage_edit: manage_edit('<dtml-var standard_html_header>',title) But, this doesn't really do much for me. How does one escape quotes so that they are valid in this syntax? -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

2 1

Re: [Zope] Newbie: Python:Path Troubles
by Rebecca.R.Hepper＠seagate.com 12 Jul '02

12 Jul '02

Thanks much for the reply. When I try to use restrictedTraverse or unrestrictedTraverse in my python script I always get the error: Error Type: NameError Error Value: global name 'restrictedTraverse' is not defined I did spell it correctly and mine looks like the examples I find on the net. What does this error mean? Dieter Maurer <dieter@hands To: Rebecca.R.Hepper(a)seagate.com hake.de> cc: zope(a)zope.org Sent by: Subject: Re: [Zope] Newbie: Python:Path Troubles zope-admin@zo pe.org No Phone Info Available 07/11/2002 02:41 PM Rebecca.R.Hepper(a)seagate.com writes: > I am trying to use python:path in a html form to get a path name which I > will pass to a python script and use the setDescription function on. What is the "path name"? Do you mean the "URL"? > ... > If I print my python:path > statement into a table header I get something like: "<PortalFolder > instance at 90a24a0>" > ... > <td><input type="hidden" name="folderPath" > value="folderPath" > tal:attributes="value python:path('root/MyPortal/folderA/%s' % > folderID)"></td> This is exactly, how "path" should work: It turns a path into an object, in this case into a "PortalFolder" object. As the generated HTML can only contain strings, ZPT calls the "str" method on the object. This results in "<PortalFolderI instance at ...>". What you need to do: Pass the path string itself as value of the hidden variable. Use "restrictedTraverse" in you Python Script to resolve it into an object. Call "setDescription" on this object. Dieter _______________________________________________ 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 )

2 1

shot my acl foot...
by David Bear 12 Jul '02

12 Jul '02

I made a big mistake. I added a ZWikki product, then when I created the Zwikki web application, I went into the folder it created an uncheck all the acl permissions.. Okay -- I should rtfm... but I was in a hurry. Now, I can't do anything with it -- not even delete the folder. Is there anyway to overide everything and erase the folder and start again? I had not done anything it after initial creation so I suppose and could just leave it there -- but I really want it gone. -- David Bear College of Public Programs/ASU 480-965-8257 ...the way is like water, going where nobody wants it to go

2 1

(no subject)
by McDonnell, Larry 12 Jul '02

12 Jul '02

Hi, I have a strange problem that I thought someone out there knows the answer. In my pilot, using Zope technology, I have been able to create a simple search engine for our company. Since I have no money (yet) for this project. I used MS Access as my DB. Mainly so the users can use the reporting tools. Each search was place in it's own table, to make thing easier for me. Everyone like what they saw but it also got them thinking and the decision was made to combine the tables into one. Now I was dealing with test data and I would take the excel spreadsheets and import them into Access. This worked, the users could see the data from one interface. Again, I was asked to add our New Part Numbering data into this one table. Again the spreadsheet was imported and I have a total of 3000 records (stop laughing). My problem is Zope can not see the part number information. Using Z SQL Method, I can view all the old data but no part number information. I can see everything in Access but not through Zope. To make things worst for me, before this last decision was made, I had written an Zope interface to the Part Numbering system. At the time I had 1500 part numbers that was imported (excel) into Access and I was able to view the information as well as add new records. I wrote this because I found duplicate part numbers under their filtered spreadsheet method. I have tried several different ways to import the information but I still hit the same brick wall, Any thoughts?? Larry McDonnell Proton Energy Systems 50 Inwood Rd. Rocky Hill, CT 06067 (860) 571-6533 ext. 531 Email:lmcdonnell@protonenergy.com www.protonenergy.com

1 0