- Zope - Zope lists

Python script bug: map
by Li Dongfeng 07 Jul '01

07 Jul '01

Try this simple python script: print map(None, (1,2)) return printed in standalone python this should produce ['1','2'] but in zope-2.4.0b3 we get an error: Error Type: TypeError Error Value: loop over non-sequence a sneak at the code in lib/python/AccessControl/ZopeGuards.py, the error occured in function "guarded_map", the parameter "seqs" should receive "(1, 2)" but instead it received "((1,2),)". This bug is reported to the collector as No. 2382. Li Dongfeng

1 0

ZSQL select on date/time
by Loren Stafford 07 Jul '01

07 Jul '01

Does anyone have a working example of how to select on a date/time column in an MSAccess database. Something like Arguments: FromDate:date select * from "Applicant Database" where [Date Received] > <dtml-sqlvar FromDate type=float> ...except the above syntax produces: Error type: sql.error Error value: ('07001', -3010, '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.') ...regardless of value of type. -- Thanks -- Loren

3 4

Re: [Zope] ZPhotoAlbum and images in general
by Frank McGeough 07 Jul '01

07 Jul '01

I think the question comes up a lot because when you have a db that is non-relational, it's extremely difficult to get a handle on it's performance / reliability. With a relational database there are some standard benchmarks (granted the vendors manipulate these in various ways but you can get a fairly good idea of their general performance). The anecdotal, it's fast because I've seen it's fast is not quite as good as a standard test. Most of the sql database vendors provide some means for managing the underlying files that actually store the data. Allowing me to add more, put them on separate partitions, etc. They also make it fairly easy to get the doc on how they layout the storage in these data files. They actually feature that in their development oriented doc -- to show how much better their technique is then other vendors. To reduce the number of questions in this area, it seems like these two issues should be addressed. Anecdotally :) --- I've become more comfortable with the Zope approach through usage and gathering the doc that is available in various places. Thanks for the feedback. ----- Original Message ----- From: seb bacon Sent: Wednesday, July 04, 2001 2:17 PM To: Steve Drees Cc: Frank McGeough; Zope@Zope. Org Subject: Re: [Zope] ZPhotoAlbum and images in general * Steve Drees <drees(a)the-bridge.net> [010703 20:38]: > > is storing everything in one big file makes me extremely nervous. Probably > > doesn't matter for smaller web sites but if I actually wanted to use this > > for larger sites it would be a real sticking point. Any advice on this > > point? > > Most databases store everything in a few large files. Why is one large file > worse? > ZODB is a real database. It's a real good database. I just had to chip in and repeat your point again just to emphasise it, since this question comes up so much :-) I would always use the ZODB FileStorage unless there was a very good reason not to. It's fast, supports undos, is easy to back up, and keeps all your application in one place. The only two good reasons, not to do so are: 1) if your OS has a nastily small file size limit (e.g. pre-2.4 Linuxen) 2) If you need to access the same data from elsewhere (e.g. membership data in an LDAP storage) sebGet more from the Web. FREE MSN Explorer download : http://explorer.msn.com

1 0

[Info] Bug 2360
by James E. LaBarre 07 Jul '01

07 Jul '01

