- Zope - Zope lists

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

Selection
by Rogerio Atem de Carvalho 21 Jun '00

21 Jun '00

Hi, I am using sql to fill a selection, following a How-To. When I try to pass the selection plus some text parameters to a sql method, Zope gives me an error. Aparently, the selectioned value is not being passed as a value to the sql. How can I pass the selectioned value as a parameter? Regards, Rogerio Atem ------------------------------------------- E-mail enviado pelo servidor do CEFETCampos

1 0

Re: [Zope] ZDiscussions Problem
by Dieter Maurer 21 Jun '00

21 Jun '00

> <dtml-with TMLDiscussion> > > </dtml-with> > > ..., i get this error: > > Error Type: NameError > Error Value: r > > Whats going on? And how do i display the discussion on my index page? Probably a small bug in ZDiscussion. I have had something similar in ZTopic. You should have gotten a traceback. Its bottom line tells you in what file and what line the NameError occured. Look there, why "r" is not defined. It is probable that in some exception case an assignment to "r" is missing. It probably is available in the non exceptional case. See whether this assignment could be used in the exception case, too, or whether "r" can be initialized to a default value (None or ''). Dieter PS: Because Mailman digests discard MIME headers, MIME messages are somewhat difficult to read for me. Could you please switch off, "multipart/alternative" text/html message sending to this list.

1 0

Newbie Question (dropdown menu)
by joel grimes 21 Jun '00

21 Jun '00

I'm trying to fill a combo-box (pardon the vb-centric lingo - I don't know what the things are called - it's a <select...><option...> thing) with items selected from a table. I haven't a clue how to do this. I've got the ODBC Connection and SQL Method working, but how do I iterate through the query results to fill a drop-down? Thanks Joel Grimes ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

3 2