- Zope - Zope lists

strange: Product not shown in ZClass drop down
by Marcus Schopen 10 Aug '01

10 Aug '01

Hi, can't find a self created product in the ZClass drop down list to create a object of this class. This happens from one day to the other. Bye Marcus _______________________________________ (0> Marcus Schopen //\ P.O. Box 10 25 25 V_/_ 33525 Bielefeld, Germany _______________________________________ Live as variously as possible

1 0

<dtml-whois> tag don't work Problem solved
by Marcello Lupo 10 Aug '01

10 Aug '01

I solved my problem renaming the product dir from whoistools-0.1 in whois and it now works. Thanks Bye Marcello

1 0

Re: [Zope] ZMySQLDA
by Stephan Goeldi 10 Aug '01

10 Aug '01

>From: Vincenzo Di Somma <e.disomma(a)icube.it> >Stephan Goeldi wrote: > >>I tried to install ZMySQLDA according to the very well written >>installation instructions. On a RedHat 7.0 system with installed MySQL >>mysql-server-3.23.32, mysql-devel-3.23.32 and mysql-3.23.32 client >>program and shared library. >> >>Installed Zope is 2.32 (binary release, python 1.5.2, linux2-x86), >>Python Version 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3]. >Which version of Mysql_python and ZMySQLDA are you installing ? Mysql_python? What is that? Will I need it? I don't remember it mentioned in the docs. The ZMySQLDA is the one found on www.zope.org > Products > external access. I didn't see another version of ZMySQLDA there. It's version is 1.1.3-nonbin. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

<dtml-whois> tag don't work
by Marcello Lupo 10 Aug '01

10 Aug '01

Hi, i tried ti install whoistools on my zope 2.3.0 but i found an error in the source of whois.py at the sock.connect line which was sock.connect(server, port) i correct it with sock.connect((server, port)) and it started ti run in python. But wher i try to use it from the <dtml-whois> tag i gat everytime : Unexpected tag, for tag <dtml-whois "'internic.net'">, on line 1 of ppp I see that the Zope don't list the prodects in the control panel under Products. Any ideaa?? thanks, Bye, Marcello

1 0

Zope / LocalFS ??? PDF files.
by Rubinstein Fredrik 10 Aug '01

10 Aug '01

Hi there, When a user "uploads" a pdf file using localfs to the server, Zope or LocalFS cuts the file so that just a fraction of the file is stored on the server. All other filetypes are stored OK it is just PDF's that get "trimmed". I'm running Zope 2.3 on a NT-box servicepack 6. Clues anyone ??? With kind regards Fred Rubinstein.

1 0

slow access
by Fritz Mesedilla 10 Aug '01

10 Aug '01

how come after half a day of testing the website suddenly slows down? and sometimes the server just slows down on its access. we have a link to a mysql database. i notice that if i visit a root folder that doesn't have a database connection it is fast. is that it? how do i make it consistent in its speed? thanks. Fritz Mesedilla Systems Administrator Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph Palm Pilot Software: TVSked - Download from the link below ---------------------------------------------------------------------------- http://mesedilla.tripod.com +Basta Ikaw Lord

1 0

RE: [Zope] Checkbox and SQL Method
by CHOY,CHARLENE (HP-Boise,ex1) 10 Aug '01

10 Aug '01

