July 1999 - Zope - Zope lists

RE: [Zope] Newbie: How to UPDATE records in MySQL?
by Alexander Staubo 07 Jul '99

07 Jul '99

Here's a small example. The DTML Method to view your table should look something like this:: ...   <table> <tr> <th>Name</th> <th>Age</th> </tr>  <tr> <td><a href="ViewRecord?id:int="></a></td> <td></td> </tr>  </table>   No records.  ... where AllRecordsSql is an SQL Method that returns the whole table, with columns "recid", "name", and "age". Your ViewRecord DTML Method should look like so::  <form action="" method="post"> <input type="hidden" name="id:int" value=""> <table> <tr> <th align="right">Name</th> <td><input type="text" name="name" value=""></td> </tr> <tr> <th align="right">Age</th> <td><input type="text" name="age:int" value=""></td> </tr> </table> <input type="submit" name="SaveRecord:method" value="OK"> <input type="submit" name="index_html:method" value="Cancel"> </form>  Record not found.  where FindRecordSql is an SQL Method that does something like select recid, name, age from people where recid =  This form uses a Zope trick that allows you to have multiple submit buttons, each triggering a different method on the parent folder. Also note how I use things like ":int" to indicate the type of form variables; otherwise Zope will just stringize everything. Your SaveRecord DTML Method could look like this::  Or it could look like this::  Or like something else; I do prefer myself to pass SQL arguments explicitly, though, rather than just pushing the complete REQUEST namespace. You can also use _.namespace() to pass your arguments. Finally, UpdateRecordSql is an SQL Method that says something like: update people set name = , age =  where recid =  With me so far? -- Alexander Staubo http://www.mop.no/~alex/ "What the hell, he thought, you're only young once, and threw himself out of the window. That would at least keep the element of surprise on his side." --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_ >-----Original Message----- >From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of >piotrk(a)ibb.waw.pl >Sent: 7. juli 1999 04:08 >To: zope(a)zope.org >Subject: [Zope] Newbie: How to UPDATE records in MySQL? > > >I have MySQL database connected to ZOPE 1.10.3. I can search >and INSERT new records, but I don't know how to edit and >UPDATE single records. > > >I think that a single record in a database can be updated in >the following way: > >1. Search the database and display the results in tabular >format (it is already working). > >2. Select a single record to edit - I do not know how to make >a link from tabular search result to a single record (i.e. >hyperlink from a record first field to page with forms >containing data preloaded from fields to be edited. > >4. POST the changed form and UPDATE the database record. > > >Could you please send me some sample code? Are there any >on-line documentation I can read? I have found plenty of >information about searching and inserting data into internet >accessible databases but no information about updating >database records. > >TIA > > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(For developer-specific issues, use the companion list, >zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Get back from external method
by raver＠box.dust.za.net 07 Jul '99

07 Jul '99

Hi! Problems just keeps popping out here ... I have a dtml method contained in a ZClass that pass on forms data to an external method (doing sql insert in a MySQL table). Doing it the normal? way I have this method say the insert went ok, but that's not what I want really, I want to be placed back into a ZClass dtml method when the insert is finished. So the question is - how can I do the 'go back' from the external method automagically? (is the dtml '<!--"#call RESPONSE.redirect...' going to do the trick? if so - whats the syntax in the external method to do it?) Help is much appreciated! Sture Lygren

1 0

Basic ZServer/Zope Question - OBJECT's and Includes
by Matthew Marlowe 07 Jul '99

07 Jul '99

Hello, I'm sure I must have missed something in the documentation...but would appreciate any help. I am trying to create a Zope object that is nothing more than a dynamic include(embedding) of an external web page. Standard HTML4 like the OBJECT tag doesn't work, and creating an object the normal way means uploading only one instance of the object?  also doesn't seem to be a valid tag. Thanks, Matt -- Matthew Marlowe http://www.jalan.com/ (p) 909.799.3805 mmarlowe(a)jalan.com Jalan Network Services (f) 909.799.3285 "Quality Web Hosting, Network, Linux, and Solaris Consulting"

1 0

RE: [Zope] semipersistent
by Jay, Dylan 06 Jul '99

06 Jul '99

> -----Original Message----- > From: Robin Becker [mailto:robin@jessikat.demon.co.uk] > Sent: Wednesday, July 07, 1999 02:01 > To: zope(a)zope.org > Subject: [Zope] semipersistent > > > I'm using various external methods to create GIF files in my current > server. These are expensive to produce, but are created on a per user > basis eg as the results of a user input. > > How can I make these temporary in the sense that they live until the > connection is dropped. Its quite easy. Just have a method like this def getGif(self, AUTHENTICATED_USER, REQUEST, RESPONSE): res = makeGif() RESPONSE.setHeader("Content-Type",'image/gif') return res Then just call the method directly ie <img src="blah/getGif">

1 0

RE: [Zope] Running Zope with Apache
by Michel Pelletier 06 Jul '99

06 Jul '99

> -----Original Message----- > From: Jeff Clement [mailto:jeff@bluesine.tj] > Sent: Tuesday, July 06, 1999 2:38 PM > To: zope(a)zope.org > Subject: [Zope] Running Zope with Apache > > > Is there any good documentation on making Zope run with > Apache? I've added the rewrite lines to > the .htaccess in my directory. Whenever I run Zope.cgi from > commandline I get error (102) failure > during connect. And running from the server givew error 500. > If you can help it, do not put the rewrite rule in your .htaccess file. The whole concept of rewrite rules in a .htaccess file is intense voodoo (if you don't believe me, read the rewrite docs). Check out Zap, the precompiled, preconfigured, guaranteed to work or your money back Apache for Zope. http://www.zope.org/Download/Releases/Zap-1.1.0 -Michel PS: Zope works with Apache, we use it all the time. > Thanks, > Jeff > > 7/6/99 12:35:34 PM > > > [ Jeff Clement / BlueSine Consulting] > email: jeff(a)bluesine.tj > web: www.bluesine.tj > cell: 403.850.9180 > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1

