- Zope - Zope lists

Problems with "Subselect" in SQL statment
by Florian Schuler 05 Nov '01

05 Nov '01

Hello List, I have a problem using ZSQL Methods. If I do something like this: select * from person where id != (Select userid from projektmitglieder where projektid='20'); Zope gives me an error ! Error Type: ProgrammingError Error Value: ERROR: More than one tuple returned by a subselect used as an expression. select * from person where id != (Select userid from projektmitglieder where projektid='20'); But if I try this on the test chapter of my DB adapter is works and the ZSQL Method also works well if I call it manually !! Does someone knows a solution Thanks in advance Florian Schuler

2 1

performance testing running zope-system?
by Thomas Boettger 05 Nov '01

05 Nov '01

Hallo, has someone any experiences in testing a running Zope system. Actually I mean performance under hard pressure. If so we would like to get in touch. Regards Thomas Boettger ------------------------------------------------------ Media Meter GmbH + design production monitoring Hans-Poeche-Str.2-4 + D-04103 Leipzig fon +49 (0)341 1499 605 + fax +49 (0)341 1499 558 mobile 0172 7942248 + http://www.media-meter.de disclaimer: http://www.media-meter.de/disclaimer.htm -------------------------------------------------------

1 0

Re: [Zope] Using Extreme Programming with Zope
by Oliver Erlewein 05 Nov '01

05 Nov '01

Hi I'd also be willing to help. Please keep me posted on that. I've got very good knoledge on softwaretesting of applications (Module test, functional testing, integration testing & webtest). Thanx Oliver Erlewein -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net

1 0

RE: [Zope] compressing data.fs while offline
by Fritz Mesedilla 05 Nov '01

05 Nov '01

If I upgrade to Red Hat 7.2 will this 2GB problem go away? fritz <www.mesedilla.com> systems administrator summit interactive, inc. www.fhm.com.ph | www.femalenetwork.com | www.candymag.com --- +basta ikaw lord > -----Original Message----- > From: Chris Withers [mailto:chrisw@nipltd.com] > Sent: Monday, 5 November 2001 8:33 PM > To: Fritz Mesedilla > Cc: Zope Mailing List (E-mail) > Subject: Re: [Zope] compressing data.fs while offline > > > > Fritz Mesedilla wrote: > > > > is it possible to compress data.fs while zope is not running? > > > > zope stopped working because of the 2gb limit. > > > > now i hope to be able to compress it so zope whill run again. > > That way leads to ruin and damnation ;-) > > Just sort yoru OS out so you can get files >2GB :-P > > Chris >

1 0

compressing data.fs while offline
by Fritz Mesedilla 05 Nov '01

05 Nov '01

is it possible to compress data.fs while zope is not running? zope stopped working because of the 2gb limit. now i hope to be able to compress it so zope whill run again. is this possible? fritz <www.mesedilla.com> systems administrator summit interactive, inc. www.fhm.com.ph | www.femalenetwork.com | www.candymag.com --- +basta ikaw lord

2 1

Zope and MySQL
by Horst Wald 05 Nov '01

05 Nov '01

Hi, I'm still trying to connect MySQL and ZOPe and I've been a little bit too quick last time; I have to use SUSE LINUX 7.0, so which ZMysqlDA or MySQLdb or Mysql-Python am I to use with it? Lately someone told me that if you're using SUSE you must'nt install MySQL with YAST because that would put it into some directory where the adapter does'nt expect to find it. I'm really no expert, is'n there any step-by-step-howto that one can understand without being one? I really searched zope.org, I found nothing helpful. Horst _________________________________________________________________ Downloaden Sie MSN Explorer kostenlos unter http://explorer.msn.de/intl.asp

1 0

[Fwd: RE: [Zope] conflict error]
by Adam Warner 05 Nov '01

05 Nov '01

