June 2000 - Zope - Zope lists

Big folders
by Jimmie Houchin 21 Jun '00

21 Jun '00

I've been studying SQL this week because I've been thinking that I'll probably have to use a RDBMS to develop my site. Ideally and philosophically I like ZODB. Mountable ZODBs give me much of what I need with the possible exception of a big folder problems. My databases will have millions of objects in what would/will be single table/folders. From what I understand ZODB doesn't currently do big folders well. So I guess my question is, should I continue with the SQL and the RDBMS or is there a solution that I don't know about or understand with ZODB? My apologies if this covered somewhere. Jimmie Houchin

5 6

More reliable Database Adapter for linux
by Pedro Vega 21 Jun '00

21 Jun '00

Hi all. What is the more reliable database adapter for linux ? Regards. Pedro Vega

3 3

problems using sendmail-tag
by Philipp Dunkel 21 Jun '00

21 Jun '00

Hi everybody. I have a form that calls a sendmail tag to send user-feedback to a specific email-adress. When I try to send mail I always get the error: Recieved error code 553 from SMTP: 553 ... Domain name required I know that this error occurs if the user is not allowed to send mail from that host. The strange thing is that my zope runs under user 'zope'. But if I telnet to port 25 (sendmail) as user 'zope' I can send mail?? Any Ideas? TIA Philipp Dunkel ******************************************** * Philipp Dunkel ICQ# 60149094 * * zReal Productions * * meet me at DALNet chan #phidu * ********************************************

2 1

this is not the message you are looking for
by ethan mindlace fremen 21 Jun '00

21 Jun '00

move along

1 0

Re: [Zope] ZSQL newbie question
by Dieter Maurer 21 Jun '00

21 Jun '00

kamon ayeva writes: > I have a text file object containing data I want to use to update a MySQL > table. > I can get the data using the LocalFS object product and the howto from > jfarr, but I don't know how to use ZSQL method and DTML method to inject > this data in the table. You should know (or learn) a bit of SQL, especially the SQL "insert" command. You should have had a look into the Z SQL Methods User Guide (--> zope.org/Documentation) After that, only a tiny bit is missing: you file object will provide a method "read". You can use it to return the file content as a string. You put this string on a parameter position for an SQL insert. Something like: <dtml-call "sqlinsert(...,data=file.read())"> As you probably expect, I used "sqlinsert" for your Z SQL method that uses the SQL "insert" command to insert a new row into a table and "file" for your file object. The "..." stand for the other arguments and values, that define the remaining fields in your table. Note the "...". These double quotes are essential. Dieter

1 0

Connect String for mysql with SQLRELAY
by Harald Koschinski 21 Jun '00

21 Jun '00

Hallo, does anybody know how to connect to a mysql database with SQLRELAY (the brand new adapter?) The form-help says: The connection string used for Z SQLRleay Database Connections are as follows: hostname portnumber username password but that´s not enough - where is the Database connecting to.

1 0

Re: [Zope] problems using sendmail-tag
by Dieter Maurer 21 Jun '00

21 Jun '00

Philipp Dunkel writes: > I have a form that calls a sendmail tag to send user-feedback to a specific > email-adress. > When I try to send mail I always get the error: > > Recieved error code 553 from SMTP: 553 ... Domain name required > > I know that this error occurs if the user is not allowed to send mail from > that host. The SMTP error 553 means that there is a syntactical problem with one of the mail headers, usually an address header. Your SMTP server tells you that it expects a "Domain name" and there is none. This may be indicative to either: 1. one of your mail headers (To:, From:, ...) is faulty 2. you did not specify any domain name and the SMTP server cannot provide the default domainname due to some configuration problem. Under Unix, the program "hostname -f" provides the default host name. Dieter

1 0

Re: [Zope] Probably a simple name space question
by Dieter Maurer 21 Jun '00

21 Jun '00

Bert Jan Bakker writes: > I want to call a Z SQL Method (say InsertFoo) > from a DTML Method (say CallingInsertFoo) and > it just won't work. > > The Z SQL Method takes three arguments, let's > call them a_id, b_id and c_id. > > All three arguments are available to me > in the calling DTML Method. I can print > them in HTML. But when I call the query > with <dtml-var InsertFoo> I get the following > error: > > "Error Type: Bad Request > Error Value: ['a_id', 'b_id', 'c_id']" This problem seems to come up once in every few weaks --> an FAQ. Okay, again: ZSQL methods are stupid, in that they only look at the REQUEST object and not at the namespace to find their arguments. You could avoid this weakness by: 1. <dtml-var "InsertFoo(a_id=a_id, b_id=b_id, c_id=c_id)"> This provides the arguments explicitely. 2. <dtml-call "REQUEST.set('a_id',a_id)"> .... <dtml-call "REQUEST.set('c_id',c_id)"> <dtml-var InsertFoo> This puts the argument values into the REQUEST object. Dieter

1 0

Re: [Zope] python product - newbie
by Dieter Maurer 21 Jun '00

21 Jun '00

Bak @ kedai writes: > i'm messing around with Boring product, and now wants to do more. i have > problems when i got more than one class in a product. this is what i wanted to > do. > > create a guestbook (what else :)) product. GB.py with two classes - GB and > GBitem. i can now load GB product, but can't add GBitem. what do i need to do > to get the 'Add' selection box? You probably have only registered one of the classes as meta types. Have a look at "Products/ZSQLMethods/__init__.py". It registers two classes "Z SQL Methods" and "Z Search Interface". There should be a Product API Guide somewhere on zope.org. That's the documentation, that may help you. Dieter

1 0

Re: [Zope] Looking into folders
by Dieter Maurer 21 Jun '00

21 Jun '00

Felipe Alvarez Harnecker writes: > I need to query if one folder has sub-folders in it or not. You can use the "tpValues" method. It is used by the "tree" tag to determine whether or not the node can be expanded. > I want to manipulate every object returned by the "tree" tag like this > > <dtml-tree bla bla ..> > > <dtml-let myObject="tree object"> > > <dtml-var myObject.someProperty_or_method_or_something> > > </dtml-let> > > </dtml-tree> A look at the tree tag code in "TreeDisplay.TreeTag" convinced me, that (unlike "dtml-in") "dtml-tree" does not provide a direct reference to the rendered object. You may (or may not) have luck and the rendered object has a "this" method (many Zope objects have). Then you can use "this()" as a reference to the object. You must take care for cases, when "this" does not exist. I think, "dtml-tree" should define "tree-item" in analogy to the "dtml-in"'s "sequence-item". This is a low priority feature request, I will put into the locator, if I do not forget it. Dieter

1 0