Thanks Eric, I have solved part of my problem =) I have a new problem now. After the form is being process I have a list ['1','2','3']. how do I get rid of the bracket and single quotes because I only need 1,2,3 as the argument to my sqlmethod. Thanks in advance for your help. -Charlene -----Original Message----- From: Eric Walstad [mailto:eric@walstads.net] Sent: Thursday, August 09, 2001 4:24 PM To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail) Subject: RE: [Zope] Checkbox and SQL Method Hi Charlene, It looks to me like your SQL is set up to only handle one "index" value. If I understand your question, you need something like this in your SQL: SELECT * FROM data WHERE index IN (1, 3, 5, 7, 11); You can then use that list to populate the list of "indexes" used in the SQL IN clause. I think the <dtml-sqltest> tag will do the iteration over the list for you. Check out the "Dynamic SQL Queries" section of the Zope Book for more details. HTH, Eric. > If I get a list of input values for the argument of my sql > method from the > check box, how do I call the sqlmethod to repeatedly display them. My > sqlmethod only has one argument. > > The following is some of the snippet of my codes. > > > ============================= > sqlmethod: selected_item > ============================= > Argument: selected_number > > "SELECT * data where > index = <dtml-sqlvar selected_item type=int>" > > > ****************************************************************** > > ============================= > dtml-method: list_selected_item > ============================= > <dtml-var standard_html_header> > <form action=selected_item action=post> > <dtml-in lookup_item size=50 start=query_start> //lookup_item is > another sql > method > <dtml-if sequence-start> > <dtml-comment> there is some more codes here </dtml-comment> > <table> > <tr> > <th>Index</th> > <th>Checkbox</th> > > </dtml-if sequence-start> > > <tr> > <td><dtml-var index null=""></td> > > <td><center><input type="checkbox" name="selected_lcn" > value="<dtml-var index>"> > </center></td> > <dtml-if sequence-end> > > </table> > <dtml-comment> Some other codes here </dtml-comment> > > </dtml-if sequence-end> > > <dtml-else> > > There was no data matching this <dtml-var title_or_id> query. > > </dtml-in> > <input type=submit value="Generate Report"> > </form> > <dtml-var standard_html_footer> > > ******************************************************************

3 2

ZMySQLDA
by Stephan Goeldi 10 Aug '01

10 Aug '01

I tried to install ZMySQLDA according to the very well written installation instructions. On a RedHat 7.0 system with installed MySQL mysql-server-3.23.32, mysql-devel-3.23.32 and mysql-3.23.32 client program and shared library. Installed Zope is 2.32 (binary release, python 1.5.2, linux2-x86), Python Version 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3]. When I issue the commands make -f Makefile.pre.in boot and make I get this output: gcc -fPIC -I/usr/local/mysql/include -I/usr/include/mysql -g -O2 -I/usr/include /python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type ./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1 Can anybody help me please? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

Help!
by Roman V. Isaev 10 Aug '01

10 Aug '01

Sorry if it's FAQ, but I can't find answer neither on google nor on zope.org. How to check file existance?! I want to upload file, but I don't know if it exists. So: <dtml-call "PARENTS[0].manage_delObjects('filename')"> <dtml-call "PARENTS[0].manage_addFile('filename',file,title=REQUEST['title'])"> If I omit manage_delObjects, file will be uploaded once, then zope barks. If I place manage_delObjects, the file HAVE to exist before I upload. Now how to write this code in a such way that it would handle uploads in any case? -- Roman V. Isaev http://www.aroma.ru System Administrator

3 2

REF CURSOR variables and Zope Stored Prodcedures in Oracle
by ricardo＠cnbe.mar.org.uk 10 Aug '01

10 Aug '01

Can someone help me? I have a package with a procedure like that: PACKAGE test_pkg IS TYPE rc_assuntos IS REF CURSOR PROCEDURE GETALL(result IN OUT rc_assuntos); END; PACKAGE BODY TEST_PKG IS PROCEDURE GETALL(result IN OUT rc_assuntos) IS BEGIN OPEN result FOR SELECT tema_primario FROM ASSUNTOS; END END; As you can see this procedure has as input/output variable type a REF CURSOR. I have created a ZSP to use the function above: ZSP description: procedure TEST_PKG.GETALL has arguments: RESULT IN OUT REF CURSOR I cold not test it because it asked for a cursor as input. So... I tried to use an Python Script like that to pass and receive a cursor for this ZSP: """ teste NO PARAMETERS LIST. """ db= context.Oracle_database_connection # use my current Oracle conection. Is it correct? c= db.cursor() # create a cursor object dbsproc = context.ZOSP2(c) # call mu ZSP and pass the cursor object rs=c.fetchall() # get the result set and use it print rs When I run this Script I have the folloing error: Error Type: AttributeError Error Value: cursor So what is wrong? What can I do to receive a REF CURSOR type from a ZSP from ZOPE? Or getting a REF CURSOR type from an Oracle procedure using ZOPE? Is there an easier way? Can I use External Method? If I can, how do I do it? Many thanks. Ricardo

1 0