April 2001 - Zope - Zope lists

Zope 2.3.0 Under Windows 95
by John Gregory 04 Apr '01

04 Apr '01

Hi All First my apologies for inadvertently misdirecting replies to my previous post directly to respondents instead of to this list. Second any help on the following would be appreciated: I'm unable to open Zope 2.3.0 on my pc under Windows 95. I run start.bat and then point IE5 at http://127.0.0.1 but all I get is an IE error report "The page cannot be displayed. Cannot find server or DNS Error". I've followed recommended download/install instructions explicitly and AFAIK all the files are correctly located. Another server on my pc - Xitami - recognises the address http://127.0.0.1 so could it be that Zope 2.3.0, like MS Personal Server 4, cannot be run under Windows 95 except via a network? Regards jaygee

2 1

RE: [Zope] Get Column Names from SQL Query?
by Schmidt, Allen J. 04 Apr '01

04 Apr '01

I have a need for this type also. One table lists items with several varchar fields and about 40 Boolean fields (various options each item has or doesn't have). Another table (options) has 2 columns - option and optionDescription. The option is the column name of each of the Boolean fields and the optionDescription is a text description of each option. I need a query that will get all the details of an item and if any of the 40 options is set with a TRUE, then display the optionDescription from the 'options' table - not just a 1 or 0. So, I will need to compare the option name with the column name from the item table. SLIGHTLY off-topic but someone else started it! <8^) Thanks Allen -----Original Message----- From: Laurie Nason [mailto:laurien@tiger.bcm.tmc.edu] Sent: Wednesday, April 04, 2001 12:04 PM To: Thomas B. Passin; Zope Mailing List Subject: RE: [Zope] Get Column Names from SQL Query? I have found something that does this but haven't managed to make it work as I want it to yet! <dtml-let Fields="queries.qryreturnallusers().names()"> <dtml-in Fields> <dtml-var sequence-item></p> </dtml-in> </dtml-let> This gives the column headers If anyone knows of a way of doing this which gives the data as well as the headers in one fail swoop then let me know too. Laurie -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Thomas B. Passin Sent: Wednesday, April 04, 2001 10:51 AM To: Zope Mailing List Subject: [Zope] Get Column Names from SQL Query? I want to run an SQL query, like select * from person Then I want to extract the column names from the returned data. In other words, I don't want to hand-code them into the result page. I know how to do this in Cold Fusion, but I don't know how in Zope. I'm using a ZSQL method, of course, to query the database. Anyone know how to do this without running an external method? 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 ) _______________________________________________ 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 )

2 1

Re: [Zope] PageTemplates - TAL configuration
by Phil Aylesworth 04 Apr '01

04 Apr '01

Thanks, the permissions were screwy. I fixed that and now I am in! Yeah! Phil. > >When you untar the Zope, TAL, and PageTemplates archive files, you >should not be logged in as "root", since this sets the file and >directory ownership to garbage. In fact, you shouldn't ever untar an >archive generated on someone else's system as "root". > >Whichever user you use to run Zope (if you use "root", it switches to >"nobody" for you) should be used to unpack Zope and all of its Products. >That way, this user will have full access to all of the source files. > >Cheers, > >Evan @ digicool & 4-am > > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

RE: [Zope] Help: Zope is extremely slow
by Mayers, Philip J 04 Apr '01

04 Apr '01

That sounds suspiciously like the "Zope dying" problem that a lot of people seem to be having. You aren't by any chance using Postgresql are you? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Daniel Rusch [mailto:drusch@globalcrossing.com] Sent: 04 April 2001 19:33 To: zope(a)zope.org Subject: [Zope] Help: Zope is extremely slow Our user base has grown significantly in the last few weeks. Unfortunately at hours of peak usage Zope crawls to a halt and won't even serve up pages. we have NUMBER_OF_THREADS=4 would increasing this help? Actually when we I check the processes (with ps -fe | grep py) I only see two the root thread and the thread that runs as nobody? Anybody have any suggests to help the performance of the site? Dan _______________________________________________ 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 )

3 2

RE: [Zope] Help: Zope is extremely slow
by Mayers, Philip J 04 Apr '01

04 Apr '01

