May 2002 - Zope - Zope lists

RE: [Zope] ZSQL questions
by McDonnell, Larry 14 May '02

14 May '02

Hi, I tried your suggestion but this is the results.. <form action="form_handler" method="POST"> <dtml-call expr="input_test(REQUEST)"> <table width="75%" border="1"> <tr> <td width="27%">Document Number:</td> <td width="73%"> <input name="doc_num" size="30" value=""> </td> </tr> . . Missing input variable, doc_num I know there must be a way but I am not seeing it. Thanks -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Jon Erickson Sent: Monday, May 13, 2002 3:31 PM To: McDonnell, Larry Cc: zope(a)zope.org Subject: RE: [Zope] ZSQL questions On Mon, 2002-05-13 at 14:06, McDonnell, Larry wrote: > Hi, > > This was the only way I was able to get this to work. > > <form action="http://proton-80556:8080/intranet/input_test/manage_test" > method="get"> > input_test is the zsql. > > I tried this method <form name="form1" method="post" action="input_test"> > but this is where the next thing I see is this zsql method in test mode. Any > sugesstions, thanks ahead of time. Try this: <form action="form_handler" method="POST"> A very simple form_handler would be a dtml method like so: ---------------------------------------------- <dtml-var standard_html_header> <dtml-call expr="zsql_method_name(REQUEST)"> <dtml-var standard_html_footer> ---------------------------------------------- When the form is posted (user clicks on submit) the form variables are stored in the REQUEST object, which you can pass to a zsql method. You will need to make sure that the form variable names match that of your zsql method arguments. Jon _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

2 1

ZODB vs SQL
by Derek Basch 14 May '02

14 May '02

How about for large amounts (500,000?) of small records that never change after they are created? Thanks, Derek Basch --- Ed Colmar <ed(a)greengraphics.net> wrote: > On Fri, 10 May 2002, Derek Basch wrote: > > > Speaking of which, can anyone tell me the > practical > > size limit of the ZODB? For example, could 100,000 > > small documents be stored and indexed/searched > without > > much trouble? How many records could I store using > the > > BTree package? Is an SQL back-end my best choice > for > > large amounts of small records? > > Hi Derek > > the ZODB is best suited for objects that don't > change very freuqenctly, or > that you need to be able to undo. > > For small records that are changing, SQL is by far > the best way to go. > > -ed- > > -- > Green Graphics ::: Print and Web Design ::: > 510.923.0000 > __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com

3 5

RE: [Zope] ZSQL questions
by McDonnell, Larry 14 May '02

14 May '02

Hi, I saw the light and it works, I misunderstood the form action call. After re-reading it, I created another dtml doc and it works. Thanks for your help. I haven't programmed a while so some of the old 3gl mindset is getting in the way. ;^) -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Jon Erickson Sent: Monday, May 13, 2002 3:31 PM To: McDonnell, Larry Cc: zope(a)zope.org Subject: RE: [Zope] ZSQL questions On Mon, 2002-05-13 at 14:06, McDonnell, Larry wrote: > Hi, > > This was the only way I was able to get this to work. > > <form action="http://proton-80556:8080/intranet/input_test/manage_test" > method="get"> > input_test is the zsql. > > I tried this method <form name="form1" method="post" action="input_test"> > but this is where the next thing I see is this zsql method in test mode. Any > sugesstions, thanks ahead of time. Try this: <form action="form_handler" method="POST"> A very simple form_handler would be a dtml method like so: ---------------------------------------------- <dtml-var standard_html_header> <dtml-call expr="zsql_method_name(REQUEST)"> <dtml-var standard_html_footer> ---------------------------------------------- When the form is posted (user clicks on submit) the form variables are stored in the REQUEST object, which you can pass to a zsql method. You will need to make sure that the form variable names match that of your zsql method arguments. Jon _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

Javascript question
by Robert Rottermann 14 May '02

14 May '02

Hi, I am trying to copy data the user has entered in an >input> tag programmatically. like so function moveToZope() { document.forms[0].data.value = document.all.doc.innerHTML document.forms[0].submit() } this works fin to to about 2000 characters. If there is more data that is to be passed, I get an sintax error upon calling submit(). I tried both with document.forms[0].data being an <input> or a <textarea> Any tips how to pass more data will be greatly apprechiated. Robert www.redcor.ch

2 1

Re: [Zope] looking for framework/help/product
by Bak ＠ kedai 14 May '02

