- Zope - Zope lists

Separating assignments in Z SQL Updates
by Bruce Eckel 14 May '01

14 May '01

I'm trying to write a ZSQL method that will do a general update to a record. I started out attempting to do what I thought was the 'normal' thing: update Table set name1='value1', name2='value2', name3='value3' [...] where id='idvalue'; I wanted to use dtml to automatically build a statement that would only assign values if new values existed. The problem with this is the commas: you have to have commas between the assignments, but you can have a comma after the last assignment. And I couldn't figure out how to conditionally insert the commas. After fooling around and hunting for awhile, the best I could come up with is a separate 'update' statement inside an 'if', for each field. So it looks like this: <dtml-if due_date> update Invoices set due_date = <dtml-sqlvar due_date type="string"> where <dtml-sqltest invoice_id op=eq type=string><dtml-var sql_delimiter> </dtml-if> <dtml-if purchase_order_id> update Invoices set purchase_order_id = <dtml-sqlvar purchase_order_id type="string"> where <dtml-sqltest invoice_id op=eq type=string><dtml-var sql_delimiter> </dtml-if> <dtml-if ship_name> update Invoices set ship_name = <dtml-sqlvar ship_name type="string"> where <dtml-sqltest invoice_id op=eq type=string><dtml-var sql_delimiter> </dtml-if> This works, but it seems awfully awkward to me. Is there a way to insert commas instead, or a better solution in general for this problem? Thanks. Bruce

3 2

Re: [Zope] Squishdot News
by Karl Anderson 14 May '01

14 May '01

"Phil Harris" <phil.harris(a)zope.co.uk> writes: > Another thing, > > If you're going to use it then you might want to drop a line to Karl at > digicool, he uses it as the basis of ParsedXML (at least at the moment). We use our own checkout of pyexpat for ParsedXML, but only because we need some features that aren't in the release yet. > From: "Chris Withers" <chrisw(a)nipltd.com> > To: "Phil Harris" <phil.harris(a)zope.co.uk> > Cc: <squishdot(a)yahoogroups.com>; <zope(a)zope.org> > Sent: Monday, May 14, 2001 4:56 PM > Subject: Re: [Zope] Squishdot News > > How would I got about building a very simple parser that has hooks for > open > > tags, closing tags, entities and data? Docs are at the xml-sig pages, get there from python.org. For an example, see how ParsedXML does it in the ExpatBuilder.py file of its distribution. -- Karl Anderson karl(a)digicool.com

1 0

RE: [Zope] ODBC DSN file
by Menard.Jean-Francois＠hydro.qc.ca 14 May '01

14 May '01

I found that I can pass the filename of the Excel file I want in the connection string with the DBQ parameter. How could I pass this parameter in the Z ODBC connection string? Have I to modify the Zope source code? If so, wich file? -----Message d'origine----- De : Menard.Jean-Francois(a)hydro.qc.ca [mailto:Menard.Jean-Francois@hydro.qc.ca] Envoyé : lundi 14 mai 2001 12:03 À : tpassin(a)mitretek.org; zope(a)zope.org Objet : RE: [Zope] ODBC DSN file Thanks Thomas, good idea. I will use LocalFS to list all the files in my directory. All I need, is a way to change the DSN parameters on the fly to point to the needed Excel file. I don't want to create 100 DSN!!! That's why I wonder if Zope can use File DSN instead of Sytem or User DSN. Maybe there would be a way to import my Excel sheets without ODBC? I need them the way they are, not in CSV format or anything... But again, thanks for the tip! -----Message d'origine----- De : Thomas B. Passin [mailto:tpassin@mitretek.org] Envoyé : lundi 14 mai 2001 11:45 À : zope(a)zope.org Objet : Re: [Zope] ODBC DSN file [Menard.Jean-Francois(a)hydro.qc.ca>] I created an ODBC System DSN, and it work fine. But I have about 100 excel files, and I would like to develop an interface with a dropdown list with all the excel files in my directory, choose one, and import it. Any ideas how I could do that? I tried to create a File DSN, but Zope doesn't seem to detect it. With such a connection, I could change the connection string into the DSN file when needed. [Tom] If you always know where the files are located, you could use the LocalFS product. Or you could write a simple python external method. Cheers, Tom P _______________________________________________ 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

Re: Exception from connection close was: Re: [Zope] (no subject)
by Peter de Jong 14 May '01

14 May '01

Thak you for your reply, I don't think this is the only problem; I am afraid that Zope on my machine is very instable; it starts an new process each time I try to change and test a sql-method (at least from a Opera-client; from Netscape changing an testing of the same method results in killing the server). Hardly a robust platform. I don't know what further to do. sincerely Peter de Jong 14-05-2001 17:23:30, Tino Wildenhain <tino(a)wildenhain.de> schreef: >Hi Peter, > >this is usually the result of the user side closed >connection before zserver was ready with serving. >This may indicate there are some querys which take >a long time so the user hits the "stop" button on >her/his browser. > >Regards >Tino Wildenhain >

3 2

Permissions Problems
by Rahsheen Porter 14 May '01

14 May '01

