- Zope - Zope lists

Re: [Zope] DCOracle 2 and long text fields..How to use them?
by Geir Bækholt 07 May '02

07 May '02

Hello Chris, You have to use bind-variables or a stored procedure. Oracle or the adapter (not sure which) don't want those huge strings in the middle of an SQL statement it has to parse.. :-) hth Friday, May 3, 2002, 11:49:15 PM, you wrote: CB> Hello, CB> Maybe someone here can help.. CB> I had thought that DCOracle 2 (now) supported long text fields, but CB> when I tried to insert more than 2k into one (after upgrading) I got CB> a 'string literal too long' error from Oracle. CB> Is there some trick to this or am I running into a DCO2 or Oracle limitation? CB> I'm using Oracle 7 which (I think) is supposed to support up to 32k CB> in long text fields.. CB> I'd hate to have to continue working around this in the way I have, CB> by using Oracle7's 2k(max) varchar2 columns and splitting text in CB> Python on input/concatenating them together on output.. That is just CB> ugly.. CB> There must be a better way... CB> Also, is there any way to use the LONG RAW datatype to store images? CB> We are using Zope with Oracle as a CMS and need the long text CB> capability for descriptions within web pages.. CB> BTW...We are a nonprofit and can't afford the upgrade to Oracle 8/9.. etc. CB> -Chris -- Geir Bækholt web-developer geirh(a)funcom.com funcom oslo | webdev-team

3 2

new data types
by dman 06 May '02

06 May '02

I want to create some new data types for use in my zope application. I want to do this as simply as possible. I have a fair amount of experience developing OO software (python, java, c++, eiffel); actually writing the classes is not an issue. I found that I can create and return a class/instance from an External Method, but a Page Template and a Python Script are not allowed to access any attributes on the object. I think that a ZClass or Product is more involved than I really need, though I may want to move towards a Product if I find that performance is an issue. What is the simplest way to create new data types in zope? TIA, -D -- Thy Word is a lamp unto my feet and a light unto my path. Psalms 119:105 GnuPG key : http://dman.ddts.net/~dman/public_key.gpg

1 1

Betreff
by Immer frischer Kaffee 06 May '02

06 May '02

3 2

Re: your mail
by Martijn Pieters 06 May '02

06 May '02

On Mon, May 06, 2002 at 09:32:47AM +0200, Bennie wrote: > Hi I am one of those idiot users that played around with SiteRoot and now > cannot access Zope anymore. > I've seen the documentation about "(put _SUPPRESS_ACCESSRULE or > _SUPPRESS_SITEROOT in the right place in your URL) ", but the question is > where in the URL do I put this? Could you please help me out here. I believe that it can go anywhere in the URL; have you tried to put it in at the root? You're best bet to get answers is by using the mailingslists; I have cc-ed this to zope(a)zope.org. -- Martijn Pieters | Software Engineer mailto:mj@zope.com | Zope Corporation http://www.zope.com/ | Creators of Zope http://www.zope.org/ ---------------------------------------------

1 0

Forms, RESPONSE, REQUEST, and redirect
by Dennis Allison 06 May '02

06 May '02

It has been a long day... So, I have been trying to bend Zope to my will and making some progress. But this one has me a bit befuddled either because I'm tired or because I am missing something. Here's what I am trying to do... I have a method (in the particular case at hand, it is an External Method, but it could be a Python Script or DTML). It gets control, gets access to its REQUEST and RESONSE objects and does something. In particular, it arranges some computation and modifies some REQUEST values, and possibly adds some new ones. It then redirects to another object, this time a DTML document which, when it renders, will want access to the initial REQUEST object data as modified. To make things explict: If I make a form which has a form variable 'a', that variable is visible at my script. I can also create a new variable 'b' and put it in the REQUEST object with a REQUEST.set(name,value) call. But, when I direct from the script to another script (in this case, the original form), the REQUEST object does not include these values. If I then change the form action to not go to the script but to simply return to the form, the form renders itself (without the data mods my script was supposed to provide) since it has a copy of the REQUEST object that includes the form variables. Bottom line, how does one trick ZPublisher into marshalling some or all of the name-item pairs on redirection. Thanks for help.

