November 1999 - Zope

Re: [Zope] Linking two tables
by Thomas B. Passin 19 Nov '99

19 Nov '99

-----Original Message----- From: Anders Gaarsdal Holst <anders(a)colorweb.dk> > >This question might be slightly off topic. But anywhere here it is: > >I have two tables in my MS Access database: >1. Containg a record for each employee > >2. DVD database containing a record for each DVD > >What I would like to do with Zope, is to somehow link these two >together, so that I can write on my intranet that Mr. X has DVD this >and that. > >My problem is that I can offcause make a field in the first table >(employee table), where I list the IDnumbers of the DVDs (seperated by >commas), which the employee owns, but then a query returns these id's >comma seperated and I don't how to handle this (in a <dtml-in> -loop). > > You should do this in the query to the database, not in Zope. You should make a third table that relates employees to dvds. Then, using SQL, you would use a query something like this: select employee_name, dvd_name from employee_dvd, employee.dvd where employee.employee_id=employee_dvd.employee_id and dvd.dvd_id=employee_dvd.dvd_id order by employee_name If the database supports joins you can use joins in the from statement and omit the where statement. Then you would use Zope to display the results. Tom Passin

1 0

Re: [Zope] Zope-2.1.0b2 fails on access to management screen
by Martijn Pieters 19 Nov '99

19 Nov '99

>Yes, I have python 1.5.2 installed. I have used the same python >installation with Zope 2.0.1 and several versions before that. Hmm... and make test still does alright? You get an error with standard python library methods, very strange. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

2 1

Linking two entries in the KnowledgeKit product
by Jochen Knuth 19 Nov '99

19 Nov '99

Hi, after some playing with Zope i now have to implement my first project, a knowledge base. It is a variation of The KnowledgeKit Product from Bill Anderson (a very good starting point). One change i made to the KBEntry ZClass property sheet 'properties' is using the Notes property as a field for adding links to other KnowledgeBaseEntries (i changed it to type 'lines'). I enter the 'id' of another KnowledgeBaseEntry and in the index_html method of the KBEntry i included the following snippet to create an link to this KnowledgeBaseEntry. -----------KBEntry, index_html --------------- <dtml-if Notes> <tr><td VALIGN="TOP"> <p> <b>Siehe auch:</b> </td><td> <dtml-in Notes> <dtml-if sequence-item> <dtml-let num=sequence-item> <dtml-in "kbCatalog(meta_type='Knowledge Base Entry',id=num)"> <a href='/<dtml-var "kbCatalog.getpath(data_record_id_)">'> <dtml-if title><dtml-var title></a><br></dtml-if> </dtml-in> </dtml-let> </dtml-if> </dtml-in> </td></tr> </dtml-if> ------------------------ kbCatalog is a ZCatalog on all Knowledge Base Entries. This is working well, but there is another requirement to implement. If i add a "link id" in one Knowledge Base Entry it should automagically appear as a backlink in the Notes property of the linked Knowledge Base Entry. And of course if i delete a "link id" it should delete the backlink. Any ideas how i can add this to a KBEntry_change method? Jochen

1 0

Zope for Portal/e-commerce projects?
by Sébastien Douche 19 Nov '99

19 Nov '99

(sorry for my broken English) Hello, First, a great cheer to all (and specially to Digital Creations team) for the evolution of Zope. I seriously plan to use for all my projects (electronic trade, portal) who i am technical person in charge. But I have some concerns : 1/ in which measurements can I have a serious help (I am in France). 2/ think Zope can be to use in this kind of thing. 3/ for you, what is the best database to use ? ZODB or Oracle ? (simplicity & scabability). 4/ which is the evolution of the DTML ? More functionality? more simplicity? 5/ How many documentations exist ? it is significant I still have many questions but I stop for today :-) Thank you, and really, terrific job. Sébastien Douche <sdouche(a)farweb.fr> Far Web <www.farweb.fr>

1 0

Linking two tables
by Anders Gaarsdal Holst 19 Nov '99

19 Nov '99

This question might be slightly off topic. But anywhere here it is: I have two tables in my MS Access database: 1. Containg a record for each employee 2. DVD database containing a record for each DVD What I would like to do with Zope, is to somehow link these two together, so that I can write on my intranet that Mr. X has DVD this and that. My problem is that I can offcause make a field in the first table (employee table), where I list the IDnumbers of the DVDs (seperated by commas), which the employee owns, but then a query returns these id's comma seperated and I don't how to handle this (in a <dtml-in> -loop). Regards, A n d e r s G a a r s d a l H o l s t

3 2

Rules Based Applications
by Jerry.Spicklemire＠IFLYATA.COM 19 Nov '99

19 Nov '99

