- Zope - Zope lists

ZSQL Method problem
by McDonnell, Larry 16 Jul '02

16 Jul '02

Hi, I have come across a strange problem in ZSQL Method. I am using OBDC adapter to MS Access. Below is real information. part_num:string="%" title_description:string="%" category_type:string="%" select * from part_number where (part_num like <dtml-sqlvar part_num type="string">) and (title_description like <dtml-sqlvar title_description type="string">) and (category_type like <dtml-sqlvar category_type type="string">); To test this query, I input the following: Part_num 66% title_description % category_type % My results: There was no data matching this Type Part Number Search query. select * from part_number where (part_num like '66%') and (title_description like '%') and (category_type like '%'); If I remove the variable category_type I will see records displayed with a part_num starting with "66". If I add it back I get no results. All the variables has information stored in the db. I have used other ZSQL methods with as many 4 parameters and they work. I thought maybe there were some reserved words and changed it to document_type but the same results. Any clues? Larry McDonnell Proton Energy Systems 50 Inwood Rd. Rocky Hill, CT 06067 (860) 571-6533 ext. 531 Email:lmcdonnell@protonenergy.com www.protonenergy.com

1 0

Re: [Zope] sorting a table
by Stephan Goeldi 16 Jul '02

16 Jul '02

> Ok...its sort of complicated and there are a lot of supporting files, but > here are a few of them. You should be able to get the concept from these... No, my wish is much simpler: I have this dtml-in: <dtml-in blabla sort=sortkey> <blabla> </dtml-in> I just want to reload the url with something like this: http://url/blabla?sortkey=title Is this so complicated? How can I bring a variable from the url to the dtml-in Tag?

3 3

Custom sorting
by Bjørge Solli 16 Jul '02

16 Jul '02

I want to make users who upload some files, arange the order of the files themselves. I plan on doing this by adding a property to each file named 'sortorder'(int). And then order on this property. I think this is a bad solution, since it means when a user wants to insert a file as #2, I have to update all the other files who has sortorder>=2. So is there another way of doing this? regards Bjorge Solli -- http://www.lstud.ii.uib.no/~s0182/smile/Smiles -- Bjørge Solli - Universitas Bergensis, Norway mailto:Bjorge@Kvarteret.no icq#29210281 MSN:bobelloco@hotmail.com Møllendalsv.19, 5009 Bergen, Norway tel:55202853/91614343

2 1

Heeeeeeeeeeeeelp (login problem)
by Breuer, Yvon 16 Jul '02

16 Jul '02

