March 2003 - Zope - Zope lists

RE: [Zope] sort based on a variable
by Michael Guerrero 17 Mar '03

17 Mar '03

That's exactly what I was looking. Thank you very much and others that replied as well. Thanks again. Mike Guerrero -----Original Message----- From: Chris Beaven [mailto:chris@d-designz.co.nz] Sent: Monday, March 17, 2003 2:27 PM To: Michael Guerrero Cc: zope(a)zope.org Subject: Re: [Zope] sort based on a variable I believe your looking for sort_expr <dtml-in get_list sort_expr="t_sort_order"> Michael Guerrero wrote: >I have a table tab1 with 3 columns col1,co2,col3. > >I've defined a sql method 'get_list' as 'select col1,co2,col3 from tab1. > >In a dtml method (view_list)I want call get_list and sort on any of the >three columns. I know I can do the following: > ><dtml-in get_list sort="col2"> > display stuff here ></dtml-in> > >I'm passing the sort order column to view_list using --> >view_list?sort_order=col2 > >I get no error but incorrect results when I try to do the following in >view_list: ><dtml-call "REQUEST.set('t_sort_order',sort_order)"> ><dtml-in sql_list_rma sort=t_sort_order> > >I also tried putting various combinations of single and double quotes >around t_sort_order' without any luck. > >I can display t_sort_order, so I know it's getting the proper value. It >just doesn't evaluate correctly. I think it has something with >double-quotes needing to surround the sort filename. > >I really don't want to create 3 sql methods >(get_list_by_col1,get_list_by_col2,get_list_by_col3). > >I'd appreciate any help. > >Thanks. > >Mike Guerrero > >. > > >

1 0

RE: [Zope] sort based on a variable
by Passin, Tom 17 Mar '03

17 Mar '03

I like to have the database to the sorting whenever possible. You can change your sql statement to something like select col1,co2,col3 from tab1 order='<dtml-var t_sort_order>' Or, a little more compact using entity notation, select col1,co2,col3 from tab1 order='&dtml-t_sort_order;' If you want to sort on more than one column, just create the right string for t_sort_order. Cheers, Tom P [Michael Guerrero] I have a table tab1 with 3 columns col1,co2,col3. I've defined a sql method 'get_list' as 'select col1,co2,col3 from tab1. In a dtml method (view_list)I want call get_list and sort on any of the three columns. I know I can do the following: <dtml-in get_list sort="col2"> display stuff here </dtml-in> I'm passing the sort order column to view_list using --> view_list?sort_order=col2 I get no error but incorrect results when I try to do the following in view_list: <dtml-call "REQUEST.set('t_sort_order',sort_order)"> <dtml-in sql_list_rma sort=t_sort_order> I also tried putting various combinations of single and double quotes around t_sort_order' without any luck. I can display t_sort_order, so I know it's getting the proper value. It just doesn't evaluate correctly. I think it has something with double-quotes needing to surround the sort filename. I really don't want to create 3 sql methods (get_list_by_col1,get_list_by_col2,get_list_by_col3). I'd appreciate any help. Thanks. Mike Guerrero

1 0

sort based on a variable
by Michael Guerrero 17 Mar '03

17 Mar '03

I have a table tab1 with 3 columns col1,co2,col3. I've defined a sql method 'get_list' as 'select col1,co2,col3 from tab1. In a dtml method (view_list)I want call get_list and sort on any of the three columns. I know I can do the following: <dtml-in get_list sort="col2"> display stuff here </dtml-in> I'm passing the sort order column to view_list using --> view_list?sort_order=col2 I get no error but incorrect results when I try to do the following in view_list: <dtml-call "REQUEST.set('t_sort_order',sort_order)"> <dtml-in sql_list_rma sort=t_sort_order> I also tried putting various combinations of single and double quotes around t_sort_order' without any luck. I can display t_sort_order, so I know it's getting the proper value. It just doesn't evaluate correctly. I think it has something with double-quotes needing to surround the sort filename. I really don't want to create 3 sql methods (get_list_by_col1,get_list_by_col2,get_list_by_col3). I'd appreciate any help. Thanks. Mike Guerrero

3 2

html2pdf question
by AM 17 Mar '03

17 Mar '03

I followed the instructions here : http://www.zope.org/Members/mjablonski/howtoPDF to set up on the fly html2pdf conversion. the question I have is that do I have to have filenames ending in .html for it to work. To view the error generated please see: http://nbs.neuro-bs.com/index_html/html2pdf on IE On nerscape it pops up a box that says that the file doesnt start with %pdf Any ideas as to what I should do about that?? TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

1 0

can zope handle jsp serlet or perl scipt?
by Jianping Zhu 17 Mar '03

17 Mar '03

Can zope handle jsp, servlet like apache+tomcat? can i hand perl cgi script? -------------------------------- Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 --------------------------------

3 2

