July 2000 - Zope - Zope lists

Where should votes be posted? (was: Your feedback on datetime)
by Brian Lloyd 25 Jul '00

25 Jul '00

> Do we *have* to clutter this zope(a)zope.org list up with loads > of votes? > > It is high enough traffic as it is! That is a good point. My initial reaction is to say that maybe voting should only be done on zope-dev, but I worry a bit that there may be quite a few people on the zope list (and not on zope-dev) who would have a stake in an issue and end up not seeing (or voting) on it. Ideally I'll have a web-based voting thing on dev.zope.org so that only one pointer to it has to go to the list(s), but until then I propose that votes happen on zope-dev for the time being... Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 1

calling a subquery
by danchik 25 Jul '00

25 Jul '00

Is it possible to refer to ZSQL method from some other ZSQL method and how??? each ZSQL is big and would be very expensive to put as a subquery of another so can I do something like this: say one is named ZSQL1: Select Mykey from Data where key > 100 and the other is ZSQL2: Select * from ZSQL1 INNER JOIN MoreData ON ZSQL1.Mykey = MoreData.key

1 0

Re: [Zope] "REQUEST" a string object?
by Dieter Maurer 25 Jul '00

25 Jul '00

Rob Miller writes: > <table> > <dtml-call "REQUEST.set('ctr', 0)"> > <dtml-in "fileValues(REQUEST.get('spec', _.None))"> > .... > <dtml-call "REQUEST.set('ctr', _.int(ctr) + 1)"> > .... There are "sequence-index" and "sequence-number" variables defined by "dtml-in". Thus, you need not count yourself. Note: use as "_['sequence-*']" inside "...". > The error I get, running Zope in debug mode, is this: > > Error Type: AttributeError > Error Value: 'string' object has no attribute 'set' Is is possible that some of your folders has a REQUEST property or acquires it? Dieter

2 1

ZClasses to RDBMS
by Steve Alexander 25 Jul '00

25 Jul '00

Satheesh Babu wrote: > > Is there any recommended way to get data from ZClass instances to a > corresponding RDBMS (Oracle 8i specifically) table? > > What I could think of as options are: (I've'nt tried out any!) > 1. In manage_add for my Zclass call the corresponding ZSQL insert method > - Can this be done? > - What can be done for updates? > 2. Create masking DTML methods to create Zclass instances dynamically. > Call ZSQL methods alongside as well. > 3. Do periodic downloads of ZClass instances - say XML format - and batch > upload to database. This sounds like a job for ZPatterns: http://www.zope.org/Members/pje/ZPatterns Most people find ZPatterns a bit difficult to get started with. It is also alpha-release software, so *caveat emptor*. Read the ZPatterns wiki too. http://www.zope.org/Members/pje/Wikis/ZPatterns/HomePage -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net

1 0

RE: [Zope] PCGI still not functional
by Jens Vagelpohl 25 Jul '00

25 Jul '00

bill, i saw the same symptoms this weekend when i helped a good friend set up a zope box to serve some of his domains from. his machine runs RH 6.1. what did it for me was to copy Zope.cgi from apache's cgi-bin directory back into the root of the affected zope install, he has two instances running. after doing that the problems went away. i double-checked the file to see if it points to the wrong places, but everything in there seemed OK otherwise. jens > -----Original Message----- > From: ucntcme(a)zope.org [mailto:ucntcme@zope.org]On Behalf Of Bill > Anderson > Sent: Tuesday, July 25, 2000 01:40 > To: zope(a)zope.org > Subject: [Zope] PCGI still not functional > > > > OK, it isn't just me, I've gotten email from others having > this problem; unfortunately, I > have had to tell them I still have it. > > I have tried using older pcgi code, I have tried the > PCGI_FDS_CLOSE=0 variable, and still, > nothing seems to work right. The second method worked once, > but a reboot stopped that > clean in it's tracks, and it doesn't work now. I've even > tried combining both of the > above; no luck. > > In the 2.2betas, and in 2.1.6, I could use ZServer and PCGI, > but now, I get one or the > other. Can someone at DC look into fixing this? We still get > unable to connect errors, > _even_ if the pcgi.soc file is created. > > I am getting this on _every_ 2.2.0 final server I have. On > Linux and HPUX. > > Eagerly awaiting resolution ... > > Bill > > -- > Do not meddle in the affairs of sysadmins, for they are easy to annoy, > and have the root password. > > _______________________________________________ > 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 ) > >

