- Zope - Zope lists

Doing something to all objects of a given Meta Type
by Chris Withers 13 Mar '01

13 Mar '01

Hi, I ended up doing this today and thought others might find it useful: Say you want to do something to all objects of a given metatype, like update them for example, you can do this in a Python Script (I used an External Method, but they should be the same): stuff = context.ZopeFind(self,obj_metatypes=['Squishdot Site']) Stuff is now a list of tuples. Each tuple is of the form (object_id,actual_object) If this is useful to enough people, I'll stick it in a how-to cheers, Chris

1 0

addUser
by Paz 13 Mar '01

13 Mar '01

Hi all, I've been surfing around the .py's trying to find a way to add a user via dtml... Am I barking up a non-existant tree? I see alot of _addUser, doAddUser, manage_users.addUser, but nothing seems to work. Is there a method I can call? Thanks for input as always, I hold my wine glass up to you... Paz

4 3

Re: nisUserFolder
by Lee Marzke 13 Mar '01

13 Mar '01

I just found that the NISUserFolder at: http://www.zope.org/Members/jfarr/Products/NISUserFolder/ appears to install and work. What is the difference between the two. ? Lee On 13-Mar-01 Will Fife wrote: > I will have to restore it off of CD which means > finding the CD :) ... give me a couple of days, and > I'll send it to you. > > --- Lee Marzke <lmarzke(a)kns.com> wrote: >> Hi, >> >> The nisUserFolder product at >> ttp://www.zope.org/Members/zazen >> >> seems to be corrupted. Is their another copy or >> could you email one to >> me. >> >> Thanks, >> >> Lee Marzke <lmarzke(a)kns.com> >> >> >> > > > ===== > - Will > > -- This email printed on 100% recycled electrons. > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/ Lee Marzke <lmarzke(a)kns.com> 13-Mar-01, 14:00:12 Kulicke & Soffa Industries 2101 Blair Mill Rd +1 215 784-6217 Willow Grove, PA 19090 +1 215 784-6014 fax

1 0

dtml-tree recursion
by nuno 13 Mar '01

13 Mar '01

Hi there ! I trying to work with dtml-tree tag to show my site contents. I have a dtml-method that does that. Still, the calling Dtml Document passes to the method that shows the tree, a variable (kind of a parameter) that i need to access in the method. All goes OK : ) both the tree and the variable are displayed ! The problem is when i click the +/- icon Zope gives me an error that couldn't access the variable passed as argument. I think that it might be a problem with recursion of the tree. does anyone have an ideia how to solve this recursion problem ? thanks in advance and best regards, Nuno

1 0

Re: [Zope] Passing arg by URL
by Lee Marzke 13 Mar '01

13 Mar '01

I solved this by sending the arg via url mangling to a DTML method and then by normal args to the ZSQL method. Yes, even the ZOPE book describes that it should work the other way. Lee On 13-Mar-01 Paul Zwarts wrote: > Lee, > > I have had all sorts of similar problems with this, especially when I started > working on a system that used MySql instead of PostgreSQL.... > > Is the dtml document/method sending the variable as an int or str? > > <dtml-call "toZQLMethod(requestid=_.int(something)"> > > That should probably work. I had to convert a whole bunch of them when I > moved > databases.... can anyone explain to us WHY this is? > > Cheers, > > Paz > > > > Lee Marzke wrote: > >> Why doesn't calling dir/request_by_id/requestid/7 >> work with the following ZSQL method ? >> >> == request_by_id ZSQL method == >> <params>requestid:int</params> >> >> select * from table WHERE >> requestid=<dtml-sqlvar requestid type=int > >> >> I get the following error: >> >> Invalid integer value for requestid >> >> Traceback (innermost last): >> File /sw/scm/usr/var/Zope230/lib/python/ZPublisher/Publish.py, line 222, >> in >> publish_module >> File /sw/scm/usr/var/Zope230/lib/python/ZPublisher/Publish.py, line 187, >> in >> publish >> File /sw/scm/usr/var/Zope230/lib/python/Zope/__init__.py, line 221, in >> zpublisher_exception_hook >> (Object: request_by_id) >> File /sw/scm/usr/var/Zope230/lib/python/ZPublisher/Publish.py, line 162, >> in >> publish >> File /sw/scm/usr/var/Zope230/lib/python/ZPublisher/BaseRequest.py, line >> 363, >> in traverse >> File /sw/scm/usr/var/Zope230/lib/python/Shared/DC/ZRDB/DA.py, line 519, in >> __getitem__ >> (Object: request_by_id) >> File /sw/scm/usr/var/Zope230/lib/python/Shared/DC/ZRDB/DA.py, line 482, in >> __call__ >> (Object: request_by_id) >> File /sw/scm/usr/var/Zope230/lib/python/DocumentTemplate/DT_String.py, >> line >> 538, in __call__ >> (Object: <string>) >> File /sw/scm/usr/var/Zope230/lib/python/Shared/DC/ZRDB/sqlvar.py, line >> 183, >> in render >> (Object: requestid) >> ValueError: (see above) >> >> _______________________________________________ >> 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 ) > Lee Marzke <lmarzke(a)kns.com> 13-Mar-01, 13:15:55 Kulicke & Soffa Industries 2101 Blair Mill Rd +1 215 784-6217 Willow Grove, PA 19090 +1 215 784-6014 fax