RE: [Zope] Newbie: Publishing directories
by Jay, Dylan 06 Jul '99

06 Jul '99

> -----Original Message----- > From: Larry Luther [mailto:l.luther@acm.org] > Sent: Tuesday, July 06, 1999 16:39 > To: zope(a)zope.org > Subject: [Zope] Newbie: Publishing directories > > > Hello, > > I am trying to understand how I could have a dhtml page > offer a link to a file on another machine via a network path. > > Given: > * Window NT 4.0 workstation environment. > * Zope 1.10.3 tied to IIS server via "cgi-bin". > > I've read: > * Zope only publishes data uploaded to it. > * That work is being done on products that > would allow external html directories to be > linked into Zope's html object hierarchy. > This future solution might solve my problem > if they allowed network path names. > * That an external Python method could be written that > would read the network file and offer it as > a local object. > > I've tried: > * "file:\\othermachine\foobar.html" (in a link) > This works for anyone on the local network but not > for anyone on the outside. (I knew it wouldn't > but offer it as an indicator of what I'm trying to do. > > Questions: > * Is my understanding of the state of affairs correct? > * Does IIS offer a solution? If you want to serve up a file you need 2 things: 1) A server of some kind that will make the file available 2) A client that has the ability to connect to the server A web server is one kind of server. The microsoft network is another kind of server. MS stuff only works on a local lan. Web servers work over TCP/IP. So basically if you have clients with web browsers that are not on the local lan just put a web browser on each of the machines you want to server from. An alternative is to have a cgi script on your central web server that reads the file off the network and outputs it out. This has sequrity risks and is a bit dodgy but it will probably work.

1 0

Error, exceptions.KeyError: (anything)
by Perez, Victor 06 Jul '99

06 Jul '99

Hi there: I just don't know what's wrong, I've installed ZodbcDA and connects fine to M$Access databases. I can create SQL methods like: "select * from (database)" and it shows the whole thing without problems. I tried something like the examples on the Z SQL guide trying to make it give me the phone: ======================= select * from phonelist where  ====================== and all what I get is the following error message: ====================== Error, exceptions.KeyError: phone SQL used: Could not render the query template! ====================== No matter what I put on the 'name' field of sqltest I get this error... Any ideas? - Atentamente, Victor Perez Muena Automation Support - Port Area (Los Vilos) Los Pelambres Project - Bechtel Chile Ltda. Ext. 8033, Phone: (2) 361-8033 - Fax: (2) 361-8025

3 2

RE: [Zope] Running Zope with Apache
by Michel Pelletier 06 Jul '99

06 Jul '99

> -----Original Message----- > From: Jens-Uwe Schmidt [mailto:jens@pr-schmidt.h.uunet.de] > Sent: Tuesday, July 06, 1999 7:33 PM > To: Michel Pelletier > Cc: 'jeff(a)bluesine.tj'; zope(a)zope.org > Subject: Re: [Zope] Running Zope with Apache > > > Hi, > > Michel Pelletier wrote: > > > > > -----Original Message----- > > > From: Jeff Clement [mailto:jeff@bluesine.tj] > > > Sent: Tuesday, July 06, 1999 2:38 PM > > > To: zope(a)zope.org > > > Subject: [Zope] Running Zope with Apache > > > > > The ZAP-Package works, but both methods for authentication > pass-through > (as mentioned in http://www.zope.org/Download/Installation/WebServer) > simply don't work in my case. > Do you mean that Zap works but your Apache doesn't? Did you try looking at the zap.conf (it's really httpd.conf in disguise) to see how Zap does it? > Maybe someone can post his setup in httpd.conf together with locations > and access rights of the relevant files. All of ours pretty much look just like Zap, that's how we figured out how to built it ourselves. > > The mod_rewrite rules are just a nightmare to understand and > pretty soon Yep. Setting up a Zope rewrite rule is trivial, however, when it comes to putting a RewriteRule in your .htaccess file. *shudder* -Michel

1 0

Re: [Zope] Using Zclasses
by Kevin Dangoor 06 Jul '99

06 Jul '99

--- Michael Bernstein <mbernstein(a)profitscape.net> wrote: > If anyone else agrees with Alexander and myself that > being able to > assign 'pointers to objects' as attributes ( as > opposed to actually > instantiating an object as an attribute) would be a > good addition to the > Zope interface, let me know, and I'll incorporate > your suggestions > before I post this to the Collector. I think this would be a *very* worthwhile thing. I believe that someone (Ty Sarna?) posted a test symlink Product a while back. Something that can perform that kind of function and be lightweight and easy would be excellent. I, for one, would much rather use ZODB than a relational database, but I can't imagine not having some way to link objects together. Kevin _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

1 0

ZClasses an methods again
by raver＠box.dust.za.net 06 Jul '99

06 Jul '99

Hi again! Thanks to Alex Rice for answering my first post, but it didn't solve my problem (probably because I was vague on explaining in the first place). I'll try again. I've made a ZClass wich I want to supply with different dtml 'form' methods. The problem is the action part of the <FORM>. What should it be like if the method is to call other methods contained in the class. When calling the form method from a class instance I end up with errors reffering to the action method not existing in the calling folder. Thanks in advance Sture Lygren

1 0