- Zope - Zope lists

Re: [Zope] Zope and Oracle ODBC
by Michael Gannon 23 Mar '00

23 Mar '00

Hi there, Thanks all for your help. I got it working by keeping my old configuration in the ODBC Control Panel settings and using 'gsmInfo testowner PASSWORD' as the connect string in Zope. Cheers, Michael. Paul Browning wrote: > > > Message: 5 > > Date: Wed, 22 Mar 2000 19:39:45 +0000 > > From: Michael Gannon <mgannon(a)xmlw.ie> > > Organization: XML Workshop > > To: zope(a)zope.org > > Subject: [Zope] Zope and Oracle ODBC > > > > Hi there, > > > > I'm trying to connect to an Oracle 7.3 database through Zope using a 'Z > > ODBC Database Connection'. > > It's giving me an error saying: > > 'Invalid connection string: gsmInfo' > > > > I set up a DSN throught the Control Panel as follows: > > > > Data Source Name: gsmInfo > > SQL* Net Connect String: 2: > > UserId: testowner > > > > This is using the 'Oracle73 Ver 2.5' Driver. > > > > I also used the '32-bit ODBC TEST' that comes with Oracle and this > > connected to the database no problem after entering in a password. > > > > Has anyone got any clues or suggestions to the problem. > > > > Not really. Just to confirm that it can be done. You've got > TNSNAMES.ORA sorted OK? Does your Oracle database feature the > SCOTT/TIGER tables? I find those useful for getting started. > > Paul > > -- > The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK > E-mail: paul.browning(a)bris.ac.uk URL: http://www.bris.ac.uk/

1 0

HELP to start , PLS
by Eeri Rassa 23 Mar '00

23 Mar '00

Hi I have problem I use this code via your server and have error. Help me pls What is reason of this error. Thank you in advance Eeri Rassa SD Toompuiestee 30 Tallinn Estonia Tel: 64 000 40 250 595 44 www.propaganda.ee ---------------------- your server answer -------------------------------------------------- ! System Unavailable This site is currently experiencing technical difficulties. Please contact the site administrator for more information. For additional technical information, please refer to the HTML source for this page. Thank you for your patience. Error type: NameError Error value: bob ---------------------- your server example source cod -------------------------------------------------- <dtml-var standard_html_header> <h2><dtml-var title_or_id></h2> <p> This is the <dtml-var id> Document. </p> <dtml-let name="bob" relation="uncle"> <dtml-var name> is your <dtml-var relation> </dtml-let> <dtml-let x=5 y=7> <dtml-var x><dtml-var y> </dtml-let> <dtml-var standard_html_footer> ----------------------------------------------------------------------

4 3

How do I get the owner of a document?
by Oliver Andrich 23 Mar '00

23 Mar '00

Hi, may be I am just to dumb or something like that, but Zope has to now who is the owner of a certain document. This is for sure, but how can I get the owner of a document from DTML or an external method? I read through the sources and maybe I am just to dumb or so to find it, but I can't find any manage_* call, that tells me how to do this? I have to write a small DTML method, that finds all documents, that are located in a givben hierachie which are owned by a certain user. Bye and many thanks, OLiver P.S.: Don't frustrated that I ask these things again and again, but now I have to deal with things in Zope, that I haven't dealt with before. ;-))))

3 4

ZCatalog woes
by Helge Tesdal 23 Mar '00

23 Mar '00

I would like to know why the following happens, and what I can do to fix it: I have a ZCatalog instance in my root folder called Catalog. I have some CatalogAware ZClasses that get added to it automatically. The problem is, when I query Catalog for results, it only shows the elements that were present the last time I clicked the "Update" button in ZCatalog. The new elements are present in the catalog, but they don't show up in the query until I manually update the catalog. Here's the query code: <dtml-in "Catalog(meta_type='Track', track_hasfile='on', track_active='')"> <li> <a href="<dtml-var "Catalog.getpath(data_record_id_)">/approve"> <dtml-var "Catalog.getpath(data_record_id_)"></a> </dtml-in> Any help appreciated. Please CC me if you answer. -- Helge Tesdal tesdal(a)stud.ntnu.no

2 1

Re: [Zope] zope_msg.log Message
by Tres Seaver 23 Mar '00

23 Mar '00

Tony Rossignol wrote: > > Tres Seaver wrote: > > > > Tony Rossignol <tonyr(a)ep.newtimes.com> > > > > > > Does anyone have any insite into what this error message might be? > > > > > > 2000-03-20T06:36:51 ERROR(200) ZServer uncaptured python exception, > > > closing channel <FCGIChannel connected 206.138.64.10:1819 at 10c1b2f0> > > > (socket.error:(32, 'Broken pipe') > > > [/usr/local/Zope-2.1.4-NT-0.1.6/ZServer/medusa/asynchat.py|initiate_send|211] > > > [/usr/local/Zope-2.1.4-NT > > > -0.1.6/ZServer/medusa/asyncore.py|send|237]) > > > ------ > > > 2000-03-20T06:36:51 ERROR(200) ZServer uncaptured python exception, > > > closing channel <FCGIChannel connected 206.138.64.10:1819 at 10c1b2f0> > > > (socket.error:(32, 'Broken pipe') > > > [/usr/local/Zope-2.1.4-NT-0.1.6/ZServer/medusa/asynchat.py|initiate_send|211] > > > [/usr/local/Zope-2.1.4-NT > > > -0.1.6/ZServer/medusa/asyncore.py|send|237]) > > > ------ > > > > > This problem is a symptom of something inside Zope which is killing off threads, > > most likely an unhandled exception somewhere. Try turning on the > > STUPID_DEBUGGER_LOG and see if you get more enlightening log output. > > Thanks for the reply. One problem, I can't find anything on the > STUPID_DEBUGGER_LOG, is it the same as STUPID_FILE_LOGGER? Or is this > an undocumented option? D'oh! The environment variable which Zope checks for is STUPID_LOG_FILE: * If it is set to a blank string, Zope writes the verbose logging to stderr; * If it is a non-blank string, Zope opens it as a file and writes the verbose logging there; * Otherwise, Zope suppresses the verbose logging. > I'm guessing that these 'Broken pipe' errors might be what is causing > zope to periodically restart itself. Ayup, there have been several threads reporting such restarts lately -- have you been following them? (some were on the zope-dev list, I think). > > Again thanks. Sorry for the confusion! Tres. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