1 0

ZSQL update operations
by Lee Marzke 13 Mar '01

13 Mar '01

Hi, I'm displaying a set of data from a ZSQL method. The showStatus method below works just fine. I would now like to have a link on each data item allowing an ZSQL update or delete operation. Can this be done by passing args to the ZSQL method vai the URL? I'm a beginner with Zope/ZSQL btw... I am partly unsure when the ZSQL method should define a parameter ( for instance to pass something by a URL, does that variable need to be a paramenter ) Thanks, Lee Marzke <lmarzke(a)kns.com> == statusALL DTML method == <dtml-in "objectValues('Folder')"> <dtml-var showStatus> </dtml-in> The following method shows data where the revname column is equal == showStatus DTML Method == <h3></h3> <table width="80%" border=0 cellpadding=5 cellspacing=0> <tr><th>ID</th><th>Name</th><th>Begin</th><th>End</th><th>Status</th></tr>   <tr bgcolor="#eeeeee">  <tr bgcolor="#ffffff">  <td></td> <td></td> <td></td> <td></td> <td></td> <td><a href="">Update</a></td> </tr>  </table> ===showPending() ZSQL method === SELECT requestid, revname, username, starttime, endtime, comment, status FROM tableR    status = 0  Lee Marzke <lmarzke(a)kns.com> 12-Mar-01, 10:58:07 Kulicke & Soffa Industries 2101 Blair Mill Rd +1 215 784-6217 Willow Grove, PA 19090 +1 215 784-6014 fax

2 5

Re: Connecting MS Access to Zope by ZODBC
by Capesius, Alan 13 Mar '01

13 Mar '01

Look at: http://twsite.bizland.com/zopetips1.htm

1 0

Re: Zope digest, Vol 1 #1246 - 50 msgs
by Diarmaid Lynch 13 Mar '01

13 Mar '01

Hi there, I'm setting up a MS Access database for a project I'm working and would like to use it with my Zope site.....having a little trouble though. Installed the Zope ODBC adaptor but don't know how to connect it to Zope? keeps giving me "bad request" errors when I try to specify a connection string / any connection string! Is there more to installing the ODBC adaptor than just importing it to the products folder? Seeking guidance ... Cheers

2 1

PostgreSQL on Win2K
by Adrian Madrid 13 Mar '01

13 Mar '01

Anybody out there using PostgreSQL on Win2k? I'd like to hear pointers on installation, performance and zope db adaptor used. I'm tied on using Win2K but I'd love to use an open source db. ===== --------------------------- Adrian Esteban Madrid Benson Institute, Webmaster Brigham Young University --------------------------- adrian_esteban(a)madrid.com =========================== __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

1 0

Default values in ZSQL methods
by Joel Burton 13 Mar '01

13 Mar '01

I have a ZSQL method, by_id, which accepts a 'staffid' as staffid:int=0 (allow an integer-only id, but default to zero.) The method is: select * from vlkpstaff <dtml-if "staffid > 0"> where staffid=<dtml-sqlvar staffid type=int> </dtml-if> (if a real staff ID was passed, use it in the where statement, otherwise show all records) The works great, even with direct traversal, so I can say things like http://www.foo.com/staffFolder/by_id/100 to get staff ID#100. However, in a DTML method, 'roster', I say: <dtml-in by_id> ... show staff info here ... </dtml-in> hoping to show *all* staff. Instead, I get *none*. If I call it explicity, as <dtml-in "by_id('staffid':0)"> ... </dtml-in> it works fine, but this is a bit ugly, and it creates dependencies on my keeping this staffid field w/the same name, etc. Of course, I could have two queries, by_id, and showAll, and this work fine, but again, it forces me to keep two queries in sync when keeping just one in sync feels right. Is there a way out of this little mess? -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

2 1