14 May '02

exuserfolder may just be the thing for you iirc exuserfolder.sf.net www.zope.org/Members/TheJester -----Original Message----- From: Alejandro Fernandez <ale(a)e-group.org> To: Zope(a)zope.org <Zope(a)zope.org> Date: Tuesday, May 14, 2002 10:46 PM Subject: Re: [Zope] looking for framework/help/product >Thanks, > >My concern with cmf, which I'm currently looking at, is that it has lots >of functionality that I don't need and that risks getting in the way of me >adding the functionality I do need... I've just been suggested >LoginManager, or I'm thinking ZSession might have what I want too. There >may be tons of products, or even example code that maintain state with >cookies, http auth or url hashes etc, and allowing registration >functions... Does anyone know of a list with examples or detailed >descriptions, or of particular products that do exactly this? > >I need to set this up quickly now, but ultimately it needs to be able to >handle hundreds of users, so it needs to be able to grow... With PHP I >know there would be loads of little scripts that did basic login/reg, but >I want to avoid using that, so that I can code in Python! > >Anyway, thanks again! Sorry for not explaining myself properly first time >round. > >Ale > > >On Tue, 14 May 2002 09:04:45 -0400 >eric.n.dunn(a)bankofamerica.com wrote: > >> http://cmf.zope.org >> works for me. Zope 2.5.0, CMF 1.2 >> Works well out of the box >> >> > I'm trying to get a quick site together that allows users to register, >> > activate an account, and then login and access certain private sites >> > individual to each user and based on database content (postgres or >> > oracle). I've been told that this functionality is present in the core > >(snips!) >-- >Alejandro Fernandez >Electronic Group Interactive >--+34-65-232-8086-- > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://lists.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: [Zope] looking for framework/help/product
by Alejandro Fernandez 14 May '02

14 May '02

Thanks, My concern with cmf, which I'm currently looking at, is that it has lots of functionality that I don't need and that risks getting in the way of me adding the functionality I do need... I've just been suggested LoginManager, or I'm thinking ZSession might have what I want too. There may be tons of products, or even example code that maintain state with cookies, http auth or url hashes etc, and allowing registration functions... Does anyone know of a list with examples or detailed descriptions, or of particular products that do exactly this? I need to set this up quickly now, but ultimately it needs to be able to handle hundreds of users, so it needs to be able to grow... With PHP I know there would be loads of little scripts that did basic login/reg, but I want to avoid using that, so that I can code in Python! Anyway, thanks again! Sorry for not explaining myself properly first time round. Ale On Tue, 14 May 2002 09:04:45 -0400 eric.n.dunn(a)bankofamerica.com wrote: > http://cmf.zope.org > works for me. Zope 2.5.0, CMF 1.2 > Works well out of the box > > > I'm trying to get a quick site together that allows users to register, > > activate an account, and then login and access certain private sites > > individual to each user and based on database content (postgres or > > oracle). I've been told that this functionality is present in the core (snips!) -- Alejandro Fernandez Electronic Group Interactive --+34-65-232-8086--

1 0

[zen@shangri-la.dropbear.id.au: Re: [Zope] Building SQL statements dynamically]
by Jim Penny 14 May '02

14 May '02

On Monday, May 13, 2002, at 09:40 PM, Tille, Andreas wrote: >Hello, > >I have to port a complex database application which has no fix SQL >statements. The user builds the statement while interacting with >some menus and after having done some selections a database query >is builded depending from several options. > >Any hint how this can be performed using Zope? See http://www.zope.org/Members/jpenny/Variable_SQL_statements Note: I strongly recommend that you NOT use this approach. It is far too easy to open database secureity problems. You have to make sure that you sqlquote every argument, without fail. It also makes debugging far harder, as depending on DA and database configuration, you may have trouble seeing the actual SQL used. Usually you can do something using dtml-sqlgroup, particularly if the query is naturally conjunctive (or naturally disjuctive, mixed usage can be more confusing). See the DTML API reference of the Zope book. Most of the examples are pretty readable. But, note that ordinary dtml may be mixed with dtml-sqlgroup code. In my opinion, this can lead to readability improvement. For an example, see Pam's ZSQL User Guide, in particular, http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.5.4.html The advantages the sqlgroup approach are two-fold. 1) quoting is handled more reliably. 2) You can test the method methodically. But, balance in all things. I have seen sqlgroup queries that were so complex that the original author could not figure out what they did, in such cases it makes a lot of sense to split the query into separate methods and use program logic to determine which to call. Jim Penny

