- Zope - Zope lists

Create a list in the REQUEST space ????
by Daniel G. Rusch 24 Nov '99

24 Nov '99

Help!, We are trying to load user roles from a table. roles needs to be a list so that the manage_users call can set the roles. The question is how does one create a list on the fly in the REQUEST Space...? The below snippet does not create the list, any thoughts??? //snippet <dtml-in getUserRoles> <dtml-call "REQUEST.set('roles:list',name)"> </dtml-in> <dtml-call "acl_users.manage_users(submit='Add', REQUEST=REQUEST)"> Thanks, DR

3 3

Using recursion with a SQL method
by Jim Cain 24 Nov '99

24 Nov '99

All, I have a MySQL table "category" with the following schema: id number name char parent_id number The table is self-referencing in that the parent_id points back to an ID. This structure renders a hierarchical listing of categories, with the root categories having a parent_id of -1. I have a SQL method to select category names and IDs by their parent ID: ID: Query_category_by_parid Arguments: parent_id:required:int Query: select id, name from category where <dtml-sqltest parent_id type=int> order by name I have a DTML method which calls itself recursively to find a list of categories starting with the specified parent: ID: list_categories <dtml-in "Query_category_by_parid(parent_id=parent_id)"> <dtml-var name> (<dtml-var id>) <dtml-var "list_categories(parent_id=id)"> </dtml-in> This however, doesn't work. It appears that the second call to Query_category_by_parid, within the second call to list_categories, fails. Here is the URL: /list_categories?parent_id=-1 This is the error I receive: Error Type: NameError Error Value: Query_category_by_parid And here is the traceback: Traceback (innermost last): File /usr/local/src/Zope-2.0.1/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/src/Zope-2.0.1/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/src/Zope-2.0.1/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/src/Zope-2.0.1/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/src/Zope-2.0.1/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: Query_category_by_coid_parid(parent_id=parent_id)) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_Util.py, line 321, in eval (Object: list_categories(parent_id=id)) File <string>, line 0, in ? File /usr/local/src/Zope-2.0.1/lib/python/OFS/DTMLMethod.py, line 141, in __call__ (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: list_categories) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: Query_category_by_coid_parid(parent_id=parent_id)) File /usr/local/src/Zope-2.0.1/lib/python/DocumentTemplate/DT_Util.py, line 321, in eval (Object: Query_category_by_coid_parid(parent_id=parent_id)) File <string>, line 0, in ? NameError: (see above) I have a feeling I'm missing something obvious, but I can't find it. Any help would be greatly appreciated. Cheers, Jim

2 2

Hit Counter ?
by Shalabh Chaturvedi 24 Nov '99

24 Nov '99

Is there a way to display the number of hits on a page ? ~Shalabh

2 1

DateTime help
by ScherBi＠BAM.com 24 Nov '99

24 Nov '99

My proxy is apparently not working well ( what else is new...), so I can't get to www.zope.org. Maybe someone can help me with this simple DateTime problem. I have a variable, accessible as <dtml-var lastLoginTime>. the value is functionally equivalent to int(time.time()). How can I turn this into a DateTime object within dtml so that I may format it eg, fmt=AMPM ? Thanks, Bill Scherer

2 1

Nesting ZClasses
by Alexandre Ratti 24 Nov '99

24 Nov '99

Hello, I'd like to nest ZClasses in the following way: TestFolderClass --- TestTopicClass --- --- TestItemClass Both FolderClass and TopicClass subclass ObjectManager. The problem is that I'd like to be able to add Item instances both in Topic instances and directly in Folder instances. Also I'd like to nest Topics. The following cases should all be allowed: TestFolder -- TestItem1 -- TestItem2 -- TestTopic1 -- -- TestItem3 -- -- TestItem4 -- -- TestTopic3 -- -- -- TestItem5 -- TestTopic2 etc. - If both TopicClass and ItemClass are defined at the same level (directly in FolderClass), I cannot nest Item in Topic (Item is not available on the Subobjects tab). - If ItemClass is defined in TopicClass then I cannot add Items directly in TestFolders (Item is not available on FolderClass's Subobjects tab). The only solution I can think of is creating an independant ZClass Product called Items. Then it will be available anywhere. But it messes up the Available Objects list. Is there a better solution ? Thanks. Alexandre

1 0

Re: [Zope] Calendar product
by Joshua Brauer 24 Nov '99

24 Nov '99

Is it just me or is the calendar product misssing from the Zope site again? I'd like to setup three calendars on one page... I have the name thing working so I can have three, but I'd like to have this month as well as last and next months. I can't figure how to get the date to the calendar so that it likes it. Josh At 8:09 PM -0500 11/23/99, technews(a)egsx.com wrote: >Hi Harry, > >I got all the options to work with the calendar product. This is a sample >code I made that has values set for each of the properties I tested. > > > > ><dtml-call "setCalendar('daynames','ABCDEFG')"> > > ><dtml-call "setCalendar('leftbgcolor','red')"> ><dtml-call "setCalendar('middlebgcolor','blue')"> > > ><dtml-call "setCalendar('padding','5')"> ><dtml-call "setCalendar('spacing','0')"> > ><dtml-if "mode=='month'"> > <a href=""></a> ><dtml-elif "mode=='day'"> >  ></dtml-if> > > > > > >Adonis > > > >_______________________________________________ >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 ) # # # _____________________________________________ Joshua Brauer Box 915 http://www.brauer.org Fort Collins, CO 80522 Fax: (419) 793-4120 _____________________________________________ In flying I have learned that carelessness and overconfidence are usually far more dangerous than deliberately accepted risks. -- Wilbur Wright in a letter to his father, September 1900 ____________________________________________________