Hi Zope-wizards, As you can see in my subject: I'm getting quite frustrated by some stupid error when I'm trying to login to my Zope server. (Yep, I'm a newbie...) Situation I'm going to create a website to gather funds for a hospital in Ghana (St. John of God Hospital in Duayaw Nkwanta). To get an idea about the situation: http://www.zwo.nhl.nl/hbov/buitenlandstage/ghana.html (Dutch & English). Website I want to do this with Zope & Python. I want people to be able to do online donations, retrieve information about the project, maybe send a mailinglist to keep them up to date and there are many more plans. So: I've got a lot to learn... Learn & develop @ work & @ home In order to learn as quickly as possible I tried to install Zope at work and at home (of course during my break ;-) ). At work (Win2000 Prof.), everything functions OK. I've done the tutorial and I'm now working myself through the ZopeBook. So far so good, but... My problem At home I've installed Zope (2.5.1) on my computer (Win98). No errors occured during installation. So, just like at work I tried to login to Zope for the first time, but... When I start the START.BAT, my computer starts a dial-in to my internetprovider! It seems this occurs when START.BAT is trying to retrieve my hostname. When START.BAT is finished, I type in... * http://127.0.0.1:8080/manage (START.BAT comes up with 127.0.0.1 as localhost and 8080 as port) * http://popeye:8080/manage or http://popeye:8021/manage (popeye is the computername in my Win98 network-settings and START.BAT comes up with popeye as localhost for port 8021) * http://localhost:8080/manage (should always work, right? Not!) * http://stjohnhospital:8080/manage (stjohnhospital is the superuser I installed Zope with) ... but none of them works!!! All that happens is that my browser (MsIE) when I'm offline shows me that the page cannot be found and when I'm online it shows me either "server error" or "page not found". >:-(( NB: It doesn't matter wether I login to my internprovider or not. I'm quite sure it's nonesense to be online in order to login to a local Zope-server, but hey, I've tried everything possible (as far as I know). I also tried to un- and reinstall Zope, but that didn't work either. :-( So please, help me out here!!! (In a short while I've got some days off and I want to do some work for the website at home.) Not only me, but also the people we're trying to help will be very gratefull! ;-)) Best regards, Yvon Breuer

4 3

Product Creation: Adding Folder
by Alexander M Hottenstein 16 Jul '02

16 Jul '02

I am attempting to create a ZClass for a new product, which, when created on the site will automatically add a visible folder. I have attempted to use a folder directly within the ZClass, but for some reason it causes security problems. I know there is a way to do this, but I am not sure how to. If you have any ideas, please let me know. - Alex

2 1

Re: [Zope-CMF] Zope behind Apache
by P Kirk 16 Jul '02

16 Jul '02

Hi Seb, Still having probs but almost there. My httpd.conf now reads: NameVirtualHost pkirk.net.dhis.org <VirtualHost captain.kirks.net> ServerName captain.kirks.net DocumentRoot /var/www <IfModule mod_rewrite.c> RewriteEngine On RewriteLog "/var/log/apache/rewrite_log" RewriteLogLevel 1 RewriteRule ^/local/ - [L] RewriteRule ^/icons/ - [L] RewriteRule ^/~(.*) - [L] RewriteRule ^/cgi-bin/ - [L] RewriteRule ^/(.*) \ http://pkirk.net.dhis.org:9673/VirtualHostBase/http/captain.kirks.net:80/ca… [P] </IfModule> </VirtualHost> lynx http://pkirk.net.dhis.org and lynx http://captain.kirks.net both bring up Zope while lynx lynx http://localhost and lynx lynx http://enterprise bring up Apache. I wonder if you can see why? Patrick

2 1

sorting a table
by Stephan Goeldi 16 Jul '02

16 Jul '02

I am looking for a sorting mechanism similar to that in the ZMI, where I can click on the header "ID" to let the objects be sorted by the id. This I would like to implement in a HTML table, which is laid out like this: id title date I would like to make the headers appear as links, which reloads the current url with something like this: http://localhost:8080/current_page?sorttype=title How do I have to format the dtml-in tag to use this url for sorting? I already tried this: dtml-in blabla .. sort=&dtml-sorttype; without success.

2 1

RE: [Zope] total "hits" in dtml-in?
by Schmidt, Allen J. 16 Jul '02

16 Jul '02

<dtml-in mysqlmethod> <dtml-if sequence-start> Total Records: <dtml-var count-MyVarName> </dtml-if> Current Value: <dtml-var MyVarName> </dtml-in> Basically, just add 'count-' to a variable to count. This gives the count all the records in the result set. -Allen -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of A M Thomas Sent: Tuesday, July 16, 2002 8:00 AM To: zope(a)zope.org Subject: [Zope] total "hits" in dtml-in? Hello, I've just put together my first Zope/MySQL database search interface. Gosh that's cool. However, I have a question. Obviously. How can I get the _total_ number of returned results for a <dtml-in> statement (not the number in the current batch)? This is probably so obvious that it's staring me in the face, but I can't find it anywhere. I even tried (quickly) perusing some source code, but maybe I was looking in the wrong place. My main reference has been the Zope book, another Zope book, and searching the web site. I know about the cool dtml-in variables like previous-sequence-start-index, next-sequence-size, etc., but I want to be able to state on my results form "records 21-40 of X shown" - how do I gracefully get X? I know I could do a len() of the query, but that seems like a bad idea because the database would essentially get queried twice - once to get the len, and once to create the <dtml-in> list. Right? Am I missing something? Of course I am. Any help would be much appreciated. Yours, Am _______________________________________________ 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 )

3 2

Accessing openLDAP Server from Python Script inside a Zope CMF.
by Ashish Gautam 16 Jul '02

16 Jul '02