7 9

does zope's undo & version have access control?
by LiGuoFeng(李果锋) 23 Mar '00

23 Mar '00

I create a folder 'Folder1' under '/',then give 'undo changes' Permission of 'Folder1'to user 'test1';The I made some operation under Folder '/' BUT all changes made by user 'root' can be undo by user 'test1'; Can I control the UNDO permissin? the version has the same promblem. does zope's undo & version have access control?

1 0

Re: [Zope] sqlsession and postgresql
by Anthony Baxter 23 Mar '00

23 Mar '00

There's a bug in SQLSession - edit the sqlDeleteQuery and add a default argument to the second arg of ="" Anthony >>> "Shortie Lo" wrote > (sorry for asking this question again. i do need some help... ^_^) > > my table schema: > > create sequence sessions_session_seq; > create tale sessions ( session varchar(255), primary key (session) ); > create table session_data ( session varchar(255), name varchar(255), value > varchar(255) ); > > i have changed sqlSessionCreate SQL method: > > insert into sessions ( session ) value ( nextval('sessions_session_seq') :: > varchar ) > > i wrote some tests in dtml method: > > <dtml-comment> > things work > </dtml-comment> > <dtml-call Session> > <dtml-call "SESSION.set('attribute1', formField1'"> > <dtml-call "SESSION['attribute1']"> > <dtml-in "SESSION.keys()"> > <dtml-var sequence-item> = "<dtml-var "SESSION[_['sequence-item']]">"<br> > </dtml-in> > > <dtml-comment> > things don't work > <dtml-call "SESSION.clear()"> > </dtml-comment> > > if i uncommented "things don't work" block, i will get traceback: > > Traceback (innermost last): > File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, > line 214, in publish_module > File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, > line 179, in publish > File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line > 202, in zpublisher_exception_hook > (Object: ElementWithAttributes) > File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, > line 165, in publish > File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line > 160, in mapply > (Object: sessiontest) > File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, > line 102, in call_object > (Object: sessiontest) > File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line > 150, in __call__ > (Object: sessiontest) > File > /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, > line 502, in __call__ > (Object: sessiontest) > File > /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line > 335, in eval > (Object: SESSION.clear()) > (Info: SESSION) > File <string>, line 0, in ? > File > /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py, > line 172, in clear > File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line > 408, in __call__ > (Object: sqlDeleteValue) > File > /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line > 186, in _argdata > (Object: sqlDeleteValue) > Bad Request: (see above) > > -- > 'Life is like boxes of chocolate, Forrest. You never know what you're gonna > get.' -- Forrest Gump (1994) > Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ > ICQ#27118251 > Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe > > > _______________________________________________ > 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 ) -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

sqlsession and postgresql
by Shortie Lo 23 Mar '00

23 Mar '00

(sorry for asking this question again. i do need some help... ^_^) my table schema: create sequence sessions_session_seq; create tale sessions ( session varchar(255), primary key (session) ); create table session_data ( session varchar(255), name varchar(255), value varchar(255) ); i have changed sqlSessionCreate SQL method: insert into sessions ( session ) value ( nextval('sessions_session_seq') :: varchar ) i wrote some tests in dtml method: <dtml-comment> things work </dtml-comment> <dtml-call Session> <dtml-call "SESSION.set('attribute1', formField1'"> <dtml-call "SESSION['attribute1']"> <dtml-in "SESSION.keys()"> <dtml-var sequence-item> = "<dtml-var "SESSION[_['sequence-item']]">"<br> </dtml-in> <dtml-comment> things don't work <dtml-call "SESSION.clear()"> </dtml-comment> if i uncommented "things don't work" block, i will get traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py, line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe

1 0

Use of Zope for data entry intensive app re-write
by Jim Beckstrom 23 Mar '00

23 Mar '00

I have an application (Windows/DOS) that I want to re-write for the web. It is a data entry intensive application, with approx. 200 screens for adding and updating a number of tables. I am currently looking at using PostgreSQL for the database. Is this application appropriate for Zope? Jim Beckstrom

2 1

Re: [Zope] Casting to a list
by Hung Jung Lu 23 Mar '00

23 Mar '00

>From: Ken Kinder <kkinder(a)MessageMedia.com> >That didn't seem to work. Am I doing this right? >... ><dtml-let assignment:list=assignment> > <dtml-in assignment:list> >  > </dtml-in> ></dtml-let> Arghh... I should have been more clear, hopefully someone else already has told you in the meantime, but if not, the colons should be in the HTML FORM fields, not inside the target DTML method. That is, if you have check boxes or multiple select form-input-elements, you would use something like: <input type=checkbox name="mychoices:list" value="myvalue1"> ... <select name="mychoices:list" multiple> <option> ... Inside DTML, you would just use the name "mychoices" without the colon. Something like: <dtml-in mychoices> <dtml-call "qryCAssign(user_id=_['sequence-item'], client_id=client_id)"> </dtml-in> If qryCAssign() is a DTML method instead of an external method, generally you would need to prepend (_.None, _,... ) to the argument list. That is, qryCAssign(_.None, _, user_id=.......) regards, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0