August 2001 - Zope - Zope lists

Re: [Zope] ZstoredProcedure help!
by J. Cone 02 Aug '01

02 Aug '01

Hello Richardo, I'm sorry; that's beyond my expertise. It may be possible in a ZSqlMethod; if not, you may end up having to learn python and write external methods. I had to write external methods in order to write long raws into the database. Regards, J. Cone. >From: ricardo(a)cnbe.mar.org.uk (Ricardo Seghizzi) >To: "J. Cone" <jcone(a)g8labs.com> >Subject: Re: [Zope] ZstoredProcedure help! >Date: Thu, 2 Aug 2001 10:53:29 +0100 >X-MSMail-Priority: Normal >X-Mailer: Microsoft Outlook Express 5.00.2919.6700 >X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 > >Hi J.Cone > >thanks very much for your help. I learned about the PRAGMA declaration and >it is >usefull. The example that you sent me worked very well. > >Sorry if I didn't said thanks before but I was very busy and >only yesterday I could test your example. > >Things are geting more complicated kown! > >I created test_2 PL/SQL procedure and I >would like to call it from a ZSQL method or, if possible a >Z Stored Procedure. My problem is How can I bind >the OUT parameter (or any procedure parameters) from test_2 with arguments >from ZSQL methods. > >If I use a Z Stored Procedure How can I pass/receive arguments values to my >stored procedures in the database? > >Do you know any documentation about this subject? > >Sorry to disturb you with this trivial questions but I don't know where >to find documentation about it. > >Regards > >Ricardo > > >PACKAGE test_pkg IS > FUNCTION conta_reg RETURN NUMBER; > PRAGMA restrict_references(conta_reg,wnds,wnps,rnps); > > PROCEDURE test_2(tot OUT NUMBER); > PRAGMA restrict_references(test_2,wnds,wnps,rnps); >END; > > >PACKAGE BODY TEST_PKG IS > FUNCTION conta_reg RETURN NUMBER > IS > total NUMBER; > BEGIN > SELECT COUNT(*) INTO total FROM ASSUNTOS; > RETURN total; > END; > > PROCEDURE test_2(tot OUT NUMBER) IS > total NUMBER; > BEGIN > SELECT COUNT(*) INTO total FROM ASSUNTOS; > tot:= total; > END; > > >----- Original Message ----- >From: "J. Cone" <jcone(a)g8labs.com> >To: "Ricardo Seghizzi" <ricardo(a)cnbe.mar.org.uk> >Cc: <zope(a)zope.org> >Sent: Thursday, July 26, 2001 6:15 PM >Subject: Re: [Zope] ZstoredProcedure help! > > >> Hello Richardo, >> Hello Zopers, >> >> Advanced Oracle Zopers, >> - there is a promise in the help system that ZSqlMethod can contain >> multiple statements >> - I would be interested to know how to get both DDL statements below >into >> one ZSqlMethod >> - I would be interested to know why broken DDL causes Zope 2.2.3 to: >> - write "ORA-00000: normal, successful completion" on its >> controlling terminal >> - apparently restart >> >> Richardo: >> >> The pragma is a declaration that the package body won't do anything to >> break the select statement at the end. There's one other option, rnds, >for >> "Read No Database State". I trust you have Oracle documentation and can >> tailor it to your requirements. >> >> Regards, >> J. Cone. >> >> >> Create the following, eg in scott/tiger: >> ---------------------- >> create or replace >> PACKAGE test_pkg IS >> PROCEDURE conta_reg; >> function conta_reg_fn return number; >> >> pragma restrict_references (conta_reg_fn, wnds, wnps, rnps); >> END; >> / >> create or replace >> PACKAGE BODY TEST_PKG IS >> PROCEDURE conta_reg >> IS >> total NUMBER; >> BEGIN >> SELECT COUNT(*) INTO total FROM scott.dept; >> END; >> >> function conta_reg_fn return number >> IS >> total NUMBER; >> BEGIN >> SELECT COUNT(*) INTO total FROM scott.dept; >> return total; >> END; >> END; >> / >> ---------------- >> >> Do the following in a ZSqlMethod: >> -------------------- >> select test_pkg.conta_reg_fn from dual >> -------------------- >> >> Get the following result: >> >> Z SQL Method at /longRaw/get_fn_result Help! >> -------------------------------------------------------------------------- >-- >> ---- >> CONTA REG FN >> 4.0 >> -------------------------------------------------------------------------- >-- >> ---- >> SQL used: >> select test_pkg.conta_reg_fn from dual >> > > > >

1 0

ZCatalog
by Marcus Schopen 02 Aug '01

02 Aug '01