Hi Zope Fans, I've been searching the Web for references to Rules Based Programming with Python, and Zope. Not much so far. Anybody else out there interested in this topic? It may sound like a can of worms, since it sort of implies the need for *yet another syntax* layer. Still, the gist of the recent *Rant* thread re. DTML being at once too hard and too simple, suggests it may be time for another approach. I've personally spent way too much time trying to explain to folks at work that the fundamental principle underlying Markup Languages is to let the computer handle formatting, and presentation. Now that these folks have had a glimpse of XML they are finally "getting" it. Ironically, the reason they are starting to come over, is entirely due to the verbosity of XML, relative to HTML. They just don't want to hand code XML, even though they *knew* that HTML was *easy*. Until the sheer volume of XML tagging was in their face, they could never make the leap to the conclusion that the ultimate volume of HTML documents that need formatting warranted an automated solution. Go figure. How does this relate to Rules? Well, Rules and Natural Language represent a method of end user interaction that is truly "easy". If we want to empower users, this could be nirvana. I did find a link to few small examples of AI at Python.org, on Joe Strout's site (http://www.strout.net/python/) and I'll start there. Thanks for your consideration, Jerry S.

1 0

Re: [Zope] Zope-2.1.0b2 fails on access to management screen
by Martijn Pieters 19 Nov '99

19 Nov '99

At 14:57 19/11/99 , Jim Cain wrote: >I am running Zope through Apache, and when I access /manage, I get the >following error each time: > >Traceback (innermost last): > File "/opt/Zope/z2.py", line 583, in ? > asyncore.loop() > File "/opt/Zope-2.1.0b2-src/ZServer/medusa/asyncore.py", line 107, in loop > poll_fun (timeout) > File "/opt/Zope-2.1.0b2-src/ZServer/medusa/asyncore.py", line 66, in poll > x.handle_error() > File "/opt/Zope-2.1.0b2-src/ZServer/medusa/asyncore.py", line 321, in > handle_error > self.close() > File "/opt/Zope-2.1.0b2-src/ZServer/PCGIServer.py", line 261, in close > p.more() # free up resources held by producer > File "/opt/Zope-2.1.0b2-src/ZServer/Producers.py", line 108, in more > getattr(self.logger, self.method)(self.bytes) > File "/opt/Zope-2.1.0b2-src/ZServer/PCGIServer.py", line 229, in > log_request > time.gmtime(time.time()) >TypeError: illegal argument type for built-in operation > >Zope dies after this. I have tried both the source and Intel binary >versions and get the same error. This is a python error. What version of Python have you got installed? Make sure you have Python 1.5.2 (with threads) as the only python install on your system. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

2 1

RE: [Zope] Linking two tables
by Rob Page 19 Nov '99

19 Nov '99

> This question might be slightly off topic. But anywhere here it is: > > I have two tables in my MS Access database: > 1. Containg a record for each employee > > 2. DVD database containing a record for each DVD > > What I would like to do with Zope, is to somehow link these two > together, so that I can write on my intranet that Mr. X has DVD this > and that. > > My problem is that I can offcause make a field in the first table > (employee table), where I list the IDnumbers of the DVDs (seperated by > commas), which the employee owns, but then a query returns these id's > comma seperated and I don't how to handle this (in a <dtml-in> -loop). You could create a third associative table (dvd_status) with: o its own primary key o a foreign key into the employee table o a foreign key into the DVD table <untested sql> SELECT employees.first_name, dvds.dvd_name FROM employees, dvds WHERE employees.employee_id = dvd_status.employee_id AND dvd_status.dvd_id = dvds.dvd_id </untested sql> --Rob

1 0

RE: [Zope] ZODB or ZODBC?
by Rob Page 19 Nov '99

19 Nov '99

> what is less difficult to work (ZODB or ZODBC)? I think it's less a question of difficulty than propriety. It's no harder to work with a screwdriver than a hammer but I wouldn't want to pound nails with my screwdriver! :^) > i am new to zope and i am working on a school work, that i am > trying to make! 8-) i am trying to make a bank site like (called internet bank), where the > bank's client need to login with a valid username/password. Zope has a long (and growing) list of possible ways to authenticate users (e.g., organic UserFolder, UserDB, GenericUserFolder, LDAPUSerFolder, NTUSerFolder, and I believe there is an NDSUserFolder!). > to consult your accounts. my site need to read an ASCII file, that is > exported from other program that i make, has u ideia on how to make this? or if is this > possible? Reading and parsing an ASCII file is likely best accomplished using an External Method (written in the Python langauge). I'd check our the Zope docs and focus on those sections. Good luck! --Rob

1 0

RE: [Zope] ZODB or ZODBC?
by Rob Page 19 Nov '99

19 Nov '99

> Its possible to create a data base directly with the ZODB? Yes. Your subject line implies that the difference between the ZODB and ZODBC is unclear (likely our poor choice of acronyms in hindsight...) ZODB is an OO database engine underlying most (all?) of Zope. If you like the UML then you'll love the ZODB UML model: http://www.zope.org/Documentation/Developer/Models/ZODB ZODBC, on the other hand, is shorthand for ZODBCDA which is a database adapter used by Zope to connect to arbitrary ODBC data sources (e.g., Access, Oracle et al). If you're interested in _ZODB_ then (in addition to the UML model and docs) you should check out Michel Pelletier How-To on using the ZODB from Python: http://www.zope.org/Members/michel/HowTos/ZODB-How-To If you're interested in ZODBC then Jeffrey Shell's RDBMS How-Tos would be a good place to start! http://www.zope.org/Members/jshell Hope this helps, --Rob

2 1