html2pdf ques
by AM 17 Mar '03

17 Mar '03

I followed the instructions here : http://www.zope.org/Members/mjablonski/howtoPDF to set up on the fly html2pdf conversion. the question I have is that do I have to have filenames ending in .html for it to work. To view the error generated please see: http://nbs.neuro-bs.com/index_html/html2pdf TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

1 0

Make Zope 2.6.1 error log persistent
by AM 17 Mar '03

17 Mar '03

Is there any way that I can make the error log persistent across restarts. Oftentimes the most important information about what page caused it to hang or sleep is lost and one has to wade through the log files to track it. TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

2 1

about load_files.py
by Chen Fu 17 Mar '03

17 Mar '03

Hi! I try load_files.py to upload htmls on my hard disk. Try to explain easily, i upload to root http://localhost:8080/. But i get : ============================================== D:\zope\lib\python>python \zope\utilities\load_site.py -u admin:123 -D http:// localhost:8080 d:\temp\ Traceback (most recent call last): File "\zope\utilities\load_site.py", line 302, in ? if __name__=='__main__': main() File "\zope\utilities\load_site.py", line 102, in main for f in files: upload_file(object, f) File "\zope\utilities\load_site.py", line 112, in upload_file if os.path.isdir(f): return upload_dir(object, f) File "\zope\utilities\load_site.py", line 129, in upload_dir call(object.manage_addFolder, id=name) File "\zope\utilities\load_site.py", line 106, in call try: apply(f,args, kw) File "D:\zope\lib\python\ZPublisher\Client.py", line 155, in __call__ self.handleError(query, ec, em, headers, response) File "D:\zope\lib\python\ZPublisher\Client.py", line 170, in handleError raise t, RemoteException(t,v,f,l,self.url,query,ec,em,response) bci.NotFound: bobo exception (File: d:\zope\lib\python\OFS\ObjectManager.py Line : 58) 400 Bad Request for http://localhost:8080/manage_addFolder ============================================== Did i miss something? ===== Remote Scensing Satellite Ground Station Chinese Academy of Science _________________________________________________________ Do You Yahoo!? 美女们的秘密武器！ http://yahoo.eachnet.com/fu/co/rd.php?http://pages.eachnet.com/st/page/wome…

2 1

How to call a method on another object in DTML
by pieter claassen 17 Mar '03

17 Mar '03

Hello, I am trying to render the index_html method of another object in a new "wrapper" object. Normally you just do a <dtml-var object> and Zope will find the object. But what if the object is far away in another hierarchy and I want to render it (not call its index_html method on my object!) Thanks, Pieter -- ----------------------------- Pieter Claassen pieter(a)openauth.co.uk http://www.openauth.co.uk OpenAuth Tel: 01344 390530 DDI: 01344 390630/390631 Fax number: 01344 390700 Mobile: 0776 665 6924 Highview House Charles Square Bracknell Berkshire RG12 1DF TERMS AND CONDITIONS (i)The information contained in this email and attachments is only intended for the addressed recipient(s) and may not be distributed or viewed by any other party without the explicit consent of the sender. If you have received this message by accident, please contact Pieter Claassen (pieter(a)openauth.co.uk) and destroy any electronic or physical copies of the information contained in it, immediately. (ii)This email is not certified to be virus free and OpenAuth accepts no liability for losses arising from you receiving this email. (iii)Any digital signatures (if present) used to authenticate this email, only serves to allow you to verify the originating email address of the sender and should not be relied upon to prove identity or base financial transactions on, unless the Certificate Practice Statement that the signature references, explicitly states differently. (iv)This email may be subjected to further terms and conditions as published on the company website at http://www.openauth.co.uk. If you need to rely on the information contained in this email in any way, then you should read those terms and conditions to understand how much you can trust the information in this email. (v)OpenAuth retains the copyright on any relevant material that is included in this email.

3 2

How to read Folders...
by Sorin Marti 17 Mar '03

17 Mar '03

Hi all, First of all I think the subject isn't very significant. I don't know how to call the problem I got so maybe I didn't find anything on google or zope.org because of that... I am using LocalFS and point to a directory in my local Filesystem. Users are allowed to upload LaTeX document sources which are compiled and stored in this folder. In the Folder (where LocalFS points to, lets say its upload_folder) I've got different categories (for example upload_folder/technical_documents or upload_folder/howtos or anything else) The user specifies a category and his document is then stored as a subfolder of the specific category-folder (example upload_folder/howtos/userhowto) in this subfolder there is an index.html for the (compiled) TeX-document and a folder named 'pdf' for the pdf document. That's the situation. Now I want a dtml-document which shows the uploaded documents in a table for each category like: name,link-to-pdf,link-to-html How can I get these links? I tried around with objectValues but I didn't suceed. Have you any links to good howtos? Is objectValues the right way to do that? any advices, hints? Thanks for helping me. Sorin Marti

2 1