I'm rather hoping that Postgres isn't the problem, but I can reliably hang my Zope site using what I think should be fairly reasonable code. Could you try something for me - make a ZSQL query, a PythonScript, and a DTML document, and in the pythonscript do this: print context.standard_html_header(context,context.REQUEST) for v in context.SQL_query(param1='whatever'): print context.dtml_document(context,REQUEST, p1=v.p1, p2=v.p2, p3=v.p3, <etc...> p13=v.p13, p14=v.p14, p15=v.p15, p16=v.p16) print context.standard_html_footer(context,context.REQUEST) return printed The DTML document just has to contain anything: <P>Placeholder text</P> Then call the PythonScript (access it's URL) as *fast* as you can (say as fast a reasonable machine can generate the query). The more fields the SQL query returns (and thus the more named parameters to the DTML document), the easier it is to crash. I get a mix of semi-hangs (child 4 threads dying), hangs (one of the 4 dies, Zope locks up in handling a SIGSTOP as told by "strace -p pid -d", or coredumps with sigsegv). And no, there are no hardware problems. This only happens in very specific circumstances, but I can show you a page where it happens all the time. *Something* is going on, and it's crippling my development. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Steve Drees [mailto:drees@the-bridge.net] Sent: 04 April 2001 20:15 To: Mayers, Philip J; 'Daniel Rusch'; zope(a)zope.org Subject: RE: [Zope] Help: Zope is extremely slow > That sounds suspiciously like the "Zope dying" problem that a lot > of people > seem to be having. You aren't by any chance using Postgresql are you? Postgres is not necessarily the problem. Zope is solid as a rock at www.wejustrock.com and it is using postgresql.

1 0

Is there a limit to the size of the REQUEST space
by Daniel Rusch 04 Apr '01

04 Apr '01

Is there a limit to the size of the REQUEST space per user and in total. In other words if I have 100 users hit my site can they "use" up the REQUEST space that is available to them??? Dan

1 0

(no subject)
by Wu Man Qi 04 Apr '01

04 Apr '01

Hello, I would like to use CookieCrumbler to authenticate users without using the portal . Where I can find information about it ? Thanks, Man Qi

1 0

Re: [Zope] Building multiple documents from fragments(objects).
by Oliver Bleutgen 04 Apr '01

04 Apr '01

> ... > <div><h3>Build From Loop</h3> > <ul><li>fragment1</li></ul> > </div> > <div><h3>Build From Loop</h3> > <ul><li>fragment2</li></ul> > </div> > ... > Any further hints? substitute <div><h3><dtml-var name="title_or_id"></h3> with <div><h3><dtml-var "_[_['sequence-item']].title_or_id()" ></h3> and don't ask why dtml's syntax is so much nicer than perl ;-> short explanation: _['text'] fetches the object with name text, so _[variable] fetches the object with the name contained in variable. 'sequence-item' is a "forbidden" variable name in python (bc. of the '-'), so you have to write _['sequence-item'] inside the outer brackets above. cheers, oliver

1 0

Re: [Zope] PageTemplates - TAL configuration
by Philip Aylesworth 04 Apr '01

04 Apr '01

>>> Error Type: AttributeError >>> Error Value: _v_blocks >> This is a strange one. I'll have to try installing a setup like >> yours from >> scratch to see if I can replicate it; My CVS checkouts work fine. > I am getting the exact same thing. I have RedHat 7.0 with a fresh > install of Zope 2.3.1 and only TAL 1.0.0 and PageTemplates 1.0.0 > added. I tried previously with ParsedXML-1.0, as well, and got the > same error. Do I need ParsedXML-1.0? > The TAL seems to work fine from the command line using the test > > > script. Well, I tried this again on a different computer with a fresh RedHat 6.2 install, the rest the same as above. Again, I got the same _v_blocks error. Has anyone else seen this? Has anyone gotten TAL working from the standard packages? Any ideas? I really, really want to try TAL! Phil. -- Philip Aylesworth St. Clair College

2 1

Form to file.
by Jason C. Leach 04 Apr '01

04 Apr '01

hi, I have a form and I need the contents, when filled out, to be appended to a coma separated list (line) in a file. What's the best way to do that? Can I do it in the DTML or should it be an External method? j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

3 3