- Zope - Zope lists

OT: Manual unique sequences in RDBMS
by Carlos A. Carnero Delgado 14 Jun '00

14 Jun '00

Hello Zopistas, This is a little off-topic but I had no other place to ask. I'm using Zope & PostgreSQL together on a intranet accounting system (BTW, it's Open Source and I'll post it soon.) Anyway, I have several tables related by ids (keys), and I have to create these keys by myself. They're of the form YYYYMMDDCCCCCC (Y: year, M: month, D: day, C: a consecutive transaction number that I must generate) and they must be unique. Of course, from day to day, these numbers are guaranteed to be unique, my problem relies on Intra-Day-Uniqueness (TM). How could I generate the consecutive part? Unfortunately, I can't use the underlaying RDBMS auto-numbering or auto-sequence feature. Since the keys _must_ conform to the above scheme. All I can count on is on the database rows (an ideal solution would be conceptually independent of both Zope and PostgreSQL). I was even thinking of having a separate table having the last transaction number stored in a single row which would be updated by locking the table... just a thought. Of course, this would be a multiuser environment. Any one? Best regards and TIA, -- [ c a r l o s c a r n e r o ] [ r t v c o m e r c i a l ] [ t e x e l @ r t v c . c o m . c u ]

2 1

how to access stored file data?
by Nils Jeppe 14 Jun '00

14 Jun '00

Hi Folks, OK I am progressing slowly. But I am stuck again. I have created a ZClass which is a subclass of CatalogAware and File. I have created an index_html view and mapped it in the Views tab to the View "category" if that's the right word. The purpose is that when the Instance's URL is enterd, information about the file will be displayed. On this page I want a link which will enable download or viewing of the file. But... how do I do this? I really can't figure it out. Help would be appreciated... best wishes, Nils -- "Like most of life's problems, this one can be solved with bending." --- Bender

1 0

Re: [Zope] del dict[kw] in DTML
by Dieter Maurer 13 Jun '00

13 Jun '00

Marco Mariani writes: > I can't find a way to emulate the pythonesque "del dict[kw]" within > DTML without rebuilding the dictionary from scratch. May I? I fear, you will need an external method. Dieter

2 1

Re: [Zope] Zope Beta Can't create folders as superuser!
by Petru Paler 13 Jun '00

13 Jun '00

> I get the following error when I try to create a new folder as superuser. Due to the new security policy you can't create anything as superuser. Add an user account first and use that. -Petru

1 0

Re: [Zope] Beta Zope Error
by T.J. Mannos 13 Jun '00

13 Jun '00

I get the same problem. A SQL method of mine is apparrently accessible from within a DTML method but not from within another SQL method. (I do this to determine if a record exists before overwriting it). I also have an external method that augments query objects with special grouping records. Here's one of my tracebacks (hey, I get a different one every time I click REFRESH): Traceback (innermost last): File /usr/Zope-2.2.0a1-src/lib/python/ZPublisher/Publish.py, line 224, in publish_module File /usr/Zope-2.2.0a1-src/lib/python/ZPublisher/Publish.py, line 189, in publish File /usr/Zope-2.2.0a1-src/lib/python/ZPublisher/Publish.py, line 175, in publish File /usr/Zope-2.2.0a1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index.html) File /usr/Zope-2.2.0a1-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: index.html) File /usr/Zope-2.2.0a1-src/lib/python/OFS/DTMLDocument.py, line 168, in __call__ (Object: index.html) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: index.html) File /usr/Zope-2.2.0a1-src/lib/python/OFS/DTMLMethod.py, line 156, in __call__ (Object: standard_html_header) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: standard_html_header) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_Util.py, line 333, in eval (Object: REQUEST.set('login',validateUser(_.None, _))) (Info: REQUEST) File <string>, line 0, in ? File /usr/Zope-2.2.0a1-src/lib/python/OFS/DTMLMethod.py, line 156, in __call__ (Object: validateUser) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: validateUser) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_With.py, line 146, in render (Object: PARENTS[0].sessions) File /usr/Zope-2.2.0a1-src/lib/python/OFS/DTMLMethod.py, line 156, in __call__ (Object: getLogin) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: getLogin) File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_Util.py, line 333, in eval (Object: SESSION.has_key('login')) (Info: SESSION) File <string>, line 0, in ? File /usr/Zope-2.2.0a1-src/lib/python/DocumentTemplate/DT_Util.py, line 140, in careful_getattr File /usr/Zope-2.2.0a1-src/lib/python/OFS/DTMLMethod.py, line 180, in validate (Object: index.html) File /usr/Zope-2.2.0a1-src/lib/python/AccessControl/SecurityManager.py, line 139, in validate File /usr/Zope-2.2.0a1-src/lib/python/AccessControl/ZopeSecurityPolicy.py, line 160, in validate Unauthorized: has_key ----- Original Message ----- From: CURTIS David <David.Curtis(a)state.or.us> To: IPM Return requested (Receipt notification requested) <Zope(a)zope.org> Sent: Tuesday, June 13, 2000 4:51 PM Subject: [Zope] Beta Zope Error > Greetings, > > I keep getting the Zope pop up password box in many menus. I also keep getting a access denied error when quering database records. What is wrong here? I am able to query records using the test menus but not within the Zope SQL methods. > > > David A. Curtis > Oregon State Marine Board > Information Systems Manager > David.Curtis(a)state.or.us > > >