I've been messing with Zope for about a day and a half and have already managed to break something (I think). I am unable to delete any previously created folders with any of my manager accounts or the main admin account. I also cannot View *anything*, but can still manage users in all my folders as well as edit files in those folders. I have one folder that I can't even access at all no matter who I log in as. I can't even view the Quickstart or the main root page. I have deleted all the acl_user folders from all my sub-folders. I have made sure the Security settings in root and all of my folders make sense (Manager can do everything, Anon can view not change, Owner can do nothing). Yet I can't do anything useful. It seems like my entire site is private, but the settings for root don't coincide with this. Any help is greatly appreciated, this is driving me nuts. -- Rahsheen Porter __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

1 0

Check for bad links?
by Paul Winkler 14 May '01

14 May '01

Hi, Does anyone know a free, Zope-friendly link checker? It's tedious hunting down bad URLs in my pages by hand. The link checking programs I've tried don't seem to like Zope... -- ................... paul winkler .................... custom calendars & printing: http://www.calendargalaxy.com A member of ARMS: http://www.reacharms.com home page: http://www.slinkp.com

4 3

ZExternalNews crashing things for my Connection
by Peter Bengtsson 14 May '01

14 May '01

I installed ZExternalNews and set up a couple of Managers in a test folder. Restarting Zope with -D in the DOS propmt, this is the first two lines: ZExternalNewsManager AutoUpdate started, will awake every 15 minutes. ZExternalNewsManager AutoUpdate started, will awake every 15 minutes. And after the usual info about hostname and such, this error message is printed: 2001-05-14T15:32:04 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\0 0\002\243[' Traceback (innermost last): File C:\PROGRA~1\Zope\lib\python\ZODB\Connection.py, line 477, in setstate AttributeError: 'None' object has no attribute 'load' Zope works. And it is difficult to know if it's slowed or not because it's "too fast" here on my localhost. The errormessage comes from the Zope component lib/python/ZODB/Connection.py Do you have any ideas why this is so? Is it bad? What to do? If you need more details, tell me and I shall try. The usual: Zope Version Zope 2.3.0 (binary release, python 1.5.2, win32-x86) Python Version 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform win32

1 0

RE: [Zope] ODBC DSN file
by Menard.Jean-Francois＠hydro.qc.ca 14 May '01

14 May '01

Thanks Thomas, good idea. I will use LocalFS to list all the files in my directory. All I need, is a way to change the DSN parameters on the fly to point to the needed Excel file. I don't want to create 100 DSN!!! That's why I wonder if Zope can use File DSN instead of Sytem or User DSN. Maybe there would be a way to import my Excel sheets without ODBC? I need them the way they are, not in CSV format or anything... But again, thanks for the tip! -----Message d'origine----- De : Thomas B. Passin [mailto:tpassin@mitretek.org] Envoyé : lundi 14 mai 2001 11:45 À : zope(a)zope.org Objet : Re: [Zope] ODBC DSN file [Menard.Jean-Francois(a)hydro.qc.ca>] I created an ODBC System DSN, and it work fine. But I have about 100 excel files, and I would like to develop an interface with a dropdown list with all the excel files in my directory, choose one, and import it. Any ideas how I could do that? I tried to create a File DSN, but Zope doesn't seem to detect it. With such a connection, I could change the connection string into the DSN file when needed. [Tom] If you always know where the files are located, you could use the LocalFS product. Or you could write a simple python external method. Cheers, Tom P _______________________________________________ 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

HELP! Double outputs!
by Paul Zwarts 14 May '01

14 May '01

Oh woe is the day.... I'm totally frazzled by this. I have moved a test zope install to a unix server running another one. Both are configured for separate ports... I have a structure something like this <var logic> <var header> <var orderform> <var footer> (very basic description) What I get is: <var logic> - okay <var header> - okay <var orderform> - okay <var orderform> - not okay <var footer> This application lives on several test machines and none of them have any such problems. What duplicates is also very selective as well... Im not sure where to go for debug info... z2.py started with the -D optioin shows nothing. Apache shows nothing (even though the problematic zope is refferenced directly to ZServer through port 8085) The logging of REQUEST and SESSION reveal nothing. Putting in <dtml-var sequence-key> doesnt show an miscreant <dtml-in> that loops one two many. I am really lost.... Its Zope-232 with PGSQL703, PoPy 2.01 and the latest ZPoPy adapter. Perhaps there is a bug here or someone has expereinced the same thing? I cant be more than vague without writing an essay... But perhaps someone can tell me how to monitor the Zope stack? Thanks very much, Paz

4 6

Re: zope hangs vs: Re: [Zope] ZServer Must Be Continually Re-Started: my Method to stop zope dead:
by Dieter Maurer 14 May '01

14 May '01

Tino Wildenhain writes: > The problem below is zope not responding to requests > but still beeing running. I made a funny experience recently: One of our low load Zope installations went into this hanging state regularly. I had the impression, it happened every day. Then I activated a checker, that checks availability every 5 minutes. The problem went away. Since then, Zope never hung again. Maybe, Zope does not like to be lazy? Dieter

5 4