Sorry Prabu I do not know the answer. I've forwarded your message to the list. You should still supply the error message details. Regards, Adam -----Forwarded Message----- From: prabu <ajprabu(a)yahoo.com> To: Adam Warner <lists(a)consulting.net.nz> Subject: RE: [Zope] conflict error Date: 05 Nov 2001 15:58:12 -0800 Tx Adam, I ve used a python function replaceQuote(objectname) as a python script in zope. The content of the replaceQuote function is ResString='' UnfString=strParam if not UnfString: return(ResString) UnfString_Len=len(UnfString) UnfString_Cnt=0 while UnfString_Cnt < UnfString_Len: Unf_Char=UnfString[UnfString_Cnt:UnfString_Cnt+1] UnfString_Cnt=UnfString_Cnt+1 if Unf_Char=='\'': ResString=ResString+'\\'+Unf_Char elif Unf_Char=='\\': ResString=ResString+'\\'+Unf_Char elif Unf_Char=='\"': ResString=ResString+'\\'+Unf_Char else: ResString=ResString+Unf_Char return(ResString) This function will replace the single quote('), double quote(") and slash(\) to a set of character which is prefixed with slash(\). I m calling this function as below whenver the objectname is accessed by a ZSQL method. (Becoz ZSQL method raises a zope error if the object name is inserted with special characters(',",\).) <dtml-let Py_Product1="replaceQuote(Product1)"> <dtml-call "Insert_CSTable(Py_Product1)"> </dtml-let> The problem is - I m calling this replaceQuote function often throughout the page. Sometimes if more number of users are accessing the same page the Conflict Error occur. Can I solve this problem anyway. Prabu _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

2 1

Logging in a user programatically...
by Rob Foster 05 Nov '01

05 Nov '01

At the risk of asking too many questions... First of all, I should mention that a vast majority of the novice as well as intermediate questions in this group seem to be targeted at User/Role/Permission/Login related problems. Maybe someday, we'll get better documentation/examples on these types of issues. Now for the question: I've got a form that allows a new user to create a login for themselves in the acl_users folder. I want to be able to immediately log them into the system when their account is created (possibly in the same script). I've searched everywhere for examples of this in Python or DTML and can't find what I'm looking for. If someone could help with an example and possibly some suggestions on whether this is even a good idea, I would appreciate it. Thanks to all the Zopistas for fielding all the questions... Hopefully I can do the same someday :) -Rob

3 3

Upload to a subfolder using an External Method
by Adam Warner 05 Nov '01

05 Nov '01

Hi all, This is the relevant part of my Python External Method that uploads an HTML file called output.xhtml to the current folder (and is given the name id). newfile=open('output.xhtml','r') newfile.seek(0) self.manage_addFile(id,newfile,content_type='text/html') newfile.close() I would instead like to upload to a pre-existing subfolder called 'cached' (although creating a folder would be no big deal: self.manage_addFolder(...)). I haven't found an applicable command in the Zope Quick Reference to change the current Zope directory: http://www.zope.org/Members/ZQR http://www.zope.org/Members/ZQR/zqr/printable I imagine the command would look something like self.manage_changeFolder('cached') I know it sounds easy but I'm stumped. Perhaps this has to be done in a Python Script after the file has been uploaded to the Zope database? Many thanks, Adam PS: I'm really happy because Debian Unstable now contains the latest versions of Zope and Python. Thanks Gregor Hoffleit :-)

2 2

Fw: [Zope] sos - help is needed in asap!!!
by Elena Solomou 05 Nov '01

05 Nov '01

> > Dear Zope organization, > > > > My name is Eleni and it is my first time that I am writing to you for > > help. I have registered as a member but I didn't succeded to contact > > with someone. I am writing to you for giving an answer to my question > > that nobody can give me. Well, I will explain the nature of my problem > > with > > DTML-doc and properties. > > 1.I have created a folder (main). > > 2.Inside in this folder I created another subfolders. > > 3.I have written a code in a dtml-document in main folder > > to give a sortID (string) property in each subfolder. > > 4.Whenever I execute my DTML-DOC code it shows all the values > > of sortIDs that it has assigned in each subfolder. > > 5.I want to take all sortIDs values e.g. sortID=111, > > sortID=112, ...etc to be assigned in the properties of > > main folder in the field of mainNavigationLinks - lines. > > Can you give me possible solutions to my step 5 problem pls??? > > Your help will be further appreciated! > > > > Usually you would run something like that: > > <dtml-in expr="main.objectValues('folder')" sort="sortID"> > <a href="&dtml-absolute_url;"><dtml-var title_or_id></a><br> > </dtml-in> > > Hint: you dont need to double the list of links into a property > on your mainfolder. > Hint2: you dont need this extra sortID. Subobjects have a natural order. > Although the ZMI shows them sorted on Id, title, size and so on, > they have the order in which they are added. If you cut&paste > an object into the same folder, it is automatically at the end of the > list. > > Regards > Tino Wildenhain Dear Tino, I used the above code 2 weeks ago. Pls, wait to understand what I want: Firstly, I need this sortID because my users want to sort/index the rest of items using the FIRST, UP, DOWN & LAST BUTTONS (it was done by javascript with DTML on single folder and worked and I want to apply it on multiple folders). The what I want is a coding that stores all sortIDs values from all subfolders to be stored in another field of the main folder called mainNavigationLinks - (lines and no string in order to store all sortIDs values there) situated in the properties of the main folder. Therefore I will able to use the first, up, down, last buttons coding to manipulate the stored values. If sth is unclear or it seems complicate to you pls let me know. Love from Elena. ps. I see all sortIDs and their description on the output-VIEW of my DTML-doc situated in main folder but I want to store/capture them!!!

1 0