1 0

Zope Beta Can't create folders as superuser!
by CURTIS David 13 Jun '00

13 Jun '00

I get the following error when I try to create a new folder as superuser. Zope Error Zope has encountered an error while publishing this resource. Error Type: SuperCannotOwn Error Value: Objects cannot be owned by the superuser

1 0

BETA BUG Authorization Bug!!
by CURTIS David 13 Jun '00

13 Jun '00

Greetings, I have just finished upgrading to the beta version and am having this error show up in the Netscape browser window. IT occurs when I try to query an odbc database. Am using NT and Access database. Any ideas to fix or should I go back a version. The error listed is Authorization failed retry, Please re-enter password for host.

1 0

Re: [Zope] Beta Zope Error
by Michel Pelletier 13 Jun '00

13 Jun '00

CURTIS David wrote: > > Greetings, > > I keep getting the Zope pop up password box in many menus. I also keep getting a access denied error when quering database records. What is wrong here? I am able to query records using the test menus but not within the Zope SQL methods. Hit cancel when a box pops up, the traceback that results will tell you what thing you are not authorized to see. This information coudl be useful for you and us, either you have your permissions set up wrong and you are getting denied for something, or there is a bug in the security machinery. Anyone else see this? -- -Michel Pelletier http://www.zope.org/Members/michel/MyWiki Visit WikiCentral for the latest Zen: http://www.zope.org/Members/WikiCentral

2 1

Beta Zope Error
by CURTIS David 13 Jun '00

13 Jun '00

Greetings, I keep getting the Zope pop up password box in many menus. I also keep getting a access denied error when quering database records. What is wrong here? I am able to query records using the test menus but not within the Zope SQL methods. David A. Curtis Oregon State Marine Board Information Systems Manager David.Curtis(a)state.or.us

1 0

Re: [Zope] Newbie: Listing filesystem objects?
by Dieter Maurer 13 Jun '00

13 Jun '00

Andy Gates writes: > NewbieQ of the moment: > > So there's a folder on my server, call it \\server\files\logos. I want > to list its contents in a drop-down listbox in a form; something like > > <select name="logo_filename"> > <option selected value="default.jpg">default.jpg > <option value="file1.jpg">file1.jpg > ... > </select> > > Needless to say, I've installed the local filesystem product and > created a localfs object called "logos" that maps to the correct > folder. And now I'm mired in the docs. I'm thinking that I can just > use dtml-in to iterate through the file ids of the objects in that > folder, but I'm damned if I can see *how* to do that. Any tips? You can use the "fileIds" method of "LocalDirectory". There are "fileValues" and "fileItems" methods, too. Dieter

1 0