RE: [Zope-dev] Comments on Zopes performance-article??
Zope will always fare badly in comparison to web servers that dont serve dynamic content. Zope's delivery will probably never be as fast as serving up static pages from the filesystem ala Apache or AOLServer. This is one of the reasons for ZEO. One of the other things in the wings that's being talked about on some Wiki somewhere is to build better caching in. -Original Message- From: Thomas Weholt [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 6:06 AM To: '[EMAIL PROTECTED]' Subject: [Zope-dev] Comments on Zopes performance-article?? http://weblogs.userland.com/qube/2000/06/26 Just found this article were Zope scores really bad, - compared to the competition that is. Any comments? How can Zope improve performance in the future? I know Zope has alot of other good qualities, at least compared to Apache, but performance tends to be the thing that tips the scale when people chose platform, so how will this affect Zope? Thomas ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Comments on Zopes performance-article??
http://weblogs.userland.com/qube/2000/06/26 Just found this article were Zope scores really bad, - compared to the competition that is. Any comments? How can Zope improve performance in the future? I know Zope has alot of other good qualities, at least compared to Apache, but performance tends to be the thing that tips the scale when people chose platform, so how will this affect Zope? Thomas ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] EMarket and 2.2.0b3
I'm sure a lot of this is because EMarket was a 1.x product that has seen relatively little change, in basic structure, since. I'm working on some patched to allow (1) ZClasses to act as MarketItems and Shoppers and (2) ZPatterns integration so that most objects can be optionally stored in RDBM or ZODB. .. I'll go ahead and checkin my ZClass stuff. I'm not running 2.2x much, since I'm really busy on other development... but I can at least see if the product installs! ;-) -steve "RDM" == R David Murray [EMAIL PROTECTED] writes: RDM OK, so I didn't get very far in tracking down what inside RDM EMarket is triggering the wierd auth behavior, because I had RDM to run a bunch of tests against b3, where the behavior has RDM changed from that of b2. RDM For this testing my method of determining if "things are RDM weird" is to see if I get prompted for authentication if I RDM access the "/manage_main" URL. Weird means I don't get RDM prompted. RDM Under b2, installing EMarket with a dummy empty __init__.py RDM file caused the weird behavour. Under b3, that test does RDM not. However, the EMarket __init__.py file with any of the RDM imports for the submodules uncommented *does* cause the weird RDM behavior. Farther than that I haven't gotten yet. RDM My tests give me some other interesting things to report, RDM however. After installing b3, I confirm that the site is RDM working and I can view the root index_html file normally. If RDM I then copy my test Data.fs from the b2 installation, the b3 RDM instance fails to show the root index_html, giving an error RDM message of a key error on URL on the last line of traverse in RDM BaseRequest.py. Now here's the weird thing: if I then RDM *delete* the Data.fs file, and restart Zope, *I continue to RDM get that same error*. I didn't try to track that any RDM further, but it unnerves me. RDM Second, the patch, supplied by someone else, that I reposted RDM here that fixed the "a_" KeyError after EMarket was installed RDM in b2, if applied to b3 *causes* that "a_" error to appear. RDM Since this patch was reportedly added to the CVS, I think RDM there is something here that needs to get cleared up before RDM 2.2 final. RDM I'll work on this some more tomorrow, but so far I'm nowhere RDM near finding what code might be involved in this set of RDM errors. RDM Has anyone seen the aforementioned "weird problem" with any RDM products other than EMarket and eTailor? RDM --RDM RDM ___ Zope-Dev RDM maillist - [EMAIL PROTECTED] RDM http://lists.zope.org/mailman/listinfo/zope-dev ** No cross RDM posts or HTML encoding! ** (Related lists - RDM http://lists.zope.org/mailman/listinfo/zope-announce RDM http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] adding attributes to a python product
Hi folks, I have a Python Product that I'm developing. During the course of development, I want to add a new attribute. All new instances get this attribute, as it is defined with a default value in the constructor. In addition, all instances that get edited via the web get the attribute, as the edit-processing method is defined to have a default value for this attribute. Is there any way of interacting with the ZODB persistence machinery to add the default attribute to all instances as they are brought out of persistent storage -- so that I can just restart Zope, and have all of my instances updated as I use them ? I can't find the right method or whatever in the ZODB on-line docs, or in the source. Thanks for any help. -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Using Java-Script with DTML
Hi
I`m trying to send a parameter to a java-script function and then use that
parameter in the java-script function to look up a record-set in a database
with a dtml-method. With no luck so far.
Ex.
script language="javascript1.2
function ShowStuff(params){
var text = "dtml-in expr="sqlMethod(some_id=params" !-- this does
not work, of course. How I can I pass argument thru Javascript to the
sqlMethod ?? ---
alert (text);
}
/script
!--- lots of DTML ---
a href=".." onClick="ShowStuff(dtml-var some_id);".../a
!--- lots of DTML ---
The link sends an id to the java-script-method. A SQL method takes that id
as argument and returns a recordset. Or, that`s what I want to happen. How
can I get the sqlMethod to take the passed argument and return some data?? I
get the thing to work by using static content, like
dtml-in expr="sqlMethod(some_id='1')"
But I need to pass the argument from somewhere else in the document.
Oh, this was one big mess. Hope it makes some sense.
Thomas
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] update: CachePool 0.2.3
Hello, Just uploaded version 0.2.3 of the CachePool product. It fixes a serious bug wich crashed zope (a little too often) among some other improvements. For those of you who don't know, this product caches pages in an array, dependent of the calling URL and the query string. you can get it at http://www.zope.org/Members/neli/CachePool Carlos Neves [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
RE: [Zope-dev] adding attributes to a python product
I have a Python Product that I'm developing. During the course of
development, I want to add a new attribute. All new instances get this
attribute, as it is defined with a default value in the constructor.
In addition, all instances that get edited via the web get the
attribute, as the edit-processing method is defined to have a default
value for this attribute.
Is there any way of interacting with the ZODB persistence machinery to
add the default attribute to all instances as they are brought out of
persistent storage -- so that I can just restart Zope, and have all of
my instances updated as I use them ?
I can't find the right method or whatever in the ZODB on-line docs, or
in the source.
Steve,
The "best way" to do this is to define the new attribute (with
its default value) as a class attribute. That way when you ask
for the attribute on old instances you'll get the default value
found in the class. If you change the attribute (through the web
or whatever), the changed attribute will be saved *in the instance*.
That way you don't even have to bother setting a default in the
constructor (though it won't really hurt anything to do so).
For example:
# old class
class Spam:
"""A spam object"""
def cook(self):
return 'cooked!'
# new class - we want to add a 'color' attribute that defaults
# to 'pink' and to be able to change the color, but we need old
# instances to support this too.
class Spam:
"""A spam object"""
def cook(self):
return 'cooked!'
# class attribute - doing a getattr on 'color' will find
# this for old instances.
color='pink'
def setColor(self, color='green'):
# if this is called, the color attr will be saved in the
# *instance*. The class default will not change.
self.color=color
Note that there is one caveat to this approach - if the attr
that you want a default for is a _mutable_ Python object
(like a dict or list), then you have to be careful not to
modify the class attribute directly. In those cases you need
to do a little more work:
class Spam:
"""A spam object"""
# A dict of spam flavors.
flavors={}
def addFlavor(self, name, desc):
# We have to be careful here. We can't just say
# 'self.flavors[name]=desc', because if we are an old
# instance then self.flavors will give us the 'flavors'
# *class attribute*. We don't want to mutate that, what
# we really want to do is create flavors as an instance
# attribute if we are getting the default.
# set dict to either the 'flavors' from the _instance_ or
# a fresh new dictionary.
dict=self.__dict__.get('flavors', {})
# add the entry
dict[name]=desc
# this is important - the Zope persistence machinery can't
# automatically know about changes to mutable builtin Python
# types like dictionaries, so we have do a setattr on self
# to make sure the changes to the dictionary are saved!
self.flavors=dict
Hope this helps!
Brian Lloyd[EMAIL PROTECTED]
Software Engineer 540.371.6909
Digital Creations http://www.digicool.com
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Searching a relational database
James Henstridge [EMAIL PROTECTED] writes: On Sat, 24 Jun 2000, Thomas Weholt wrote: Hi, How can I search a relational database thru Zope? ( I`m using PostgreSQL 7.0.2 on Linux ). I have a DVD/VHS-organizing project that would be pretty useless if people couldn`t search for movies by entering just parts of the title. Ex. typing alien should show "Alien" and "Alien 3". If you just want to do a single search term, you could easily set up an SQL method that read something like: select * from table where title like '%dtml-sqlvar search%' (I hope that syntax works with MS SQL server). It is probably possible to get zope to escape special characters in the string for you as well. I use the regexp search option in Postgresql (~*) to do complex searches. Unfortunately this means that your users will have to write regular expressions. If anyone is interested in writing a booleans search syntax to regexp converter I would be very interested. Can ZCatalog be used for this? If I have a SQL-statement that returns all rows in a database, can ZCatalog index this? This would negate the benefits of having an SQL database (eg. indexing, etc). Just write an sql method that does the search. What I`m looking for is similar to full-text searching on MS SQL 7.0 etc. Tips, hints or pointers?? Thomas James. Richard ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] adding attributes to a python product
On Thu, 29 Jun 2000, Steve Alexander wrote: Hi folks, Is there any way of interacting with the ZODB persistence machinery to add the default attribute to all instances as they are brought out of persistent storage -- so that I can just restart Zope, and have all of my instances updated as I use them ? In addition to the method Bryan detailed, you should look into the __setstate__() method. From http://www.zope.org/Members/michel/HowTos/ZODB-How-To: "When an object is activated by the object database and brought into memory, it's __setstate__() method is called. A Persistent class can override this method to initialize the object every time it is brought into memory. __setstate__() is also useful to upgrade an object from one version to another. If you add instance attributes to your product, older versions of the instances of that product will not have the new attribute. __setstate__ can check for the existance of new attributes, and create them with sane defaults in older versions of the instance." Thanks for any help. Hope this helps. --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:[EMAIL PROTECTED] Going Virtual, L.L.C. http://www.goingv.com/ ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Using Java-Script with DTML
--- In [EMAIL PROTECTED], Thomas Weholt [EMAIL PROTECTED] wrote:
script language="javascript1.2
function ShowStuff(params){
var text = "dtml-in expr="sqlMethod(some_id=params" !-- this does
not work, of course. How I can I pass argument thru Javascript to the
sqlMethod ?? ---
alert (text);
}
/script
I think I know what you are talking about. But you have to really
keep your mind straight about one thing: DTML runs with the CPU
on the server side, JavaScript runs with the CPU on the client side.
In other words, by the time you are running Javascript, you
CAN'T access your database records.
I have done a lot of things in displaying dynamic pull-down menus.
E.g: you choose a state from one pull down menu, and the content
of another pulldown menu is automatically changed to the list of
cities within that particular state. When you click on a state,
you CAN'T query your database for the list of its cities. It's
too late, your code is already running on the client side. So
what should you do? What you should do is to pre-generate
JavaScript arrays, storing the names of all the cities for all
the states.
That being said, there is one more caveat. When you pre-render
your database records into JavaScript arrays, you have to be
careful about quoting. I don't know whether there are any string
format quoting in DTML suitable for rendering into JavaScript
(the dtml-sqltest ... type=string comes to mind, but I am not
sure it works outside ZSQL methods), I ended up implementing my
own external method to quote Python strings into JavaScript strings.
If you still don't understand what I mean, consider a python string
'He said, "no".'
stored in your DTML variable mystring, that is, something like:
dtml-call "REQUEST.set('mystring', 'He said, "no".')"
and you pre-render it into JavaScript code
x = "dtml-var mystring";
It won't work. Because if you look at the source of your JavaScript,
you will see:
x = "He said, "no".";
regards,
Hung Jung
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Question
Hi, How I can upload 900 files into zope, in one shot ? I cannot use FTP, with the port 8021, I cannot use load site from itamar, because there is a bug. Maybe WebDav ? But I don't know how to use it. my email is: mailto:[EMAIL PROTECTED], if you want to help me to fix that problem, I searched a solutions since 3 days. -- Very truly yours, Jonathan Desp Atoma Matter will become Software http://www.atoma.f2s.com ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope] Non compliant robots
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What do people do when their sites get traversed by a robot that keeps generating Zope errors ( cookies not enabled I guess ) that doesn't observe the robots.txt conventions? ( I get the errors emailed me which is annoying :-( ) The one currently going thru my site comes from 171.69.236.238 and 171.69.236.239 - -- Regards, Graham Chiu gchiuatcompkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope -BEGIN PGP SIGNATURE- Version: PGPsdk version 1.7.1 iQA/AwUBOVpAZbTRdIWzaLpMEQLmGwCcDRIgm2pZo0XLAGTd+5iM0EcYlzIAoLQj r1yx7QiLPzpVABkExHGi8UM6 =dJ5z -END PGP SIGNATURE- ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] KM|net News help
Thanks for the reply, Kevin. Just to clarify, once I have SMTP access, I can add older articles to the KMStore via the "article editing page"? It's just not possible via the management interface. Also there is no way as of this version, to remove the Author and Date/Time tags? Another question: when you're on byproducts.com, you're able to link to articles like this: http://www.byproducts.com/art/2000/6/961509971/ what I'm finding is that when I link like this on my site, I just get a blank page - I have to add index.html in order for anything to show. Is it just me or is there something I have to do? Thanks again Wes ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] ZPatterns: Deleting objects from a Rack?
Bill Anderson wrote: What happens when the object is in multiple racks? (Assuming it is possible) Then it'll be missing if something tries to get it from a rack. The same thing as would happen if something tried to get it from a single rack after it'd been deleted. So this case should be covered anywhere as it's essentially 'what happens if an object that doesn't exist is requested from a rack?' That said, can you give em an example where it would eb useful to have one object stored in multiple racks? cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] ZPatterns: Deleting objects from a Rack?
Scott Parish wrote: Another thought i just had was that if you deleted by placing a call to the Rack, then you couldn't allow the class to override manage_delete. You might want to do such (overriding) if you wanted it to clean up a catalog or perform some other auxiliary function before disappearing. What class are you talking about? ;-) This is why I said it might be useful for the rack's delete just to call delete on the object. I think this is me going on about the demeter's Law thing again... cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Re: Zope won't let me call aq_parent in ZWiki?
Hi Curtis, Sorry for the late reply, I've been on holiday :S Curtis Matthews wrote: I've just recently noticed I'm not able to call the JumpSearch and RecentChanges methods in the Basic ZWiki because I'm not authorized to call a method called aq_parent. Has anyone else had this problem, and is there a solution? This is a 'feature' of ZWiki according to Simon Michael, it's author, I think it's a bug ;-) Basically, ZWiki Pages (RecentChanges is a ZWiki Page) execute DTML contained in themselves with the 'Anonymous' role, supposedly as a security precaution. This means that 'Anonymous' must have the 'Access Contents Information' permission for RecentChanges and several other things to work. This makes it practically impossible to have a Wiki that is secure :/ This is a hard problem to solve, see Jim Fulton's server side trojan stuff for a detailed discussion. I don't like the current solution, it's confusing. A better, but not best ;-), solution would be to make ZWiki pages execute with any proxy roles they have and only those roles, or even have a seperate 'This Wiki Page has these roles' configuration box. A workaround would be to make RecentChanges a DTML method rather than a ZWiki page. You should just be able to copy and paste the contents. HTH, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Adding Products Breaking Zope
Hi! On Wed, 28 Jun 2000, Evan Simpson wrote: SiteAccess 1.0.1 is meant to work with Zope 2.1.6 (and does, for me). I'd like to get it working for you folks, as well. Does a fresh, empty install of Zope w/SiteAccess on your respective platforms have this problem? I am in the process of upgrading to 2.2.0b3; seems SiteAccess2 works right, so I wouldn't experiment with 2.1.6. Thanks for support. Oleg.(All opinions are mine and not of my employer) Oleg Broytmann Foundation for Effective Policies [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Getting anonymous permissions
On Wed, 28 Jun 2000, J. Atwood wrote:
dtml-if "AUTHENTICATED_USER.has_permission('View', '')"
Do something
/dtml-if
Here: http://sun.med.ru/pcgi/Random/ I test visitors this way:
!--#if "AUTHENTICATED_USER.getUserName() == 'Anonymous User'"--
Read-Only ADmin Login: Broad/B, password: Bmap/B
!--#/if --
Never tried to play with permissions...
Oleg.(All opinions are mine and not of my employer)
Oleg Broytmann Foundation for Effective Policies [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
___
Zope maillist - [EMAIL PROTECTED]
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 )
Re: [Zope] Passing Parameter without ?
http://www.zope.org/Members/mcdonc/HowTos/direct_traversal That might get you started.. it applies to most of what Zope can do. J From: saif [EMAIL PROTECTED] Date: Thu, 29 Jun 2000 15:33:00 +0530 To: [EMAIL PROTECTED] Subject: [Zope] Passing Parameter without ? Hi, How do u pass parameter from one html page to another without using ? and REQUEST. i.e I wnat to pass the parameter as /. eg:- www.localhost.com/para1/para2 Thanzs for the help Saif... http://systemprg.hypermart.net ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Multiple Languages
Hi Christian, Christian Zagrodnick wrote: Hi all, has anybody figured out how to make a zope website multilingual? I have to make a website in German and English - but the database stuff etc. is all the same. Did anybody do that? somewhat. I have the code to tell what version of the page is appropriate with given browser-configuration (language-preferences) and availability. We have now to make a product to hold the different versions of documents for each language. Regards Tino Wildenhain ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Passing Parameter without ?
saif wrote: eg:- www.localhost.com/para1/para2 I'm planning a product for Zope 2.2 that will do just this sort of thing... If you can bear with me, it might well be worth the wait :-) cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Data.fs.lock?
On Thu, 29 Jun 2000, Chris Withers wrote: Hmm, about extending this so you have 'rotating data.fs files' in the same way you have rotating log files? In general, yes :-). Do you think it would be solving the right problem the right way? Definitely, but I think it also needs to be solved for the normal Zope case as this is what most people will be running... That's right. ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Passing Parameter without ?
Hi, How do u pass parameter from one html page to another without using ? and REQUEST. i.e I wnat to pass the parameter as /. eg:- www.localhost.com/para1/para2 Thanzs for the help Saif... http://systemprg.hypermart.net ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Re: ZODB or not ZODB?
Jim Fulton writes: In theory, you could use ZCatalog to catalog objects in the file system or in a RDBMS, providing that you can provide paths for them. I don't think anyone's done this yet. There are bound to be bumps from wjoever does it first. :) I use ZCatalog to catalog objects in the file system included into the Zope world via LocalFS. Dieter How do you do to cache those objects, since LocalFS referenced objects are not cached by Zope? Regards, Rogerio Atem --- E-mail enviado pelo servidor do CEFETCampos ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Urgent problem: Database and large clock skew
--Also Sprache Toby Dickenson [EMAIL PROTECTED] On Thursday, June 29, 2000 10:19 AM +0100: That probably means you are using ZODB2, yes? (please say yes; ZODB3 should be immune to this problem). If so, there used to be a tool to correct the timestamps... you should be able to find it in the utils directory in the Zope 1 CVS Ding ding ding. Found it. Just what I was looking for! I'll give it a try. I am indeed using ZODB2. I worked around the problem temporarily by snipping all the code out of SimpleDB.py that checks the sanity of the timestamps (After making a copy of my database first :) http://classic.zope.org/cgi-bin/cvsweb.cgi/ZUtil/fixbbbts.py Thanks very much. -- Jim Flanagan [EMAIL PROTECTED] http://jimfl.tensegrity.net ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Howto engineer a scientific paper system
Thank you for the comments and links for latex and docbook. Going the latex path seems to me worthwhile - but on another day ;-) , I have already done some setup in zope that I would like to build on. What I did not find about LaTeX was a screenshot (isn't it a wysiwg enviroment on top of TeX marked-up text) and a content link to zope - this might be done, however, through the DocBook DTD and the XML stuff in zope. Which leads me to the later suggestion, I have tried out DocBook product, rendering is very slow on my computer. And again it is too big of a new concept for me now. I have looked into the YihawDirectory product a little deeper now, it fits very well into my idea to connect the content with the references closely. A lot of my code methods I produced in order to tweak a good reference handling is not needed any more, what is left are a few headers and footers implemented as methods, for design and navigation purposes, and folders having chapter properties and containing documents for holding content. I still want to look into XML and DocBook, though, xml could be easier to manage as the work grows. On first glance, for xml I found an interesting (but somehow abandoned) software named conglomerate http//www.conglomerate.org/, another is Xeena of IBM. The GUI of both (especially the former) seem to have nice XML editing capabilities. Christian ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Getting at Zope (Version) Transactions
Hail Zopistas, I would like to develop a "what's new" method that parses/accesses the undo transactions list for certain documents so I can post basic information about when they were added, updated etc. in a DTML method for display on my index page. This would also come in very handy for a file-archive system I am planning on building. (I'm talking about the info that shows up when you hit the "undo" link in Zope manager). Is there a way to get at the transaction data? Is this data stored after a version is merged back into the main ZOBD? What would be the best way in Zope to parse this log for certain types, and generate a DTML method? Does Zope support Regular Expressions? I hail from the Perl coders guild (where generating and parsing text/sql is a relatively easy, albeit messy, task) - but am new to Python and OOP in general. However, now that I have Zoped, I can see there's no turning back. Any help would be greatly appreciated! -Darin Lee Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Howto engineer a scientific paper system
[EMAIL PROTECTED] wrote: build on. What I did not find about LaTeX was a screenshot (isn't it a wysiwg enviroment on top of TeX marked-up text) and a content link No. LaTeX is, simply phrased, a collection of macros and templates for the TeX system. They include a lot of professional typesetting and design know-how which is applied dynamically to the document, so the author of the paper can concentrate on the content, rather than on the layout. You can still give explicit layout commands, if you know what you're doing. (Most people imho don't.) LyX is a document processor for Unix and Win32 building on the LaTeX/TeX engine which uses a wysiwym approach. It's worth one or two looks: http://www.lyx.org/about/ Yes, there are screenshots =:- XML stuff in zope. Which leads me to the later suggestion, I have tried out DocBook product, rendering is very slow on my computer. You could use any of the tools on http://www.oasis-open.org/docbook/tools/index.html and then import the exported HTML and PDF documents to your Zope installations to avoid the speed penalty. Cheers, Nils -- [EMAIL PROTECTED] | [EMAIL PROTECTED] (preferred) [EMAIL PROTECTED] | [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Win2000
On Wed, 28 Jun 2000, Robin Becker wrote: The boss says he couldn't install Zope on our Win2000 box. He tried 3 times. Anybody else have a problem with M$'s latest? Nope. 2.1.6, and the 2.2 betas, including the newest 2.2b3, work fine on my Win2000 Professional box at home. It's running as a service on port 80. Haven't had a single problem, yet. Robin Becker --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:[EMAIL PROTECTED] Going Virtual, L.L.C. http://www.goingv.com/ ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Creating PythonMethod from ZClass constructor/method.
Using Zope 2.2b3, I am trying to create a PythonMethod from the constructor of my ZClass and keep getting an authorization dialog. In my MyZClass_add method, I have: dtml-with "MyZClass.createInObjectManager(...)" dtml-call "manage_addFolder(id='testFolder')" !-- works! -- dtml-with "manage_addProduct['PythonMethod']" dtml-call "manage_addPythonMethod( this(), 'testMethod', 'Test Method', 'self', 'pass' )" /dtml-with /dtml-with Every pemutation I have tried gives the same result: an Unauthorized exception. Hi Jeff - Thanks for reporting this. It turns out that there was a missing security assertion in the product dispatcher (manage_addProduct) that was causing this. The fix will be in b4. If you want to patch your install in the meantime, edit lib/python/App/FactoryDispatcher.py and change: class ProductDispatcher(Acquisition.Implicit): " " def __getitem__(self, name): ... to: class ProductDispatcher(Acquisition.Implicit): " " # Allow access to factory dispatchers __allow_access_to_unprotected_subobjects__=1 def __getitem__(self, name): ... Brian Lloyd[EMAIL PROTECTED] Software Engineer 540.371.6909 Digital Creations http://www.digicool.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Multiple Languages
I posted a similar question here a few days ago, subject line Internationalization. The responses were less than overwhelming and although I greatly appreciated the suggestions from the people who did respond it was quite apparent that the problem of multilingual sites has not been solved gracefully yet. The best idea we came up with so far, which was also one of the suggestions, is to either let the user select a language or more preferably examine the HTTP_ACCEPT_LANGUAGE variable in the REQUEST space. based on it's setting we change a property of the top level folder: dtml-if "REQUEST['HTTP_ACCEPT_LANGUAGE'][:2]=='it'" dtml-call "top.manage_changeProperties(LANG_PATH='/top/Italian/ActualPages/')" dtml-else dtml-call "top.manage_changeProperties(LANG_PATH='/top/English/ActualPages/')" /dtml-if which as you can see adjusts the acquisition path to traverse through a language specific folder. Next on each page instead of text we use dtml methods that hold text: dtml-var standard_html_header h2dtml-var title_or_id/h2 pdtml-var someText dtml-var id dtml-var moreText./p form action="thisForm" input type=submit /form dtml-var standard_html_footer Notice there isn't any plain text on the page, but that the text to be render is in the variables someText and moreText. I would suggest using variable names that are made up from the text to be displayed (in the native language of the developer). For example say the text to be displayed is: "Customer Contact Information" the variable name maybe dtml-var tCustContactInfo. Prepending the 't' tells me that this is a text holder. Lastly in the folder English and Italian, in this example, we have placed dtml methods someText and moreText with the appropriate translations in them. The correct language is rendered automagically based on the user choice we preferred this to the alternative of placing the translations in the page because to add another language, say German, when the translations are on each page ,would require touching every page in the site. since we have close to a thousand pages, we found this to be unacceptable. In the system I have outlined above all that would be required would be to copy the english folder to a german folder and translate each method into german and poof you have added another language hope this helps , DR Christian Zagrodnick wrote: Tino Wildenhain wrote: Christian Zagrodnick wrote: has anybody figured out how to make a zope website multilingual? I have to make a website in German and English - but the database stuff etc. is all the same. Did anybody do that? somewhat. I have the code to tell what version of the page is appropriate with given browser-configuration (language-preferences) and availability. We have now to make a product to hold the different versions of documents for each language. This would be a solution... The problem is to split the design/program from the content I think. AFAIK xml supports multiple languages in one file - perhaps we should think about this -- Christian Zagrodnick - Progressive Media Production http://www.promp.de/ Die Haftung ist auf das Gesellschaftsvermoegen beschraenkt. ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Win2000
In article [EMAIL PROTECTED], Jeff K. Hoffman [EMAIL PROTECTED] writes On Wed, 28 Jun 2000, Robin Becker wrote: The boss says he couldn't install Zope on our Win2000 box. He tried 3 times. Anybody else have a problem with M$'s latest? Nope. 2.1.6, and the 2.2 betas, including the newest 2.2b3, work fine on my Win2000 Professional box at home. It's running as a service on port 80. Haven't had a single problem, yet. Robin Becker --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:[EMAIL PROTECTED] Going Virtual, L.L.C. http://www.goingv.com/ I've got it going using direct invocation of z2.py, but I'm having problems running it as a service. I think maybe the python version is slightly more advanced 1.5.2+ than the one which PythonService is using. Perhaps there's a dll clash. -- Robin Becker ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] bobobase_modification_time off by 1 day - why?
Hello, Zope reports the bobobase_modification_time to be off by one day (1 day behind). The box has the right time (when checked from the OS), and asking Zope to return ZopeTime returns the correct date and time. Anyone know why? thanks, Luke ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] DCOracle Problem
I was wondering if you could help me with a problem I've been having
with DCOrale, connecting to Oracle8i.
import DCOracle
conn = DCOracle.Connect(...)
curs = conn.cursor()
conn.procedures.some_stored_procedure(curs)
curs.fetchall()
curs = conn.cursor()
conn.procedures.some_other_stored_procedure(curs)
curs.fetchall()
some_stored_procedure and some_other_stored_procedure
return different rowtypes.
Either the second call throws the following error, or
it returns the wrong set of columns (it will return only
those columns that were returned in the first call):
Traceback (innermost last):
File "stdin", line 1, in ?
File "/usr/lib/python1.5/DCOracle/ociProc.py", line 134, in __call__
for c in iocursors: c._describe()
File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 130, in _describe
if rc!=1007: self._error()
File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 109, in _error
raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc))
oci.error: (1003, 'ORA-01003: no statement parsed')
Explicitly closing the cursor between the calls doesn't seem to help,
nor does reusing the same cursor. The only way I've been able to call
two stored procedures in this way is by closing the connection itself
between calls.
Here's an actual session:
Note that get_sentence_ids should return one integer per row,
and get_sentences should return that integer along with some
text.
import DCOracle
conn = DCOracle.Connect('/')
curs = conn.cursor()
conn.procedures.get_sentence_ids(curs)
curs.fetchall()
[(6,), (5,), (8,)]
conn.procedures.get_sentences(curs)
curs.fetchall()
[(6,), (5,), (8,)]
curs = conn.cursor()
conn.procedures.get_sentences(curs)
Traceback (innermost last):
File "stdin", line 1, in ?
File "/usr/lib/python1.5/DCOracle/ociProc.py", line 134, in __call__
for c in iocursors: c._describe()
File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 130, in _describe
if rc!=1007: self._error()
File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 109, in _error
raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc))
oci.error: (1003, 'ORA-01003: no statement parsed')
Any advice or help you can give would be greatly appreciated. Thanks!
-David Lipsky
Openmind Commonsense Group
MIT Media Lab
___
Zope maillist - [EMAIL PROTECTED]
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 )
Re: [Zope] PowerMac 7500 with LinuxPPC and Zope?
on 6/27/00 8:34 PM, Curtis Maloney at [EMAIL PROTECTED] wrote: I would like to turn an old Mac 7500 into a Zope server. LinuxPPC installs on the Mac PowerPC using the Red Hat 6.1 linux distribution. Does anyone have any experience with Zope with this type of set up? http://jhh.cbmi.upmc.edu/ is running Zope with Linux PPC on a blue G3. Works just fine, including products like Squishdot and Zwiki. Should I consider a different linux distribution than PPC? Well, aside from Yellow Dog, are there really any other Linux distros suited to the PPC? SuSE has just released a distribution for the PPC http://www.suse.com/products/susesoft/PPC/index.html. A CD is being distributed with the June issue of MacTech. Jim Harrison Univ. of Pittsburgh ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Authentication, Anonymous and Public
Title: Authentication, Anonymous and Public I'm running into a problem after implementing jcNTUserFolder in a subfolder of my site. Users can access the root level or particular subfolders anonymously. Once a user accesses the protected NTUserFolder, the credentials are saved in the browser. If the user then returns to the anonymous area, they can no longer access th folder due to the browser credentials. Does Zope have a mechanism equivalent to the Novell NDS Public access? that is to say: Anonymous = not authenticated. Everyone = authenticated users (that are members of the group) Public = authenticated and anonymous users. I'd like the default access to be anybody and their brother rather than those people who haven't logged in
[Zope] NOTICE: issue with database packing in current Zope releases
Hi all, Jim found a problem with the algorithm for packing the Zope database that we wanted to announce so that folks can avoid being bitten by it until the fix is out (in b4). The gist of it is that you should not pack your database to a given time and then subsequently pack the database to an *earlier* time. For example, do not pack to "older than 0 days" and then pack to "older than 10 days". The algorithm in the current Zope releases doesn't handle this correctly and depending on the exact circumstances can end up getting rid of objects that it shouldn't in the packed version of the database. Note that if you _are_ inadvertantly bitten by this, you can recover by using the Data.fs.old in the /var directory that is created at pack time. Brian Lloyd[EMAIL PROTECTED] Software Engineer 540.371.6909 Digital Creations http://www.digicool.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] DCOracle Problem
On Thu, 29 Jun 2000, David A Lipsky wrote: curs = conn.cursor() conn.procedures.some_stored_procedure(curs) Do not pass cursor - pass parameters to the procedure and it returns a result. Oleg.(All opinions are mine and not of my employer) Oleg Broytmann Foundation for Effective Policies [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Newbie question on Zope and WorldPilot
Hey Zope Meisters I am a newbie who is trying hard to get WorldPilot to run. i think i got most of it to work until it comes to add a WorldPilot Product Instance and no matter what I have tried it will not work. Can someone direct me to a doc or give me help? TIA, -ar Zope is: Zope-2.1.6-solaris-2.6-sparc WorldPilot is 1.0.4 ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] DTML Document class Id bug, somewhat fixed. But now setName ...
Hi, I had (have) a problem with the Id property on an Article class that subclasses the DTML document. And indeed the problem was with the fact that I was subclassing the DTML Document, which as explained in http://www.zope.org/Members/AlexR/ZClassIDBug somewhat mangles the Id property. Public thanks to Rik Hoekstra [EMAIL PROTECTED] for suggesting that. I added this fix (from the page I mention above) to the constructor method, !--#with "myZClass.createInObjectManager(REQUEST['id'], REQUEST)"-- dtml-call "setName(REQUEST['id'])" !--#/with-- And when I try creating a new object, it blows up in my face with this error: Unauthorized You are not authorized to access setName. Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: ArticleClass_add) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: ArticleClass_add) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: ArticleClass_add) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: ArticleClass_add) File /usr/local/zope/lib/python/DocumentTemplate/DT_With.py, line 148, in render (Object: ArticleClass.createInObjectManager(REQUEST['id'], REQUEST)) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 329, in eval (Object: setName(REQUEST['id'])) (Info: setName) Unauthorized: (see above) I _think_ that my user on this system has enough permissions to do this. Should I just ditch the class and recreate it (under the hypothesis that I botched something while I was creating it the first time), or should I pester the guy that made my user for additional, God-like, power ? And what is so special about setName ? This is under: Zope version: Zope 2.1.6 (binary release, python 1.5.2, solaris-2.6-sparc) Python version: 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1] Thanks in advance, Walter -- Vita brevis, ars longa, occasio celeris, experimentum periculosum, judicium difficile. Attention: Un train peut en cacher un autre -- Eris aprueba este email ! -- http://redescolar.ilce.edu.mx ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Howto engineer a scientific paper system
On Thu, 29 Jun 2000, [EMAIL PROTECTED] wrote: Thank you for the comments and links for latex and docbook. Going the latex path seems to me worthwhile - but on another day ;-) , I have already done some setup in zope that I would like to build on. What I did not find about LaTeX was a screenshot (isn't it Having used latex for a long time I would like to point out that if you are planing to to write many papers for conferences/publications Latex has some very helpful tools. For one many scientific journals provide Latex style files so you don't need to worry about formating. Also (and IMO the most important) are the pain in the ... bib contents. There are very nice bib databases for Latex and latex (or bibtex) can produce bibliography contents in the formats required by most journals. Check also Lynx which is a minimal (last i checked) wysiwig environment for Latex. Pavlos ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Howto engineer a scientific paper system
Pavlos Christoforou wrote: contents in the formats required by most journals. Check also Lynx which Lynx is text-only web browser with a code open for lots of potential security issues. [A quick look to my TV: Netherlands vs. Italy still 0-0, okay, so I can write a bit more...] is a minimal (last i checked) wysiwig environment for Latex. What you're looking for is called LyX: http://www.lyx.org It's not really a WYSIWYG but a self described "what you see is what you mean" editor. Cheers, Nils -- [EMAIL PROTECTED] | [EMAIL PROTECTED] (preferred) [EMAIL PROTECTED] | [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
Title: RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?) Just to start by pointing out the bloody obvious: - Restoring from backup means you lose all data between backup date/time and system failure. Sucks, but it beats losing *all* your data. (RAID5 anyone?) - With that in mind, *consistency* of the backup database takes the highest priority. All existing transactions should be fully completed - no half-done updates, etc. It seems to me that the easiest way to get there with ZODB might be to just make a simple file copy of the database and have some kind of integrity checking tool to run against the static backup copy to weed out the junk. Is this possible, does it already exist? Probably a dumb question, but would Zope itself do this if you fired it off against an inconsistent ZODB? Another random thought is that if ZODB transactions and writes are atomic, than none of this should be an issue. Anyone know the answer to that one? -cw- -Original Message- From: Chris Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 7:49 AM To: Erik Enge Cc: Oleg Broytmann; Zope Mailing List Subject: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?) Erik Enge wrote: On Thu, 29 Jun 2000, Chris Withers wrote: Hmm, about extending this so you have 'rotating data.fs files' in the same way you have rotating log files? In general, yes :-). Do you think it would be solving the right problem the right way? I think so, but that's only my view. If anyone's got any better ideas, please pipe up :-) cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] LocalFS cache, was Re: ZODB or not ZODB?
How do you do to cache those objects, since LocalFS referenced objects are not cached by Zope? They aren't cached. I experimented with adding a cache, but ran into some problems and gave up. It would probably be worth giving it another shot, though. --jfarr "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998 ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] DTML Document class Id bug, somewhat fixed. But now setName ...
And indeed the problem was with the fact that I was subclassing the DTML Document, which as explained in http://www.zope.org/Members/AlexR/ZClassIDBug somewhat mangles the Id property. Public thanks to Rik Hoekstra [EMAIL PROTECTED] for suggesting that. I added this fix (from the page I mention above) to the constructor method, !--#with "myZClass.createInObjectManager(REQUEST['id'], REQUEST)"-- dtml-call "setName(REQUEST['id'])" !--#/with-- And when I try creating a new object, it blows up in my face with this error: Walter - this is sort of a tricky one :( The problem is that the ZClass id bug is a legitimate bug (fixed in the 2.2 series), but your fix uses a method that should never have been accessible in the first place (and in fact the hotfix makes it inaccessible, as it should have been all along). So there are two things you could do here to get along until you can upgrade to 2.2. One, you could edit the __init__.py in the Hotfix product's directory and comment out the line: DocumentTemplate.DT_String.String.setName__roles__=[] ...and restart Zope. That will make the setName method unprotected again though, so don't do this lightly. By unprotected I mean that other people could call setName on _your_ objects and screw things up if they wanted to. An alternative would be to create an external method like the following in your class: def temporary_hack(self, id): self._setId(id) ...and try using: !--#with "myZClass.createInObjectManager(REQUEST['id'], REQUEST)"-- dtml-call "temporary_hack(REQUEST['id'])" !--#/with-- That should let you solve it without reopening a security hole. Hope this helps! Brian Lloyd[EMAIL PROTECTED] Software Engineer 540.371.6909 Digital Creations http://www.digicool.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Getting Zope error when starting Zope, installed on ISP's machine
I installed Zope on my ISP's virtual server, and I'm getting an error when I run the start script. The server is running Apache, but I don't really need to use Apache for this particular domain. I haven't tried to figure out how to access Zope through PCGI, because unless that is the only way to allow Zope and Apache to run on the same machine, this isn't necessary. I have Zope and Apache successfully running on my own development machine (SuSe Linux), but my problem is running it on a virtual server (FreeBSD). Below is the error message I get. Any help would be greatly appreciated. 2000-06-29T17:13:10 PROBLEM(100) ZServer Computing default hostname Traceback (innermost last): File "/usr/home/orb6b/usr/zope/Zope-2.1.6-linux2-x86/z2.py", line 493, in ? logger_object=lg) File "/usr/home/orb6b/usr/zope/Zope-2.1.6-linux2-x86/ZServer/medusa/http_serve r.py", line 560, in __init__ ip = socket.gethostbyname (socket.gethostname()) socket.error: host not found ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] How to update DTML built from Python level?
Well, I edited the file I mention below (documentEdit.dtml) and my changes aren't taking effect, no matter what (either on 2.2b3 and 2.1.6). (Reason: if Mozilla sees textarea inside a td align=center, the text inside the textarea is centered in the textarea, which makes things quite unpalatable to work with. ;-) As Mozilla is already a lot nicer to work with Zope, I'm willing to use this temporary workaround for a while...) On Wed, Jun 28, 2000 at 04:48:38PM -0700, Andy McKay wrote: Restarting will work (although it is not technically necessary for .dtml). Perhaps there is another reason... If I, for example, edit .../lib/python/OFS/documentEdit.dtml, what kind of black magic do I have to do to make my changes take effect? I'd think it is only a matter of restarting Zope, but that doesn't work :-/ []s, |alo + -- Hack and Roll ( http://www.hackandroll.org ) News for, uh, whatever it is that we are. http://zope.gf.com.br/lalo mailto:[EMAIL PROTECTED] pgp key: http://zope.gf.com.br/lalo/pessoal/pgp Brazil of Darkness (RPG)--- http://zope.gf.com.br/BroDar ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] 2.2b3 Tutorial issues
The tutorial included with 2.2b3 now "works"; however, the documents are in the wrong order (9, 10, 11, 1, 2, 3, 4 etc). And every page generates a JavaScript error on IE 5.01 (syntax error on line 74). Thanks for the bug report. I can easily fix the "order" issue, but I am so far unable to reproduce the JavaScript error. Can you give me more information about your platform, the error message and what steps you took to achieve the error? If you do things differently (like create an instance of the tutorial with the product add list) does the tutorial work? Thanks! -Amos -- Amos Latteier mailto:[EMAIL PROTECTED] Digital Creations http://www.digicool.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Alternate User Folders Broken in 2.1.6? HELP!!!
It seems as if all the alternate user folders I have tried (GUF, UserDb, etc) all seem to be broken under 2.1.6 They worked fine in 2.1.4, but when I upgraded to 2.1.6 they broke!! HELP! I need to solve this ASAP! -- Dishonor will not trouble me, once I am dead. -- Euripides ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Adding DTML Templates to ZClass instances
I would like to have an option when creating an instance of a folderish object to have a "index_html" template automatically added to the new object once it is created. I have the template for the inserted index_html sitting in my root directory of Zope. How can I tell the constructor method to add this template as a DTML Method (template_dtml) to the just created instance and rename it to "index_html"? This I cannot find documented anywhere. What I'm trying to do is practically identical to the option available when adding a standard DTML Document/Method from the management interface. Thanks in advance, Eron ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
On Thu, 29 Jun 2000, Wilkinson Charlie E wrote: Another random thought is that if ZODB transactions and writes are atomic, than none of this should be an issue. Anyone know the answer to that one? It is my understanding that the ZODB on disk is always in a consistent state; Jim has said, in the past, that you can simply make a copy of Data.fs, even while Zope is running, without problems. Based on that, I think the answer to the above is yes. -cw- --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:[EMAIL PROTECTED] Going Virtual, L.L.C. http://www.goingv.com/ ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] File upload failure. Help needed.
Hi, I am a new user of Zope. I have Zope--linux2-x86.tar.gz bundle installed on my Linux machine, up and working. While I was trying to create a simple page using dtml files, I wanted to upload a few files from my hard drive onto Zope database. When I choose the Browse button to select a file from the targeted directory and say "Add", I get an error message: "The document contacined no data. Try again later, or contact the server's administrator." I fail to understand, why am I getting this error when the targeted file size is 25519 bytes ? Kindly advice. Also kindly suggest which document to go through before writing Zope applications. Thanks and Regards, Urvashi - -- ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] queries and tiny tables and python methods... oh my!
Hi everyone,
(Please excuse the vague Wizard of Oz reference in the sub., but my brain
may be imploding. :-)
I'm trying to merge several type of Zope objects, and I'm getting lots of
little errors. I wonder if someone could suggest where my problem lies.
1. I'm querying our LDAP server to retrieve the records for a given person
in the directory. No problem there.
2. I'm parsing one of the entries in the LDAP directory to retrieve the
user's location. Python method code is simple.
3. I'm using a Tiny Table to look up a value for one of the parsed strings.
Easy.
The problem is hooking them all together. Passing the query to a
PythonMethod is throwing up the following error:
Error Type: TypeError
Error Value: argument l: expected read-only character buffer, instance found
(BTW, Netscape on Windows doesn't product a traceback, but Netscape on Linux
does.)
!--
Traceback (innermost last):
File /usr/local/src/zope/2.1.6/lib/python/ZPublisher/Publish.py, line 214,
in publish_module
File /usr/local/src/zope/2.1.6/lib/python/ZPublisher/Publish.py, line 179,
in publish
File /usr/local/src/zope/2.1.6/lib/python/Zope/__init__.py, line 202, in
zpublisher_exception_hook
(Object: ElementWithAttributes)
File /usr/local/src/zope/2.1.6/lib/python/ZPublisher/Publish.py, line 165,
in publish
File /usr/local/src/zope/2.1.6/lib/python/ZPublisher/mapply.py, line 160,
in mapply
(Object: rpt_contactInfo)
File /usr/local/src/zope/2.1.6/lib/python/ZPublisher/Publish.py, line 102,
in call_object
(Object: rpt_contactInfo)
File /usr/local/src/zope/2.1.6/lib/python/OFS/DTMLMethod.py, line 150, in
__call__
(Object: rpt_contactInfo)
File /usr/local/src/zope/2.1.6/lib/python/DocumentTemplate/DT_String.py,
line 502, in __call__
(Object: rpt_contactInfo)
File /usr/local/src/zope/2.1.6/lib/python/DocumentTemplate/DT_In.py, line
691, in renderwob
(Object: qry_person(uid = user_id))
File /usr/local/src/zope/2.1.6/lib/python/DocumentTemplate/DT_In.py, line
633, in renderwob
(Object: buildingCodes(parseLocation(l)))
File /usr/local/src/zope/2.1.6/lib/python/DocumentTemplate/DT_Util.py,
line 335, in eval
(Object: buildingCodes(parseLocation(l)))
(Info: parseLocation)
File string, line 0, in ?
File
/usr/local/src/zope/Zope/lib/python/Products/PythonMethod/PythonMethod.py,
line 168, in __call__
(Object: parseLocation)
(Info: ((['SB_B208'],), {}, None))
File string, line 2, in parseLocation
TypeError: (see above)
--
parseLocation is a Python Method which takes 1 argument (a string) and
returns the first element of the list that's formed by splitting the string.
That first element is a two-letter code that's looked up in a Tiny Table
called buildingCodes which returns the full name of the building.
OK, it looks to my relatively inexperienced eyes that the Python Method
isn't getting an argument of the type is expects.
Here's the code for parseLocation ('l' is the argument):
x = string.split(l, '_')
return x[0]
(BTW, changing it to x = string.split(`l`, '_') eliminates the error, but
nothing is rendered.
qry_person is an ZLDAP filter method that takes one argument (uid). The
original dtml to display this mess looks like:
dtml-call "REQUEST.set('user_id', user_id)"
dtml-in "qry_person(uid = user_id)"br
dtml-in "buildingCodes(parseLocation(l))"
dtml-var buildingbr # 'building' comes from the Tiny Table
/dtml-in
/dtml-in
I'd appreciate it if anyone has any ideas about this. I'm probably making
the whole thing too complicated, but for reasons of code reuse, this seemed
like the most efficient approach.
-Tim
--
Tim Wilson | Visit Sibley online: | Check out:
Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/
W. St. Paul, MN | | http://slashdot.org/
[EMAIL PROTECTED] | dtml-var pithy_quote | http://linux.com/
___
Zope maillist - [EMAIL PROTECTED]
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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
On Thu, 29 Jun 2000, Jeff K. Hoffman wrote: It is my understanding that the ZODB on disk is always in a consistent state; Jim has said, in the past, that you can simply make a copy of Data.fs, even while Zope is running, without problems. But the Data.fs has to be updated sometimes. And if you read from a file that is changing, the integrity of your data isn't. How can you make sure that the file is not written to during a certain period of time? You can't? ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
Wilkinson Charlie E wrote: Just to start by pointing out the bloody obvious: - Restoring from backup means you lose all data between backup date/time and system failure. Sucks, but it beats losing *all* your data. (RAID5 anyone?) A) Please: no html! B) I just had one weird and wild thought. A RAID5 type of storage using ZODBs instead of blocl devices. Probably not doable, and might not gain anything if doable, but it was one of those ideas that shoots across your brain and sounds cool at first. Just thought I'd share. :) -- "Linux: the operating system with a CLUE... Command Line User Environment". seen in a posting on comp.software.testing ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
On Thu, 29 Jun 2000, Erik Enge wrote: On Thu, 29 Jun 2000, Jeff K. Hoffman wrote: It is my understanding that the ZODB on disk is always in a consistent state; Jim has said, in the past, that you can simply make a copy of Data.fs, even while Zope is running, without problems. But the Data.fs has to be updated sometimes. And if you read from a file that is changing, the integrity of your data isn't. How can you make sure that the file is not written to during a certain period of time? You can't? Now that I'm in the spotlight I can't seem to find the message I was referring to in the archives; I sure hope I didn't misquote anyone (i.e. Jim). Unfortunately, I don't have an answer to your question. I still believe I am correct, but cannot tell you, technically, why. I have some theories, but I don't want to cloud the issue anymore with my hypotheses. Let's hope someone who does know chimes in. --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:[EMAIL PROTECTED] Going Virtual, L.L.C. http://www.goingv.com/ ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] unable to download zope product for x86
I am unable to download zope for winNT on the zope products page. the server is giving time out on linux, and asks for user and password in win2000(using gozilla!). is there any other alternative site for downloading zope. thanks ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Win2000
On 28 Jun 2000, at 23:40, Robin Becker wrote: The boss says he couldn't install Zope on our Win2000 box. He tried 3 times. Anybody else have a problem with M$'s latest? Works fine for me on win2k Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Non compliant robots
In article [EMAIL PROTECTED], J. Atwood [EMAIL PROTECTED] writes I have exactly the same problem (robot hits my site, I get 400 emails of errors even with a robots.txt file). I am not sure what the answer is except to add something to your error page that would filter out robot errors. Since mine happens only on certain pages (forms), perhaps I should just build up a list of bad remote IP addresses ( criteria - generates more than 5 errors on the same page ), and then redirect those clients to another non form page with indexing information for my site... sounds like the basis of a product g -- Regards, Graham Chiu gchiuatcompkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] [lines] element in property sheets ++ \345 29 \345r ..
Kindest.. I have object contained in ZObjects .. and I have some object "parsing" the contents based on a search.. The type in the property sheet is; [text] Beneath is the dtml code used to print the main content of the type mentioned above .. trtdbAnnonse tekst:/b/tdtddtml-var annonse_tekst newline_to_br/td .. my problem is that the final output when parsed with the dtml code above is something like; ['hei', ' jeg er .. p\345 29 \345r som s\370ker . ...angre seri\370st ment. ']/td .. how do I get ouput without the ['text'] .. entries.. that is; "clean output" .. as well as how can i get the ascii codes like \345 to be the correct html code for norwegian caracters? Would apriciate any input here.. Thanks in advance. Kindest, Jørgen Skogstad ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Re: Prototyped folders?
On Thu, 29 Jun 2000, Hamish Lawson wrote: I wrote: If a folder doesn't itself contain a required object or method, I'd like to have another folder looked in instead. The fall-back folder won't necessarily (and often can't) be higher in the hierarchy, so acquisition doesn't seem to be a solution. Sorry to jump in late on the thread, just joined the list. Is there a reason you can't do this by just messing with the namespaces stack, ie, adding additional folders to it? (Or a reason that's not a good idea? That's what I've been known to do, if I correctly understand your goal...) jim -- Jim Hebert http://www.cosource.com/ [EMAIL PROTECTED] The cooperative market for open source software "Well actually I was considering opening a market in flying pigs. Mostly because it would be more practical" -- Alan Cox ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] DCOracle Problem
True, but the stored procedure I am calling is intended to return many rows of data (tens of thousands on occasion). I need a cursor for that. On Thu, 29 Jun 2000, David A Lipsky wrote: curs = conn.cursor() conn.procedures.some_stored_procedure(curs) Do not pass cursor - pass parameters to the procedure and it returns a result. Oleg.(All opinions are mine and not of my employer) - Oleg Broytmann Foundation for Effective Policies [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
Title: RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?) -Original Message- From: Erik Enge [mailto:[EMAIL PROTECTED]] On Thu, 29 Jun 2000, Jeff K. Hoffman wrote: It is my understanding that the ZODB on disk is always in a consistent state; Jim has said, in the past, that you can simply make a copy of Data.fs, even while Zope is running, without problems. But the Data.fs has to be updated sometimes. And if you read from a file that is changing, the integrity of your data isn't. How can you make sure that the file is not written to during a certain period of time? You can't? You can. This would be consistent with atomic updates. What it means is that a transaction is not written to the Data.fs file until it has completed, and when it is finally written out, it's done as an atomic operation, i.e. at the system level it is a single write operation and nothing else happens on the system until it completes. From that you can infer that if you were reading the Data.fs file (making your backup copy) at the same time, it would be impossible to read the file in the middle of an update. If both read and write requests hit Data.fs at essentially the same time, one goes first and the other waits until the first completes. So if the write gets first shot, the read will block until the write (meaning a completed transaction/update) finishes, and your read will include that last update. If your read gets first shot, then it will not include the update. You will under no circumstances get *half* an update. One of the other things that makes this possible is ZODB being of a journaling nature. i.e., all updates are *appended* to Data.fs. This is why you must periodically pack the database, which conglomerates all the updates back into the base datastore (or whatever those wacky Zopistas call it. ;) that comprises the first part of the Data.fs file. I think that's all correct. Someone please throttle me senseless if not. :-) -cw-
[Zope] Version Lock Error
Hello, For some reason anonymous users are getting locked out of the site when I try to use versioning. It doesn't happen right away, only after I've made a few changes. Does anyone have any ideas on what's happening?? Thanks in advance. Kevin Smith ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] thread.error
I'm running Zope on my ISP's virtual server, but when I try to access my IP on port 8080, I get the following error: 2000-06-29T22:03:59 ERROR(200) ZServer Server Error: thread.error, can't start n ew thread : file: /usr/home/orb6b/usr/zope/Zope-2.1.6-linux2-x86/ZServer/PubCore/ZRendezvo us.py line: 104 Any help would be greatly appreciated. Regards ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Backing Up Zope (was: Re: [Zope] Data.fs.lock?)
On Thu, 29 Jun 2000, Wilkinson Charlie E wrote: This would be consistent with "atomic updates." What it means is that a transaction is not written to the Data.fs file until it has completed, and when it is finally written out, it's done as an atomic operation, i.e. at the system level it is a single write operation and nothing else happens on the system until it completes. Brilliant! No worries, then :-) (by the way, loose the HTML) ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Version Lock Error
When the users hit a DTML method that tries (maybe in a roundabout way, have a ZCatalog?) to write to an object in the ZODB that's been locked in a version, you'll get this. Try to figure out where it's happening by examining the DTML method that they're hitting and figure out where you're trying to do writes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 6:04 PM To: [EMAIL PROTECTED] Subject: [Zope] Version Lock Error Hello, For some reason anonymous users are getting locked out of the site when I try to use versioning. It doesn't happen right away, only after I've made a few changes. Does anyone have any ideas on what's happening?? Thanks in advance. Kevin Smith ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Namespace question
Rogerio Atem de Carvalho wrote: Hi, I working on an structure like this: folder1 | folder11 | folder111 I have some objects in folder111 which I want to pass as parameters to a dtml method in folder1 (two levels above). I tried something like: dtml-with "PARENTS[2]" tddtml-var "mtdCreate(_.None, _, qry_item='par1',qry_table='par2', list_name='par3')" /td/tr /dtml-with where par1 and par2 are strings and par3 is an object in folder111. mtdCreate is in folder1. it doesn't work... How can I do that You should be able to do: dtml-with "folder11.folder111" tddtml-var "mtdCreate(_.None, _, qry_item='par1',qry_table='par2', list_name='par3')" /td/tr /dtml-with -- Nick Garcia | [EMAIL PROTECTED] CodeIt Computing | http://codeit.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] WebOS and Zope
Curtis Maloney writes: ILet me correct myself, when I said they were going to release it opensource, it looks like just their HyperOffice suite and apps, not the "OS" itself. :( On Fri, 30 Jun 2000, Jason Spisak wrote: Zopists, I have been away for a bit, and will be gone again soon, but I found this the other day: Has anyone checked out http://www.webos.com ? It's free to sign up, just use explorer 5.0 and try it. I was amazed. It has drag and drop, looks like a real desktop. Interestingly enough, I had recently been joking about with some friends about doing something like this. Simulating a Win9x desktop with ZOPE and Javascript. I don't know jack about javascript really. Is that all they are using to simulate drag and drop and a desktop? Now for the Zope angle: I am curious if anyone thinks Zope can server up content like this? XML Desktop? I figured storing most of the info in XMLDocuments would be the simplest... I think they are using ColdFusion though. An actual webtop powered by Zope. What would it take? Hmm... well, about 2 weeks of uninterrupted time and I'd suprise even myself with how much it did. (o8 And then we woke up. They say they are going to release it OpenSource on their developer page. ;) Ooh... sounds neat. All my best, Have a better one, Curtis. dtml-var standard_work_disclaimer All my best, Jason Spisak CIO HireTechs.com 6151 West Century Boulevard Suite 900 Los Angeles, CA 90045 P. 310.665.3444 F. 310.665.3544 Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Howto engineer a scientific paper system
XML stuff in zope. Which leads me to the later suggestion, I have tried out DocBook product, rendering is very slow on my computer. And again it is too big of a new concept for me now. Yeah, I find rendering slow on my workstation too. (And mine is reasonably fast - 450mhz). DocBook does seem to take a while to get your head around the whole thing, I'm still trying to grok it myself, however it does one thing that I am really into, that is seperation of content from presentation (note, LaTeX also does this to an extent). I find it really handy to be able to give people documentation to people in the most appropriate format, (HTML for web, Postscript for print, and RTF for PHBs who use word ;). The time to compile (for want of a better term) the DocBook into a presentation format isn't too much of a problem IMHO, since once you become proficient in its use yuo won't need to compile after each change just to see what it looks like. Cheers, Benno ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] WebOS and Zope
Jason Spisak wrote: Curtis Maloney writes: [...] Interestingly enough, I had recently been joking about with some friends about doing something like this. Simulating a Win9x desktop with ZOPE and Javascript. I don't know jack about javascript really. Is that all they are using to simulate drag and drop and a desktop? Probably. A site that does this has been around for quite a while now: http://rive.boxybutgood.com/WindowMaker/ (It is down for a while, but will be back up soon (he Says) For those who have seen the WindowMaker Desktop, that's exactly what it looks like; draggable windows, layers, menuing system, Dock Apps etc. -- "Linux: the operating system with a CLUE... Command Line User Environment". seen in a posting on comp.software.testing ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] RE: Ref mxODBC and Zope
no, but I have since worked out how do it... I think. The problem is that the DateTime module of mxODBC is compiled. It needs to be renamed or repackaged to prevent the name confict. Then it needs to be recompiled. On unix I don't think this is very hard. However I am windows and this will require me to install MSVC and learn how to compile a python module dll from c code. This is not something I've had the time for. So if you or anyone else has achieved this or wants to give it a go I would dearly love a copy of the resulting dll. A mxODBC DA would drasticly improve the performance of my site. -Original Message- From: Mike Morgan [mailto:[EMAIL PROTECTED]] Sent: Friday, June 30, 2000 10:45 AM To: [EMAIL PROTECTED] Subject: Ref mxODBC and Zope Jay - Sorry to bother you, but did anyone give you pointers on importing mxODBC into a Zope product? Thanks Mike Morgan ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] (no subject)
Jim Hebert wrote: Is there a reason you can't do this by just messing with the namespaces stack, ie, adding additional folders to it? I had been latterly thinking this myself and set about trying to do it, but being new to Zope development, didn't have much success! I presume it involves modifying the folders PARENTS list, but I wasn't quite sure how to do that. Hamish Lawson = Hamish Lawson [EMAIL PROTECTED] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] 2.2b3 hangs a lot
hi all been running 2.2.0b3 for a few days now. config redhat6.1 postgres ZPygreSql kmnetnews after some time, zope just hangs. when i do top, there's no processor usage at all on all python processes. after a few minutes, zopes wake up and continue to serve. the cycle continues after some time. the hangup is very sporadic. while this is happening i can still connect to the said port, but can't GET or PUT anything. this is a site that used to work on 2.1.6, no major changes. except for the updated Lexicon.py provided by Brian. also, if i started with -Z, how long will it take zope to realize it's not responding and to restart again? if i started Zope with a non default thread, what are the concequences? anybody experienced zope hangups? help, pointers, etc, sought! i hope to document these, for the benefit of others like me. thanks -- -- http://www.kedai.com.my/kk Am I Evil? ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Re: [ZCommerce] Secure storage of credit card info
+[ Curtis Maloney ]- | On Fri, 30 Jun 2000, Andrew Kenneth Milton wrote: | Just to make those people who think "It will never happen to me" think | twice, the Australian Government Treasury site was hacked and lots of | banking details about lots of small businesses was released. | | The Australian Treasury was very happy with their security too. Until | yesterday. | | Whilst I agree that "It will never happen to me" is a stupid stance, the ATO | web site was not 'hacked'. As an example, the Federal Police and the | government are NOT doing anything to the person. Last night I heard they were still looking for him. Of course ringing JJJ first wasn't exactly a smart idea. | What happened was somebody noticed that a number in the URL for a page of | their details matched their ID number, and tried some others. Upon finding | they worked, he wrote a script to try numbers, munge the page, and e-mail | people their details. And the site is down 'indefinitely'. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] dhtml-try broken in 2.2.0b3?
I was porting some stuff that had a dtml-try to the newest Zope (2.2.0b3) and I had problems with a dtml-try block. I tried a fresh install and had the same problem. To reproduce, create a DHTML method with dtml-try dtml-var "1/0" dtml-except h4It blew up/h4 /dtml-try Accessing the document errors out with... Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: unexpected keyword argument: error_type [Snip] File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Try.py, line 212, in render File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Try.py, line 244, in render_try_except File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Util.py, line 262, in namespace TypeError: (see above) So I'm back to 2.1.6. Arrg. Any ideas? -- cary ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] MySQL Select Statements
Hi Everyone, Just need someone to put me straight here. When I use Select statements in an SQL Method I cannot simply : Select Column1, Column2 etc from TableA. Instead I must use the AS statement ie Select Column1 AS Column1, Column2 AS Column2 from TableA. Is this just an oddity with the MySQLDA/Db adapters or am I overlooking something blatantly obvious here? All the examples on zope.org don't have the extra "AS Column1" additions on them and I was wondering if this is a Zope/mySQL-unique thing. I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database Adapter (ZMySQLDA) 2.0.0a1 and MySQLdb module release: 0.2.2 . Could someone please let me know as I don't want to have to type the extra bits on all my SQL statements from here on in if I don't need to (I am the world's worst and laziest typist). If it is the case that it's a necessary evil, then I want to put a HowTo or Tip up on zope.org because it took me a while to figure out what I was doing wrong, and if I can save someone else that same wasted time then I would like to. However I wanted to get my facts straight (via all you experts) first. Thanks for any help... - Michael ~~~ Michael Blewett Computer Support Mgr - Biological Sciences Monash University (Clayton Campus) Victoria Australia 3168 " Can I trade this job for what's behind door #2? " ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Zope/Apache Question.
I would like to thank Bryan Stillwell [EMAIL PROTECTED] for his help-that is what i needed. I have Zope and Apache working together-except for the URL rewriting so I can use http://localhost/Zope and get it to launch... I am still reading docs but have multiple versions of RewriteRule. Any pointers greatly appreciated. Angel R. Rivera, [EMAIL PROTECTED] -- Website: http://www.wolf.com Our Wolf: http://www.wolf.com/Ookami.html -- "The Quality of a person's life is in direct proportion to their commitment to excellence, regardless of their chosen field of endeavor." Vincent T. Lombardi ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] dhtml-try broken in 2.2.0b3?
Fixed today. :-) Shane Cary O'Brien wrote: I was porting some stuff that had a dtml-try to the newest Zope (2.2.0b3) and I had problems with a dtml-try block. I tried a fresh install and had the same problem. To reproduce, create a DHTML method with dtml-try dtml-var "1/0" dtml-except h4It blew up/h4 /dtml-try Accessing the document errors out with... Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: unexpected keyword argument: error_type [Snip] File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Try.py, line 212, in render File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Try.py, line 244, in render_try_except File /usr2/zope2/Zope-2.2.0b3-src/lib/python/DocumentTemplate/DT_Util.py, line 262, in namespace TypeError: (see above) So I'm back to 2.1.6. Arrg. Any ideas? ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Traversal of ZODB
I wonder if anyone has a sample Python script that traverses the ZODB to query or perform arbitrary operations on the objects found in it? My present requirement is to write a script that goes through and does some automated updating of several dozen DTML documents. Thanks. David Trudgett ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Search Interface
I'm having some trouble setting up a search interface into a ZCatalog. I want to create a text index on the contents of my DTML documents, but I can't seem to get it to work. It search on title just fine. I think my problem is that I don't know how to create the right index, and what to call it (how the body or text of a DTML document is referenced). Can anyone enlighten me about this? I might be going blind, but I haven't come across anything in the documentation so far that answers my question. I'm about to resort to reading the Zope source! (which I think I will need to do sooner or later anyway, to get a better understanding of how it all works). Thanks for any assistance. David Trudgett ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] MySQL Select Statements
On Fri, 30 Jun 2000, Michael Blewett wrote: Hi Everyone, Just need someone to put me straight here. When I use Select statements in an SQL Method I cannot simply : Select Column1, Column2 etc from TableA. Depending on the column names, yes you can. I just tested it not, and it works fine. If the column names are not valid zope/python names, you will run into problems. Instead I must use the AS statement ie Select Column1 AS Column1, Column2 AS Column2 from TableA. Is this just an oddity with the MySQLDA/Db adapters or am I overlooking something blatantly obvious here? All the examples on zope.org don't have the extra "AS Column1" additions on them and I was wondering if this is a Zope/mySQL-unique thing. Can you try to construct the simplest example of a query that doesn't work? I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database Adapter (ZMySQLDA) 2.0.0a1 and MySQLdb module release: 0.2.2 . Hmm.. I am using the same, except for ZMySQLda 1.1.3, and MySQLdb 0.1.2. So, perhaps it's new in ZMySQLda 2.0. Could someone please let me know as I don't want to have to type the extra bits on all my SQL statements from here on in if I don't need to (I am the world's worst and laziest typist). If it is the case that it's a necessary What, you've never heard of cut'n'paste? (o8 evil, then I want to put a HowTo or Tip up on zope.org because it took me a while to figure out what I was doing wrong, and if I can save someone else that same wasted time then I would like to. However I wanted to get my facts straight (via all you experts) first. A wise move, and a wonderful gesture. Thanks for any help... - Michael Have a better one, Curtis Maloney dtml-var standard_work_disclaimer ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQL Select Statements
Hi Ron, If I don't specify my Selects using "AS", I then get the following error message: Error Type: KeyError Error Value: SubjectName Traceback (innermost last): File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/Zope-2.1.6-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: dtTestList) File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: dtTestList) File /usr/local/Zope-2.1.6-linux2-x86/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: dtTestList) File /usr/local/Zope-2.1.6-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: dtTestList) File /usr/local/Zope-2.1.6-linux2-x86/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: sqlRetrieveTestList) KeyError: (see above) (Where Subjectname was the first field referenced in the DTML document). Whereas, If I put the SQL as Select Subjectname AS Subjectname, etc, then it all works fine. It's funny that you say 0.2.2 is broken. Apart from this one glitch, it works fine for me (although from memory I think we had to do a little bit of fiddling at install time to get it to work). - Michael At 00:12 30/06/2000 -0400, Ron Bickers wrote: Why do you say you "must" use the AS statement? Do you get an error otherwise? MySQLdb 0.2.2 is broken when used with ZMySQLDA. But 0.2.1 works okay for me. Andy Dustman (author of the MySQLdb) said he will fix it and hinted that one should use the ZMySQLDA that is on Zope.org (v1.2.0 now I believe). Since that one now uses his MySQLdb, he will likely kill off his own DA. ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Blewett Sent: Thursday, June 29, 2000 10:53 PM To: [EMAIL PROTECTED] Subject: [Zope] MySQL Select Statements Hi Everyone, Just need someone to put me straight here. When I use Select statements in an SQL Method I cannot simply : Select Column1, Column2 etc from TableA. Instead I must use the AS statement ie Select Column1 AS Column1, Column2 AS Column2 from TableA. Is this just an oddity with the MySQLDA/Db adapters or am I overlooking something blatantly obvious here? All the examples on zope.org don't have the extra "AS Column1" additions on them and I was wondering if this is a Zope/mySQL-unique thing. I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database Adapter (ZMySQLDA) 2.0.0a1 and MySQLdb module release: 0.2.2 . Could someone please let me know as I don't want to have to type the extra bits on all my SQL statements from here on in if I don't need to (I am the world's worst and laziest typist). If it is the case that it's a necessary evil, then I want to put a HowTo or Tip up on zope.org because it took me a while to figure out what I was doing wrong, and if I can save someone else that same wasted time then I would like to. However I wanted to get my facts straight (via all you experts) first. Thanks for any help... - Michael ~~~ Michael Blewett Computer Support Mgr - Biological Sciences Monash University (Clayton Campus) Victoria Australia 3168 " Can I trade this job for what's behind door #2? " ___ Zope maillist - [EMAIL PROTECTED] 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 ) ~~~ Michael Blewett Computer Support Mgr - Biological Sciences Monash University (Clayton Campus) Victoria Australia 3168 " Can I trade this job for what's behind door #2? " ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] MySQL Select Statements
At 14:08 30/06/2000 +1000, Curtis Maloney wrote: snip Is this just an oddity with the MySQLDA/Db adapters or am I overlooking something blatantly obvious here? All the examples on zope.org don't have the extra "AS Column1" additions on them and I was wondering if this is a Zope/mySQL-unique thing. Can you try to construct the simplest example of a query that doesn't work? Sure. Here tis: select Subject, Subjectname from test order by Subject I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database Adapter (ZMySQLDA) 2.0.0a1 and MySQLdb module release: 0.2.2 . Hmm.. I am using the same, except for ZMySQLda 1.1.3, and MySQLdb 0.1.2. So, perhaps it's new in ZMySQLda 2.0. Quite possibly. I've sent a cc to Andy Dustman, just in case he's interested. Could someone please let me know as I don't want to have to type the extra bits on all my SQL statements from here on in if I don't need to (I am the world's worst and laziest typist). If it is the case that it's a necessary What, you've never heard of cut'n'paste? (o8 With two fields it's OK, but if you've got 30 fields in a table it gets pretty tiresome (even using cut paste) :o) evil, then I want to put a HowTo or Tip up on zope.org because it took me a while to figure out what I was doing wrong, and if I can save someone else that same wasted time then I would like to. However I wanted to get my facts straight (via all you experts) first. A wise move, and a wonderful gesture. That's how 'collaborative' software should work IMHO. Have a better one, No - *you* have an even better one, Thanks for the reply... - Michael ~~~ Michael Blewett Computer Support Mgr - Biological Sciences Monash University (Clayton Campus) Victoria Australia 3168 " Can I trade this job for what's behind door #2? " ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQL Select Statements
If I don't specify my Selects using "AS", I then get the following error message: Error Type: KeyError Error Value: SubjectName Traceback (innermost last): File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish ... I overlooked that you are running 2.1.6. I don't know about the error message you're getting so this may be unrelated, but I and many many others have had a lot of problems with 2.1.6 and ZSQLMethods. So many that I stuck with 2.1.4 and I'll skip directly to 2.2. It's funny that you say 0.2.2 is broken. Apart from this one glitch, it works fine for me (although from memory I think we had to do a little bit of fiddling at install time to get it to work). I don't know a whole lot about the problem, but fetch_all_rows() is missing, and for whatever reason that breaks my methods. If it's working for you, then great. I don't guess that helps you with your problem though. Did you have this problem with 2.1.4? ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
