August 2000 - Zope - Zope lists

Help!! RE:mutilple select forms and ZSQL Method
by Erik Lacson 14 Aug '00

14 Aug '00

We are trying to insert an values from a multiple select form into an SQL Database. Does anyone know how to handle arguments of type 'list' inside an SQL Method ? Thanks, ^..^ Erik ===== erik lacson net applications developer president ----------- eMerge Network Technology Solutions intranets * web business * virtual private networks http://www.emerge-tech.com | erik(a)emerge-tech.com __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

2 1

Difference between 2 permissions
by Tom Deprez 14 Aug '00

14 Aug '00

Hi, What is the difference between Open/Close database connection and Open/Close database connections Thanks in advance, Tom.

1 0

tree plus/minus url
by Ragnar Beer 14 Aug '00

14 Aug '00

Howdy! I've been experimenting with trees for a while and discovered that almost all innocent first time clickers were clicking on the text _behind_ the plus and minus images instead on the images themselves. So I decided to make the text a link with the same url as the image has but I can't find the right variable. Where is that url stored? Can anybody help? Ragnar

3 4

FTP and container type products
by Petr Knapek 14 Aug '00

14 Aug '00

Hi Zopists, I have created new container product 'ISNG Folder' by modification of classical Folder object. Only some attributes are added to every instance of ISNG Folder and in future a more functionality. But when I try to put any object over ftp, an error occurs. I can't create any object inside the ISNG Folder object over ftp. I have no such problem when putting the object into ISNG Folder over web interface. Can anybody tell me more about ftp access and help me with my problem? Below the part of my source is listed. Thanks, Petr # ------------------------------------------------------------------------- # Here starts code for 'ISNG Folder' object manage_addISNGFolderForm=HTMLFile('addFolder', globals()) def manage_addISNGFolder(self, cz_id, title='', key_words=[], createPublic=0, createUserF=0, REQUEST=None): """Add a new 'ISNG Folder' object with id *id*. If the 'createPublic' and 'createUserF' parameters are set to any true value, an 'index_html' and a 'UserFolder' objects are created respectively in the new folder. """ author = repr(REQUEST.AUTHENTICATED_USER) id = cz_id2id(cz_id) ob=ISNGFolder() ob.id = id ob.cz_id = cz_id ob.title = title ob.creation = DateTime.DateTime(time.time()) ob.author = author ob.modifier = author ob.key_words = key_words self._setObject(id, ob) try: user=REQUEST['AUTHENTICATED_USER'] except: user=None if createUserF: if (user is not None) and not ( user.has_permission('Add User Folders', self)): raise 'Unauthorized', ( 'You are not authorized to add User Folders.' ) ob.manage_addUserFolder() if createPublic: if (user is not None) and not ( user.has_permission('Add Documents, Images, and Files', self)): raise 'Unauthorized', ( 'You are not authorized to add DTML Documents.' ) ob.manage_addDTMLDocument(id='index_html', title='') if REQUEST is not None: return self.manage_main(self, REQUEST, update_menu=1) class ISNGFolder(OFS.Folder.Folder): """ISNGFolder class. Is created by inheritance from Folder Zope object.""" meta_type = 'ISNG Folder' manage_options = OFS.Folder.Folder.manage_options + ({'label':'Edit', 'action':'manage_editForm'},) __ac_permissions__ = OFS.Folder.Folder.__ac_permissions__ manage_editForm = HTMLFile('editFolder',globals()) # manage_main = HTMLFile('editFolder',globals()) def manage_edit(self, title, key_words, REQUEST=None): """Edits title and key_words atributes of 'ISNG Folder""" self.title = title self.key_words = key_words if REQUEST is not None: return MessageDialog( title = 'Edited', message = 'Properties for %s changed' % self.cz_id, action = './manage_main', ) -- Petr Knápek NEXTRA Czech Republic, s.r.o., Veveří 102, 659 10 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-41 558 394 FAX:+420-5-41 558 390

1 0

(no subject)
by Bill Welch 14 Aug '00

14 Aug '00

I'm having trouble with nested dtml-in. The outer ZSQL returns the coordinates of a zip code as zlat and zlong. The inner ZSQL takes zlat and zlong as well as Range and Otype as arguments. When I run it I get Error Type: Bad Request Error Value: ['zlat', 'zlong'] If I hardwire the inner one with just zlat and zlong, I get Error Type: Bad Request Error Value: ['Range', 'Otype'] If I hardwire the inner one with all four keyword arguments it runs fine. Here're the relevant lines from my DTML Doc: <dtml-in zipCoord> <dtml-var Range><dtml-var zlat><dtml-var zlong><dtml-var Otype> <dtml-in orgZipRadius> Trace line prints fine when all four arguments are hardwired or inner ZSQL is commented out. Bill.

1 0

(no subject)
by Michel Houben 14 Aug '00

14 Aug '00

Hello, I have a problem; How can I fix the date in Dutch, for example Vrijdag 12 Augustus 2000 instead of Fruday 12 August 2000. I hope you can help me with this problem. Michel Houben

1 0

ZSQL returning a trailing "L"
by didier georgieff 14 Aug '00

14 Aug '00

Hello, I get a trailng "L" on smallint variables from ZSQL/MySQL on 2.1.4 (prod server) but not on 2.1.6 (developt server). I do remember a post some times ago about that, BUT i can't find it again on the archives despite my (weak ?) efforts.. Any info/tip would be great as the production 2.1.4 is not migrate right now. Didier Georgieff

1 0

RE: [Zope] application/octet-stream vs. application/msword
by Jean Jordaan 14 Aug '00

14 Aug '00

Hi Dieter & all > The problem is, currently, not interesting enough for > me to analyse is seriously. I can well understand, I wish I could forget about it :( > If you know, that you add only "*.doc" files I add .doc, .zip, .exe (self-extracting zip), .pdf and .ppt ... so the quick and dirty route won't save me this time .. Thanks for your time till now! -- jean

1 0

Letting a content manager add ZClass instances
by Jean Jordaan 14 Aug '00

14 Aug '00

Hi Zopers .. I want content managers to be able to add and edit ZClass instances without having to negotiate the Zope management interface. So I want them to visit the Add and Edit forms, but to be redirected back to where they were browsing. The best I could do was: in 'ccDocClass_add', the ccDocClass constructor, check the user: ............................................................ <dtml-if DestinationURL> <dtml-if "AUTHENTICATED_USER.has_role('ContentManager')"> <dtml-call "RESPONSE.redirect( DestinationURL+'/index_html')"> <dtml-else> <dtml-call "RESPONSE.redirect( DestinationURL+'/manage_workspace')"> </dtml-if> <dtml-else> ............................................................ I gave their user both 'ContentManager' and 'Manager' roles, as I couldn't figure out which permissions 'ContentManager' needed to have. I gave it all the ones I thought obvious, but was still being denied entrance. Is there anything here I could do 1000 times better? Yours, -- jean

1 0

Editing ZClasses properties as ContentManager
by Jean Jordaan 14 Aug '00

14 Aug '00

Hi Zopers, In my ccDocClass / propertysheets / methods / edit_properties method, right after reindexing the changed instance like so: <dtml-call "propertysheets.ccDocProperties.manage_changeProperties(REQUEST)"> <dtml-call reindex_object> (from the How-To: Creating a CatalogAware ZClass Created by AlexR. Last modified on 1999/10/31.) I have the following: <FORM <dtml-if "AUTHENTICATED_USER.has_role('ContentManager')"> ACTION="<dtml-var URL1>" <dtml-else> ACTION="edit_propertiesForm" </dtml-if> METHOD="GET"> Why do I get URL1 if I authenticate as the "superuser" (the user who installed Zope)? That user shouldn't have role ContentManager, should it? Is this some kind of IE (5.5) caching hassle? If I login as a different 'Manager' (defined in the root's acl_users folder), I get edit_propertiesForm as I'd expect. Another question: is there a good way to let a user login using only the builtin acl_users mechanism? Hmm, I think I answered my own question: Say <a href="confirmation">Login</a> and make the 'confirmation' method require authentication. (Now how do you do that again?) Ah well, g'night! -- jean (running Zope 2.1.6 on W2K)

1 0