RE: [2360] Zope Bug: 2.4.0b2 still doesn't run on windows I am running Windows 2000, SP1, Thinkpad 600, 223(?)MB ram, and have tried versions of Zope from 2.3.2 through 2.4.0b3. All have exhibited similar crashes to the one listed in the above bug. Below is a copy of the DrWatson dump from a crash with 2..0b3. "python.exe - Application Error The instruction at '0x00008e8' referenced memory at '0x000008e8'. the memory could not be 'read'" ============================================================== Microsoft (R) Windows 2000 (TM) Version 5.00 DrWtsn32 Copyright (C) 1985-1999 Microsoft Corp. All rights reserved. Application exception occurred: App: (pid=1696) When: 7/6/2001 @ 16:55:01.150 Exception number: c0000005 (access violation) *----> System Information <----* Computer Name: MATERIAL User Name: labarre Number of Processors: 1 Processor Type: x86 Family 6 Model 5 Stepping 0 Windows 2000 Version: 5.0 Current Build: 2195 Service Pack: 1 Current Type: Uniprocessor Free Registered Organization: IBM Registered Owner: material *----> Task List <----* 0 Idle.exe 8 System.exe 136 smss.exe 164 csrss.exe 160 winlogon.exe 212 services.exe 224 lsass.exe 364 svchost.exe 424 svchost.exe 476 spoolsv.exe 468 MWMDMSVC.exe 528 trcboot.exe 544 MWSSW32.exe 612 defwatch.exe 648 dtocsrvc.exe 684 inetd32.exe 692 jconfigdNT.exe 708 ldlcserv.exe 720 hjavaw.exe 732 rtvscan.exe 792 javaw.exe 856 regsvc.exe 876 MSTask.exe 908 WinMgmt.exe 1060 MsgSys.exe 1276 Explorer.exe 1332 tphkmgr.exe 1340 tp4serv.exe 1356 vptray.exe 1364 Deskmenu.exe 1320 mozilla.exe 1392 HotSync.exe 1508 Connect.exe 1244 activmon.srv.exe 796 EditPad.exe 1604 PDExplo.exe 1612 cmd.exe 1696 python.exe 1592 netscape.exe 1712 drwtsn32.exe 0 _Total.exe (00400000 - 00405000) (77F80000 - 77FFA000) (1E100000 - 1E1AF000) (77E80000 - 77F35000) (77E10000 - 77E74000) (77F40000 - 77F7C000) (77DB0000 - 77E0A000) (77D40000 - 77DB0000) (69800000 - 69A42000) (77C70000 - 77CBA000) (77B50000 - 77BD9000) (78000000 - 78046000) (1E1D0000 - 1E1D8000) (75050000 - 75058000) (75030000 - 75044000) (75020000 - 75028000) (1D110000 - 1D115000) (10000000 - 10025000) (00AD0000 - 00ADE000) (00BF0000 - 00BFD000) (00D10000 - 00D23000) (75090000 - 750A0000) (00E40000 - 00F02000) (30400000 - 30425000) (30300000 - 3031E000) (76B30000 - 76B6E000) (74FD0000 - 74FED000) (77340000 - 77353000) (77520000 - 77525000) (77320000 - 77337000) (75150000 - 7515F000) (75170000 - 751BF000) (77BE0000 - 77BEF000) (751C0000 - 751C6000) (77950000 - 77979000) (77980000 - 779A4000) (77A50000 - 77B45000) (779B0000 - 77A45000) (773B0000 - 773DE000) (77380000 - 773A2000) (77830000 - 7783E000) (77880000 - 7790D000) (77C10000 - 77C6D000) (774E0000 - 77512000) (774C0000 - 774D1000) (77530000 - 77552000) (77360000 - 77379000) (691D0000 - 69255000) (75010000 - 75017000) State Dump for Thread Id 0x588 eax=00000000 ebx=0012dee0 ecx=0012de74 edx=00000000 esi=00136548 edi=0012eee8 eip=000008e8 esp=0012de40 ebp=0012de84 iopl=0 nv up ei pl nz ac po nc cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000216 function: <nosymbols>

2 1

RE: [Zope] Zope 2.3 nominated for Webtechniques Web Tools readerschoice award
by Gilger.John 06 Jul '01

06 Jul '01

On 06 Jul 2001 16:43:18 -0500, Farrell, Troy wrote: > I move we form the 'web swiss army knife' category. Then Zope will be in a > class of it's own. Michael Bernstein replied: Web Swiss Army Chainsaw That name is already taken by Perl ;) John Gilger _

1 0

Re: [Zope] Determining Local Roles
by Flynt 06 Jul '01

06 Jul '01

Eric Vautour wrote: > > Hey, > thanks for the response. Did you have to import a library before this would > work? I tried > > "from AccessControl import import getRolesInContext" > > but it didn't seem to work, what did you do? > Hi Eric, you don't have to import anything. The expression: <dtml-var expr="AUTHENTICATED_USER.getRolesInContext(this())"> is right there in a DTML method. When I was looking for that stuff myself, I searched the mailing list archives. Got to: http://zope.nipltd.com/public/lists/zope-archive.nsf/ and search for *getRolesInContext*. I also use it in an external method. I show the users on the site, who has *Editor* roles on a specific object. The code for the external method is: def showEditors(self, role, userfolder, obj): """ This function gets the users, who have a certain role *role* in context of object *obj* and gives back a list of those users. In *userfolder* the actual userfolder object has to be brought in (this is usually *acl_users*). """ roles = {} editors = [] userids = userfolder.getUserNames() for userid in userids: user = userfolder.getUser(userid) roles[userid] = user.getRolesInContext(obj) for k in roles.keys(): for v in roles[k]: if v == role: editors.append(k) return editors Also here, I don't have to import anything. For example I can call the above (external) method from a dtml method like (id of the external method is *showEditorsExt*): <dtml-if expr="_.len( showEditorsExt('Editor', _['acl_users'], this()) ) > 0"> <dtml-in expr="showEditorsExt('Editor', _['acl_users'], this())"> <dtml-var sequence-item><br> </dtml-in> <dtml-else> -- Nobody -- </dtml-if> And all this works quite nicely with local roles. The *Editor* role is set mostly as a local role in my case. HTH --- Flynt