1 0

Re: Virtual links...
by Josef Meile 14 May '02

14 May '02

After a lot of reading and testing different solutions, finally I found one that parcially works for my case. The only problem is that it works on Internet Explorer, Opera, and Netscape 4.x, but not on Netscape 6.x and K-Meleon (a Mozilla based web browser). Here is what I did: My website structure is the following: http://www.myzope.mycompany.mycountry:8080/folder1/folder2/mysitefolder I know is a complicated structure but I can't change it. And I would like to change it for: http://www.mypage.mycompany.mycountry:8080 Later I'll move it to my main site and it would be http://www.mypage.mycompany.mycountry But as I've seen the port where your zope is running doesn't care. The important thing is that your virtual links point to the server where Zope is installed and in my case that works. Access rule: In the first line I changed [-2:] for [-3:] because my domain has 3 parts and not 2 as the normal ones. <dtml-let hostname="_.string.join(_.string.split(_.string.lower(_.string.split(HTTP_HO ST, ':')[0]), '.')[-3:], '.')" sitemap="{'mypage.mycompany.mycountry': 'mysitefolder'}"> <dtml-if expr="sitemap.has_key(hostname)"> <dtml-call "REQUEST.set('SiteRootPATH', '/')"> Here I pushed the three folders that compound my site into the "TraversalRequestNameStack". As I read on one site, I have to "push the further most object/deepest object in the ZODB onto the stack first" and then the others. Deepest folder: <dtml-call "REQUEST['TraversalRequestNameStack'].append(sitemap[hostname])"> Second folder: <dtml-call "REQUEST['TraversalRequestNameStack'].append('folder2')"> First folder: <dtml-call "REQUEST['TraversalRequestNameStack'].append('folder1')"> </dtml-if> </dtml-let> Add a SiteRoot in "mysitefolder" with Base and Path empthy (as it is docs page). Then I checked the STUPID_LOG_FILE and there wasn't any error message there. In the Z2.log appears: xxx.xxx.xxx.xx - Anonymous [16/May/2002:16:19:17 +0200] "GET / HTTP/1.1" 200 213 7 "" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.2) Gecko/20010726 N etscape6/6.1" I guess it means that Netscape 6.x could process the page, but I just saw a blank page. Does anybody know what is the problem?

1 0

addng a list of users
by Bill Kerr 14 May '02

14 May '02

How could I alter the code of this method (from the Book of Zope, p. 122) so as to add multiple users from a list? Where I have 'abc' (adds one user abc) I want to add more than one user simultaneously (abc, xyz etc.), all with the same PW, role and domain. I tried inserting <dtml-in expr="['abc','xyz']"> where the 'abc' is and put </dtml-in> in the second last line but that generated a Parse Error <dtml-var standard_html_header> <h2><dtml-var title_or_id></h2> <dtml-call expr="REQUEST.set('roles',['noRole'])"> <dtml-call expr="REQUEST.set('name','abc')"> <dtml-call expr="REQUEST.set('password','change')"> <dtml-call expr="REQUEST.set('confirm','change')"> <dtml-call expr="REQUEST.set('domains',[])"> <dtml-call expr="acl_users.manage_users('Add',REQUEST,RESPONSE)"> The user <dtml-var name="name"> has been added. <dtml-var standard_html_footer> -- Bill

3 5

Uploading contents of a file
by Marie Robichon 14 May '02

14 May '02

Hi, I have written a method to create a folder with a page template inside. What I would like to do is provide the user with a form similar to the edit form with an upload file field in order to place the contents into the page template. I haven' t figured out how to recover the contents of the uploaded file. How do I access manage_upload, and how do I inject the contents into my page template? My method is : <dtml-call "manage_addFolder(folderid, foldertitle)"> <dtml-with "_[folderid]"> <dtml-call "manage_addProduct['PageTemplates'].manage_addPageTemplate('index_html', foldertitle, file)"> </dtml-with> In the API it talks about ZPythonScriptHTML_upload, but I don' t have a clue how to use it, am a (struggling) newbie.... Thanks for any clues or pointers as to where to find the answers, Marie Robichon Web Task Force European Synchrotron Radiation Facility BP 220 38043 Grenoble Cedex France http://www.esrf.fr Tel: (33) 04 76 88 21 86 Fax: (33) 04 76 88 24 27

3 2