Hi, how can I figure out which user put an object to ZCatalog? Marcus -- _____________________________________ (0> Marcus Schopen //\ P.O. Box 10 25 25 V_/_ 33525 Bielefeld, Germany ICQ#120991527 _____________________________________ Live as variously as possible

1 0

Re: [Zope] psycopg traceback
by Federico Di Gregorio 02 Aug '01

02 Aug '01

Hi, > RHL 6.2 > Zope 2.3.3 > postgreSQL 7.1 > > Help? > > ---- > Could not open connection. > Connection string: dbname=xxxclean user=xxxclean > > psycopg.OperationalError > can't set datestyle to ISO can you please: 1/ move this discussion to psycopg mailing list; and 2/ recompile psycopg with --enable-devel and send us a complete traceback? thank you very much, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org Best friends are often failed lovers. -- Me

1 0

Including HTML from another server's file into a dtml method or document
by Tommy Johnson 02 Aug '01

02 Aug '01

Hey all, Does anyone know how to include a file from another server into a dtml method or doc? The 'other' server can be the local file system, or (what I want) another server out there. I want to be able to grab the html from the file and display it in my dtml method. Something similiar to ColdFusion's <CFHTTP> tag. Maybe a simple syntax or a product could do this? Send me all ideas you have. I'd appreciate it. I tried searching the EGroups Zope archive, but to no avail. Thanks in advance, Tommy Innovation: The Best Way To Predict The Future ... Is To Create It.

4 3

Mail Host problem
by complaw＠hal-pc.org 02 Aug '01

02 Aug '01

I picked up the following code from runyaga via the ZopeLabs site: try: mailhost=getattr(context, context.SuperValues('Mail Host')[0].id) except: raise AttributeError, "Cannot find a Mail Host object." mMsg = 'A test e-mail message \n that contains a few line breaks. \n ~rlc' mTo = 'docket.clerk(a)bakerbotts.com' mFrom = 'docket.clerk(a)bakerbotts.com' mSubj = 'Mail Host Test' mailhost.send(mMsg, mTo, mFrom, mSubj) -------------- I put a Mail Host object in the same folder as the above python script. Tried it and got the exception. runyaga said to have the Mail Host object below the script, so I put it in a folder object lower in the hierarchy. Still got the exception. Then I put the Mail Host object in the root folder. Still got the exception. Clearly I am not the Hostess with the mostest. Does anyone know where I should place my Mail Host so that I don't throw the exception? Incidentally, I have the option to hardwire the mail host directly into the code (its not going anywhere). the id for the Mail Host in question is mailhost. TIA, Ron

4 3

Re: [Zope] SSL for authentication only
by Stephan Goeldi 02 Aug '01

02 Aug '01

>Also, consider the case of adding new users into your acl_users >folder: did you just send a username and password combination over the >network in plaintext while you were creating that user? Was there a >/manage anywhere in the transaction for Apache to intercept and >rewrite? You're right, that's what I forgot. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

1 0

External Methods to run ReportLab reports?
by Walter Miller 01 Aug '01

01 Aug '01

I've looked through the mailing lists on zope and reportlab-users and it seems that most people are calling reportlab to generate reports via external methods. Is this the prefered way to generate dynamic reports? And does anyone have some example code I can look at to get started? Ideally I would like to have the ablility to generate dynamic reports as well as cache the most often requested reports. Thanks, Walter

1 0

RE: [Zope] Anyone continuing the ZODBCDA product?
by Ayhan Ergul 01 Aug '01

01 Aug '01

Haven't tried yet but there is a recent update at: http://www.zope.org/Products/DA/ZODBCDA that claims Zope2.4 (Python2.1) compatibility. Ayhan __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

1 0

psycopg traceback
by Steve Drees 01 Aug '01

01 Aug '01

RHL 6.2 Zope 2.3.3 postgreSQL 7.1 Help? ---- Could not open connection. Connection string: dbname=xxxclean user=xxxclean psycopg.OperationalError can't set datestyle to ISO Traceback (innermost last): File /home/zope/8000/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /home/zope/8000/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/zope/8000/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: RoleManager) File /home/zope/8000/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/zope/8000/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_open_connection) File /home/zope/8000/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_open_connection) File /home/zope/8000/lib/python/Shared/DC/ZRDB/Connection.py, line 220, in manage_open_connection (Object: RoleManager) File /home/zope/8000/lib/python/Products/ZPsycopgDA/DA.py, line 186, in connect (Object: RoleManager) File /home/zope/8000/lib/python/Products/ZPsycopgDA/db.py, line 114, in __init__ BadRequest: (see above) -- Steve Drees SysAdmin/Software Developer/Web Geek/Chief Bottle Washer "A problem well-stated is a problem half-solved." http://steve.wejustrock.com

1 0

Anyone continuing the ZODBCDA product?
by Sean Hummel 01 Aug '01

01 Aug '01

Unfortunatey the Windows based ODBC Zope plugin, is not compatible with Zope 2.4 (due to the change from Python 1.5.2 to 2.1) Also I can't find source code for it to allow me to recompile the thing. So what I want to know, is anyone going to continue support for this wonderful tool, so that I and others can use Zope with MSSQL or is it just going to rot.

2 1