1 0

RE: [Zope] Zope 2.3 nominated for Webtechniques Web Tools readers choice award
by Farrell, Troy 06 Jul '01

06 Jul '01

I move we form the 'web swiss army knife' category. Then Zope will be in a class of it's own. Troy -----Original Message----- From: Steve Drees [mailto:drees@the-bridge.net] Sent: Friday, July 06, 2001 1:45 PM To: Shane Hathaway; zope(a)zope.org Subject: RE: [Zope] Zope 2.3 nominated for Webtechniques Web Tools readers choice award > "Michael R. Bernstein" wrote: > > Zope 2.3 is featured in the 'infrastructure' category, rather than > > 'strategy' or 'development', but I suppose each person will see that > > choice differently. > > I'm glad Zope is featured in the poll, but why do they force readers to > compare Zope, PostgreSQL, Mandrake, WebTrends, a syndication server, > etc? Apples and oranges... Mandrake is not better than Zope and Zope is > not better than Mandrake! Agreed. Plus I use zope and postgres together all the time. Which is better? I don't know. In their respective domains I feel they are each the best 'free' choice available, if not simply the best choice. I still voted for Zope.

2 1

RE: [Zope] SybaseDA2.0v2 installation problem
by Peter Borocz 06 Jul '01

06 Jul '01

Jason, I haven't done Sybase in quite a while but somewhere you'll probably have to point to your local installation of the Sybase client. Within which should be both an include directory containing the respective CT-Lib header files (for the compile step) and a lib directory with link libraries (ctlib.so or libct.a or somesuch). Hope this helps Peter Borocz -----Original Message----- From: Jason Joy [mailto:kyroraz@usa.net] Sent: Friday, July 06, 2001 1:58 PM To: zope(a)zope.org Subject: [Zope] SybaseDA2.0v2 installation problem Hello, I have a feeling I am doing something really silly or I'm simply missing something here. I retrieved and installed the rpm for sybase 11.9.2 (common) and then untarballed the sybaseDA package ... and then followed the instructions as far as how to make it, and got this at the "make" stage? Is there a package that I am supposed to have to make this work in Zope that I just forgot to install, or... something even simpler? This is what happens... > make gcc -fPIC -I/include -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 - DHAVE_CONFIG_H -c ./sy_occ.c In file included from ./sy_occ.c:47: ctpublic.h:23: cspublic.h: No such file or directory make: *** [sy_occ.o] Error 1 Any thoughts or ideas on this would be appreciated. Jason _______________________________________________ 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 ) ------------------------------------------------- PLEASE READ THIS WARNING: All e-mail sent to or from this address will be received or otherwise recorded by the Fisher Investments corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient.

1 0

passing method names into a python script?
by Kevin L 06 Jul '01

06 Jul '01

I want to pass the name of a Z SQL Method into a python script, then execute that method and iterate over the results. Is this possible? My app uses a lot of dropdowns populated from database tables. Rather than rewriting the code for each one, I'd like to create one python script that takes a z sql method as a parameter, then executes it and spits out the html for the dropdown. Every Z SQL Method would return the same column names (id & value). Has this been done before? thanks -Kevin __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

3 2

SybaseDA2.0v2 installation problem
by Jason Joy 06 Jul '01

06 Jul '01

Hello, I have a feeling I am doing something really silly or I'm simply missing something here. I retrieved and installed the rpm for sybase 11.9.2 (common) and then untarballed the sybaseDA package ... and then followed the instructions as far as how to make it, and got this at the "make" stage? Is there a package that I am supposed to have to make this work in Zope that I just forgot to install, or... something even simpler? This is what happens... > make gcc -fPIC -I/include -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 - DHAVE_CONFIG_H -c ./sy_occ.c In file included from ./sy_occ.c:47: ctpublic.h:23: cspublic.h: No such file or directory make: *** [sy_occ.o] Error 1 Any thoughts or ideas on this would be appreciated. Jason

1 0