2 1

Using MySQL with ODBC causes re-authentification of Zope on WIN2000
by Richard S Herrington 25 Jul '00

25 Jul '00

Here is a perplexing problem I am experiencing. First, I was able to compile the MySQL database adapter (MySQLdb) for WIN2000 and connect successfully to a database I set up on Windows. I set up a ZSQL method to return rows from the database. Then I set up a DTML method to iterate over the rows and fill a html page using "dtml-in" to receive records from the ZSQL method: ...snip...snip... <dtml-in sqlQuery> <dtml-var last-name> <dtml-var first-name> </dtml-in> ...snip...snip.... This worked fine. Next, I was able to connect with a MicroSoft Access database using an ODBC method. Then I did the same as before. Create a ZSQL method (e.g. sqlQuery), then iterate over these rows with a "dtml-in" tag, filling an html page. Now here's my problem. When I set up a MySQL ODBC connection. The ZSQL method by itself returns rows from the database just fine. However when I access the index_html page that contains the "dtml-in" tags.....it causes a prompt to reauthenticate to Zope (username and password). No known username and password will work. I set all my MySQL permissions properly as far as I know. I've scoured the archvies but have found nothing. I need some leads as to what to try. Thanks in advance. Rich Herrington University of North Texas Academic Computing Services Research and Statistical Support Voice: 940 565 2140 Email: richherr(a)unt.edu "You live and learn. At any rate, you live." -- Douglas Adams "Where is the knowledge that is lost in information? Where is the wisdom that is lost in knowledge?" T.S. Eliot "Whenever I have a little money I buy books; if there's any left over, I buy food and clothes." Erasmus "It is impossible for a man to learn what he thinks he already knows." Epictetus (50-138 A.D.) "True wisdom is less presuming than folly. The wise man doubteth often, and changeth his mind; the fool is obstinate, and doubteth not; he knoweth all things but his own ignorance." Akhenaton? (c. B.C. 1375) "Happiness is the absence of the striving for happiness." Chuang-tzu (fl. B.C. 350)

1 0

Your feedback: what should DateTime strftime() behavior be?
by Spicklemire, Jerry 25 Jul '00

25 Jul '00

+1

1 0

Interbase 6.0 Open Source Release
by Jeff K. Hoffman 25 Jul '00

25 Jul '00

Hello, I just wanted to let everyone know that Interbase 6.0 has just been released as Open Source. Check out: http://www.borland.com/interbase/index.html If you need a high-quality, enterprise class RDBMS for Zope I suggest you download both Interbase 6.0 and our Zope DA, gvibDA. It is a truly nice setup. Let us know if you find any bugs, or if there are some new features you'd like to see added. We expect to make a 1.0 release of our DA next week, once we've had a chance to test against 6.0 final. Back to our regular programming, --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:jeff.hoffman@goingv.com Going Virtual, L.L.C. http://www.goingv.com/

1 0

RE: [Zope] frustrating security problem
by jacques＠msaservice.com.br 25 Jul '00

25 Jul '00

> -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On > Behalf Of joel > grimes > Sent: terça-feira, 25 de julho de 2000 13:55 > To: zope(a)zope.org > Subject: [Zope] frustrating security problem > > [snip] > > What am I missing? > Nothing. Check http://lists.zope.org/pipermail/zope/2000-July/029375.html Jacques

1 0

App isolation
by Jacques Exelrud 25 Jul '00

25 Jul '00

Not sure if this list is the best place to put such question but here it is... I need to develop what would be a product if only Zope was the target. As it´s not I was thinking what could I do to not need to build such app twice: I came to 2 options both involving building a server of some kind and using Python to connect to this server. 1st Build the app as a COM server (the target OS is Windows) and using Python support build an interface to this COM server as a Zope product 2nd Build the app as a XMLRPC server and using Python support build an interface to this XMLRPC server The second options is better because I´m not attached to any platform but, as I said, that´s not an issue right now. Any sugestions on any of those or a 3rd option ? Thanks in advance, Jacques

1 0