2 1

RE: [Zope] about the IMAPAdapter Product product
by Michel Pelletier 24 Nov '99

24 Nov '99

> -----Original Message----- > From: al004151(a)alumail.uji.es [mailto:al004151@alumail.uji.es] > Sent: Wednesday, November 24, 1999 12:27 PM > To: zope(a)zope.org > Subject: [Zope] about the IMAPAdapter Product product > > > The lines 106-108 of the file "IMAPAdapter.py" are: > > def addIMAPAdapter(self, title='', default_domain='', > smtp_server='', smtp_port=25, imap_server='', > imap_port=143, roles, REQUEST=None): > > the roles parameter has no default value while REQUEST has, this gives > me an error. Shouldn't it be roles=''? The version you downloaded should have been taken off the web page weeks ago, my bad. You have an old version that was written with 1.5.1, which allowed this kind of construct with no error (even though it is wrong). NotMail and IMAPAdapter are now maintained by benno(a)sesgroup.net http://www.zope.org/Members/Benno/NotMail2 > And a question, the method validate begins: > def validate(self, request, auth='', roles=None): > """ """ > if 'NotMail' not in roles: <--- Why these two lines? > return None <--- It's a hack. -Michel

1 0

RE: [Zope] Welcome aboard!!
by Michel Pelletier 24 Nov '99

24 Nov '99

> -----Original Message----- > From: Steen Suder [mailto:CAB@kollegie6400.dk] > Sent: Wednesday, November 24, 1999 12:37 PM > To: zope(a)zope.org > Subject: Re: [Zope] Welcome aboard!! > > > Don't subscribe to the Zope mailinglist and show talent at the same > time! > > Digital Creations _will_ hire you! Everynow and then they unchain us from the desks for some bread and water. For thanksgiving they said we could see the sun if we wanted to, but I was afraid of going blind. Welcome Martijn! (..evil snicker...) -Michel

1 0

odbc database adapter ... problem with "like"
by Pate, Clarence T 24 Nov '99

24 Nov '99

Hello all! Is there a problem when using "LIKE" with the ODBC database adapteor? If you notice, the error message says alike instead of like. Is this normal? Is there a better way to perform a look up similar to this? Error message in browser: Z SQL Method at /recert / director / sqlDirectorEmployeeByLastName Error, sql.error: ('37000', -3100, " [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression '(((NAME) alike ``Pate*``))'.") SQL used: (in ZSQL method) select DIRECTOR_NAME, USERID, NAME, AUTHORIZED, TELECOMMUTER from test_directors_names where (((NAME) like ""Pate*"")); Valid Access SQL: SELECT nac_payroll_users_director_rc.USERID, nac_payroll_users_director_rc.NAME, nac_payroll_users_director_rc.DIRECTOR_NAME, nac_payroll_users_director_rc.AUTHORIZED, nac_payroll_users_director_rc.TELECOMMUTER FROM nac_payroll_users_director_rc WHERE (((nac_payroll_users_director_rc.NAME) like "Pate*")); Clarence T. Pate

3 3

Zope in education
by Timothy Wilson 24 Nov '99

24 Nov '99

Hi everyone, When I first became interested in Zope, I posted a question to the Zope list inquiring about potential uses in education. (See archive at http://lists.zope.org/pipermail/zope/1999-July/007378.html) There wasn't much response then, but now I'm convinced that we've reached some sort of critical mass of interest in using Zope in K-12 and higher education. In the past week alone, I've seen several posts from individuals or groups who are independently developing to planning to develop Zope apps. It seems to me that those who are interested in this area should be combining their efforts to accomplish their goals. I'm planning to pursue a grant to support something like this (more later) from the state of Minnesota and would love to hear from others. In a nutshell, I'm going to propose in my grant request that a connection be developed between our administrative database and our school's Web site. Most schools, even ones that aren't particularly technologically advanced, use some sort of administrative software for doing scheduling, attendance, recording grades for transcripts, etc. In our case we work with a consortium called TIES (http://www.ties.k12.mn.us/) that provides those services for us and many other school districts in Minnesota. I'd like to develop a system whereby students, teachers, or parents can log in to our Web site and immediately have access to information about the students. In other words, let's say that the teachers have some way to put assignments for their classes on the Web site. When the student logs in, they would be authenticated through LDAP to our server and then Zope would query the student database to find out what classes they're in. Then it would pull together all of the upcoming assignments for those classes and display them on the homepage. This is just one simple example. Image what other things could be done! I'm also interested in using XML to provide a layer (analogous to ODBC, I think) between the administrative software and Zope. I'm also part of the SEUL-EDU group (Simple End-User Linux), and one of the members of that group has done an amazing job creating an XML DTD for educational applications. It's called EDUML and you can read a description at http://roberts.vsb.bc.ca/zope/eduml) It also turns out that the author is using Zope on his Web site! (The site was unavailable for some reason this morning. It worked last night though, so check back if it doesn't work right away.) I realize that I've just scratched the surface here for the sake of brevity. I hope that some of you can get a feel for what I'm thinking about here. So what's next? * Is there sufficient interest to create a special interest group for Zope in education? The ZCommerce folks did this. * Would DC be interested in creating a special section of the Zope site for those interested in this area? I hope we can continue discussing this. There's too much potential here to ignore it. -Tim -- Timothy Wilson | "The faster you | Check out: Henry Sibley H.S. | go, the shorter | http://slashdot.org/ W. St. Paul, MN, USA | you are." | http://linux.com/ wilson(a)visi.com | -Einstein | http://www.mn-linux.org/

1 0