4 3

operational error!!!(databse MySQL)
by Bala 06 May '02

06 May '02

Hi All, I installed zope in my machine and testing and learning with small test programs for database access. when I try to open a ZMySQL connection with the commands as Id : MySQL_database_connection Title : Z MySQL Database Connection Connection String : testdb bala testpassword and then when I press add I am getting the error as Error Type: OperationalError Error Value: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)") I am using OS : Linux 7.1 (kernel 2.4.2) Zope : Zope-2.5.1 python : python-2.1.3 mysql : mysq-3.23.49 ZMySQLDA : ZMySQLDA-2.0.7 ZODBCDA : ZODBCDA-3.1.0b1 pls help me find out the reason for this error, I am new to zope. Thanks in anticipation, Bala. __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com

3 2

Re: [Zope] Forms, RESPONSE, REQUEST, and redirect
by H.de.Wit＠SFK.NL 06 May '02

06 May '02

>It then redirects to another object, this time a DTML >document which, when it renders, will want access to the initial REQUEST >object data as modified. If i understand you well enough, this one could help you: http://www.zopelabs.com/cookbook/992031125 Hans de Wit Stichting Farmaceutische Kengetallen Postbus 30460 2500 GL DEN HAAG Tel. 070-3737448 Fax 070-3737445

1 0

RE: [Zope] timeout, thread, and external connections
by Warnes, Gregory R 06 May '02

06 May '02

Dieter, This sounds promising. Where would you suggest that I look for documentation about this? So far, google has turned up http://www.python.org/workshops/2000-01/proceedings/papers/fulton/zodb3.html , and http://www.zope.org/Documentation/ZDG >From that it looks like I will need to put the connection to the outside process in a _v_something attribute, override the __getstate__ to properly serialized the state of that process and __setstate__ to properly restore the state. It seems that each zope thread may end up with a different copy of the object. For my purpose, this is not desirable. Is there a way to ensure that there is exactly one copy of my process wrapper? Thanks, Greg > -----Original Message----- > From: Dieter Maurer [mailto:dieter@handshake.de] > Sent: Sunday, May 05, 2002 4:26 PM > To: Warnes, Gregory R > Cc: zope(a)zope.org > Subject: Re: [Zope] timeout, thread, and external connections > > > Warnes, Gregory R writes: > > ... > > Now, I want to the connection to the external process to > 'timeout' after a > > period of inactivity > I would not worry about my own timeouts or my own process management > but delegate that to the ZODB. > > When you assign a process wrapper for your process to a > "_v_" attribute, > then the wrapper instance is destroyed when the objects is flushed > from the ZODB cache. This would be a good time to kill the process. > > > Dieter > LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

2 1

Successful use of ZPT and macros in Python Product?
by Peter Bengtsson 06 May '02

06 May '02

Successful use of ZPT and macros in Python Product? ..., has anybody seen that?

2 5

Learning Python Syntax for Zope Objects and DTML Operations
by Dan Shafer 06 May '02

06 May '02

What is the recommended way to learn how to carry out both API access and DTML equvalence in Python scripts? I find myself frequently spending what seems like an inordinate amount of time trying to translate the way DTML deals with something into a Python equivalent. Th Zope Book basically waves its arms and says to consult the appendices but they don't really tell someone lilke me, who doesn't already have a good idea what's going on, how to do this mapping. Only by way of example, I've been working on learning iterators in DTML and finding the syntax pretty opaque. If I have a collection of DTML Methods in a folder, some of them having a property called "status" and I want to produce a list of *only* those DTML methods that *have* that property and have it set to some value, I get into some gnarly DTML code. So I figure, what the heck,I know how to do iterators in Python in my sleep, I'll write a Python script. But I can't figure out how to reference the objects, let alone iterate over them. I'll probably figure this out myself before too long, but I'm looking for a basic learning experience here. Surely someone somewhere has written some definitive material on how to talk to Zope and ZODB via Python with sufficient detail to be usable?

3 4