- Zope - Zope lists

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

Data.fs gone crazy
by Tom Cameron 10 Aug '01

10 Aug '01

When I am editing an ZSQL Method and I click on the 'Advanced' tab I get this response: Error Type: ImportError Error Value: No module named POPMailBase Traceback (innermost last): File D:\Zope\23229D~1.3\lib\python\ZPublisher\Publish.py, line 223, in publish_module File D:\Zope\23229D~1.3\lib\python\ZPublisher\Publish.py, line 187, in publish File D:\Zope\23229D~1.3\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: insertintolists) File D:\Zope\23229D~1.3\lib\python\ZPublisher\Publish.py, line 171, in publish File D:\Zope\23229D~1.3\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_advancedForm) File D:\Zope\23229D~1.3\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_advancedForm) File D:\Zope\23229D~1.3\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in __call__ (Object: manage_advancedForm) File D:\Zope\23229D~1.3\lib\python\Shared\DC\Scripts\Bindings.py, line 354, in _bindAndExec (Object: manage_advancedForm) File D:\Zope\23229D~1.3\lib\python\App\special_dtml.py, line 236, in _exec (Object: manage_advancedForm) File D:\Zope\23229D~1.3\lib\python\Shared\DC\ZRDB\DA.py, line 544, in manage_product_zclass_info (Object: insertintolists) File D:\Zope\23229D~1.3\lib\python\ZODB\Connection.py, line 533, in setstate ImportError: (see above) POPMailBase is a completely different Product that I removed a few days ago. How could the two be related and how do I fix this mess? My Database connection keeps dying now and I cant seem to get it to work anymore. This is a Windows 2000 machine zope 2.3.2 Tom

1 0

RE: [Zope] Oracle Stored Procedures
by Ernst Eeldert 10 Aug '01

10 Aug '01

Ricardo, first off all, stop sending HTML messages to this list. Thanks. Basically, the ZOracle Stored Procedure object returns a list containing the OUT parameters of your procedure. So when you have a Oracle Procedure like: procedure test ( p_claim_id in varchar2 ,p_cursor out cur_general ,p_error_code out number ); calling the ZOracle Stored Procedure (ZSP) from DTML will return a list containing 2 items. The first will contain a DCO2 cursor object, the second item will be the numeric errorcode. In DTML, you can use the cursor just like from python, as long as you put it into an expression. Example: <dtml-in expr="spTest()[0].fetchall()"> <li><dtml-var expr="_['sequence-item'][0]> </dtml-in> This will print a list with the values of the first column of each row. It could be that the syntax of the dtml-var tag could be less hairy, but I just started using Zope, and I know this syntax works for me. HTH, Ernst -----Original Message----- From: ricardo(a)cnbe.mar.org.uk [mailto:ricardo@cnbe.mar.org.uk] Sent: Friday, August 10, 2001 10:20 AM To: Zope Subject: [Zope] Oracle Stored Procedures Hi Does anyone knows how to receive a Refence Cursor variable from a stored procedue? If a stored Procedure get a result set in a query and I want to pass this resul set as output from my ZSP how do I do it? How can I do it in Zope. I saw some examples in Python by I don't know how to do it from zope. TIA Ricardo

1 0