Hi all, I am trying to access openLDAP server from a python script inside CMF site of Zope. I have python-ldap module installed on a linux machine. My final intention is to Add an LDAP entry in to LDAP server. Following code i have written in a python script just to get started by connecting to LDAP server and accessing the existing contents. My approach to add an entry from python script is correct or its bound to fail? Script starts: import ldap ldapCon = ldap.open("localhost") ldapCon.simple_bind_s("cn=Manager,o=Lambent","secret"); print ldapCon.search_s("ou=HR,o=Lambent",ldap.SCOPE_SUBTREE,"objectclass=*") return printed Script ends. I am clueless as to what is causing this problem. Following error i have encountered : An error was encountered while publishing this resource. Error Type: Unauthorized Error Value: You are not allowed to access open in this context Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File /usr/local/Zope2.5.1/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/Zope2.5.1/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/Zope2.5.1/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: testsite) File /usr/local/Zope2.5.1/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/Zope2.5.1/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: ldap) File /usr/local/Zope2.5.1/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: ldap) File /usr/local/Zope2.5.1/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: ldap) File /usr/local/Zope2.5.1/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: ldap) File /usr/local/Zope2.5.1/lib/python/Products/PythonScripts/PythonScript.py, line 302, in _exec (Object: ldap) (Info: ({'script': <PythonScript instance at 8bbbeb0>, 'context': <CMFSite instance at 8b10098>, 'container': <CMFSite instance at 8b10098>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 7, in ldap File /usr/local/Zope2.5.1/lib/python/AccessControl/ZopeGuards.py, line 60, in guarded_getattr (Object: ldap) File /usr/local/Zope2.5.1/lib/python/AccessControl/SecurityManager.py, line 83, in validate File /usr/local/Zope2.5.1/lib/python/AccessControl/ZopeSecurityPolicy.py, line 145, in validate Unauthorized: (see above) Plz reply ASAP, Regards Ashish.

2 1

Re: [Zope] Showing html files
by Jaroslav Lukesh 16 Jul '02

16 Jul '02

---------- Odesílatel: andre <zope(a)bkinformatik.dk> I'm quite new to zope, and have a little question. I have some html files in different sub-folders I want to show. In the parent folder I have made a index_html to show a list of the files. The thing is that I want to show them including a header and a footer. I can't change the html-files, and the files is uploaded by users, so it has to be a dynamic solution. I hope someone can help me. ---------- Im quite new too, but I have different complette solution via STX. Many very advanced users was help me in last weeks, so let take a look to archive with my name and look to threads. There is maybe a future product for mid-sized collaborative webs (hundreds of pages). So I have files in folders as basic structure of the web. Each menu item is separate folder. If in folder is index.htm, then is fully rendered alone without footer and header. On opposite case is files rendered as segments, regardless if it is HTML formatted (without <html><head>etc tags) or STX (structured text) document. Segments are sorted via his ID and should be temporary hidden via property HIDE. Note that if you want add picture to STX segment, use segment_name.gif as name of picture, picture then will be displayed right from text of current segment. Print format was obtain via www.site.com/path/document/print I hope that these info will be very usefull not only for you and will save many hours. I am very happy, that WORKS! Best regards J. Lukesh /siteroot +index_htm +header and footer with generated menu +sys_list-item +print +navi_BANNER /folder1 +file1.htm +file2 +file2.gif /folder2 +file1 +file1.gif /folder21 +index.htm /folder3 +file1 +file2 ...etc DTML Methods are here: ----8<-------------8<-------------8<-------------8<---- /index_html: <dtml-if "_.hasattr(aq_explicit,'index.htm')"> <dtml-var index.htm> <dtml-else> <dtml-var standard_html_header> <dtml-var sys_list-item> <dtml-var standard_html_footer> </dtml-if> ----8<-------------8<-------------8<-------------8<---- /sys_list-item: <dtml-in expr="objectValues('DTML Document')" sort=id> <dtml-if "hasProperty('hide')"><dtml-else> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="100%"> <h3><dtml-var navi_BANNER></h3> <dtml-var sequence-item fmt=structured-text> </td> <dtml-try> <td> <dtml-var expr="_[id()+'.gif']"> <dtml-except> </td> </dtml-try> </tr> </table> </dtml-if> </dtml-in> ----8<-------------8<-------------8<-------------8<---- /navi_BANNER: <dtml-if "hasProperty('dlouhy')" ><dtml-var dlouhy ><dtml-else ><dtml-var title ></dtml-if> ----8<-------------8<-------------8<-------------8<---- /print: <dtml-if "_.hasattr(aq_explicit,'index.htm')"> <dtml-var index.htm> <dtml-else> <html><head><title><dtml-var title_or_id></title></head><body> <dtml-var sys_list-item> </body></html> </dtml-if> ----8<-------------8<-------------8<-------------8<----

1 0