- Zope - Zope lists

What's involved in writing a DA (for Ingres)?
by Hamish Lawson 22 Feb '01

22 Feb '01

I'd like to have a Zope DA for Ingres II (on Solaris), and since I haven't come across an existing one, I'm thinking of attempting to write my own (!), building it on top of a DB-API-compliant Python module for Ingres that I've got hold of. I've grabbed the "How to Write a DA" document; is there anything else that would be useful? Are there any particular existing DAs that it would be worthwhile to look at for guidance? Hamish Lawson ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

2 1

Re: [Zope] mozilla (was KDE's Konqueror)
by Andrew Williams 22 Feb '01

22 Feb '01

>> it runs much faster than before. I'm really looking >>forward to the >>.9 and >> 1.0 releases. Hear, hear to the mozilla team. > >0.8 is faster compared to .7, or even netscape6.x >however, back button dont work (in zope management >interface). and >copy/paste works when it wants to work. dang. >is it just me? No, it is not just you. I have had pretty good luck with .6 albeit a little slow opening/closing. Mozilla .7 runs *much* faster, but I've also been having problems with the "back" button, and not just in the Zope management screens. One other thing I've noticed is that when copy/paste does work, it doesn't keep any of the formatting (I love indented code). Really really aggravating. So... at home I use IE 5.0 on my home pc and at work I use Mozilla .8 on my laptop. Andrew ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

2 1

RE: [Zope] quick question - database connections in python methods & return types?
by Randall F. Kern 22 Feb '01

22 Feb '01

The query result is a tuple, with two items. The first item in the tuple is a list of dictionaries, which describe each column. These dictionaries have values for 'name', 'type', 'null', and 'width'. These values came from MySQL, as meta-information about the query results. The second item in the outermost tuple contains the actual data. This is a list of rows, each row is a tuple that has a value for each column, in the same order as the column description dictionaries. So yes, the result is a combination of tuple, list, and dictionary. If these types are confusing, I would suggest reading some of the material on www.python.org. Sample query result: id | title ----|--------- 1 | john 2 | greg Written in python as a "result object": result = ( [ {'name': 'id', 'type': 'NUMBER', 'null': 'NOT NULL', 'width': 4}, {'name': 'title', 'type': 'STRING', 'null': 'NOT NULL', 'width': -1} ], [ (1, 'john'), (2, 'greg') ] ) -Randy > -----Original Message----- > From: Lee [mailto:lee.reilly@ntlworld.com] > Sent: Wednesday, February 21, 2001 4:26 PM > To: zope(a)zope.org > Subject: [Zope] quick question - database connections in > python methods > & return types? > > > Hi there, > > I have a quick question that I need answered concerning the > return types > of SQL queries executed in Python methods. > > I am querying/updating a database using Python methods as follows: > > -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ > # make a database connection string > try: > db_conn = self.MySQL_database_connection() > except Exception: > return "A connection to the database could not be made. <a > href='./'> > Recover</a>." > > try: > SQL = "some SELECT query" > result=db_conn.query(SQL) > except Exception: > return "The class could not be created.<a href='./'> Recover</a>." > -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ > > When this is executed and I "return result[1]" it outputs the > data in a > format like: > > [(1, 16, 9, 1)] > > * return result[0] gives me: > [{'name': 'PRACTICALS', 'type': 's', 'null': None, 'width': None}, > {'name': 'TUTORIALS', 'type': 's', 'null': None, 'width': None}, > {'name': 'ASSIGNMENTS', 'type': 's', 'null': None, 'width': None}, > {'name': 'BONUS', 'type': 's', 'null': None, 'width': None}] > > - the exact details aren't neccessary here I think. At first I had > problems trying to use this data i.e. parse it an store it in > an array, > list, etc. but I overcome that by by first converting "result" to a > string using `result[1]`. > > I was just wondering how to classify the original return type? It is > *not* a list, tuple, array or combination of either so what is it? > > I'm writing a report on my project you see and I can't say that my > method returns an *cough* *cough* value ;-) > > Thanks very much in advance if you can help. > > Cheers, > > Lee > > > _______________________________________________ > 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 ) >

1 0

limit on the length of namespaces
by Scott Syms 22 Feb '01

22 Feb '01

Hi, folks I've got a graphic in a folder /common.global.clfheadere.graphic When I try to reference it from another sub-dir with <dtml-var "PARENTS[-1].common.global.clfheader.graphic"> it generates an error. But I can get a graphic from /common.graphic using the same method. <dtml-var "PARENT[-1].common.graphic"> What am I missing!!? tks Scott Syms Halifax, Nova Scotia

1 0

Zope BOF at Python Conference
by Tres Seaver 22 Feb '01

22 Feb '01

"Andy McKay" <andym(a)ActiveState.com> wrote: > Anyone attending the python conference interested in having a BOF on Zope? > Areas that aren't in talks and could be of interest include CMF/PTK, ZEO > etc... I'll be there, and up for a PTK^H^H^HCMF BOF. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

2 1

LocalFS and creating files
by Paul Zwarts 22 Feb '01

22 Feb '01

Hi all, Am I to understand that LocalFS is only for reading files? The README is practically nonexistant and the Zope site only shows how to get files FROM the localfs mount. How do I use a manage_addImage to put a file into the mount? Is this possible? It does insinuate somewhere that this can be done, but no examples for a newbie like myself... Thanks again Zopistas, Paz

1 0

Simple DTML question
by Paul and Naomi Newman 22 Feb '01

22 Feb '01

I am trying to make a DTML method that will list all the DTML documents in a folder with links to them. Here is what I did: <ul> <dtml-in expr="objectValues('DTMLDocument')"> <li><a href="&dtml-absolute_url;"><dtml-var title_or_id></a></li> </dtml-in> </ul> I name the method contents and call it by stating <dtml-var contents> in the document where I want the folders contents listed. This is giving me no output. The only thing I changed from the stock example in Chapter 5 of the Zope Book was the class 'DTMLDocument' - in the Zope Book the classes 'File' and 'Folder' are used. But in the API reference DTMLDocument is listed as a class along with File and Folder. Where am I going wrong? ======================== http://freezope.nipltd.net/wanwood paul(a)wanwood.co.uk ------------------------------------------------- This mail sent through UK Online webmail

4 5

Understanding dtml and/or its variables
by Damir Bartakovic 22 Feb '01

22 Feb '01

Hi all, I am using ZnolkSQLWizard and it creates output like <INPUT TYPE="TEXT" NAME="table.name"> ... Now I am trying to force the user not to leave the field blank. Usually it works with <dtml-unless "somevariable"> ... once again! ...</dtml-unless> but with <dtml-unless "table.name"> ... I get the error: Error Type: NameError Error Value: table (The Traceback is at the end) Like it seems it don't like the '.'? But for <dtml-var table.name> I'm getting the right value. So what I'm not understanding? How can I solve it and is it a good idea to use '.' in variables? Thanks Damir Traceback (innermost last): File /usr/local/share/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/share/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/share/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/share/zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/share/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: html_insert) File /usr/local/share/zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: html_insert) File /usr/local/share/zope/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: html_insert) File /usr/local/share/zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: html_insert) File /usr/local/share/zope/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: table.name) (Info: table) File <string>, line 0, in ? NameError: (see above)

3 2

RE: [Zope] RE: LoginManager and LDAP
by Magnus Heino (Rivermen) 22 Feb '01

22 Feb '01

> I would think it would not matter what back end you use. If > you can access > active directory via Python external to Zope, there should be > no reason why > you can't acccess it from within Zope. I can access it with LDAPAdapter from Zope (Linux), but I cant get authentication going. Probably because I dont know enough about LDAP and Active Directory. I noticed that you did an md5_encrypt on the password. Is that common in all ldap servers, or do I have to do something else in Active Directory? /Magnus

2 1

RE: [Zope] RE: LoginManager and LDAP
by Magnus Heino (Rivermen) 22 Feb '01

22 Feb '01

> > I was able to do a basic test with LoginManager and > > ZLDAPConnection/ZLDAPMethods using Zope 2.2.4: Would it be possible to authenticate against Active Directory? :-P /Magnus

2 1