- Zope - Zope lists

result
by D. Rick Anderson 12 Mar '03

12 Mar '03

What's the syntax for building a 'result' variable such as that that is returned by an SQL query? TIA Rick

2 1

CookieUserFolder: migration and IE6 problems
by Gidon Friedman 12 Mar '03

12 Mar '03

Hi My CookieUserFolder works fine with mozilla 1.2.1, but doesn't work in IE6. in IE6 it shows the password dialog on every page. The pages are showing after entering of the password. until on some funktion it show a http-authorization dialog and from that point it works. this is possibly related to the fact that the CookieUserFolder is sitting in a Subfolder and i have a stock-UserFolder in the root. This site worked fine on a 2.4.3 server for some time, and i do some upgrading work, that's why i have these CUF sitting around. I tried migrating to CookieCrumbler, but when i delete my CookieUserFolder it leaves some footprint in the objects, that breaks the object when CookieCrumbler ist deleted from the system. Anybody seen this before? anybody fixed the deletion problem with CookieUserFolder? I use Zope 2.6.1, python 2.1.3. CookieUserFolder 1.6, linux2 Regards Gidon

1 1

Re: File Upload problems
by Mark Evans 11 Mar '03

11 Mar '03

Actually, Maik had it right, it just took me awhile to get it to work. The key was that the FileUpload object can be treated as a file object. I was then able to do this: def main (image): dCon = dco.connect("foo/foo@myfoo") dCur = dCon.cursor() dCur.execute("insert into blobtest values ('2', EMPTY_BLOB())") dCur.execute("select * from blobtest where id='2' for update") r = dCur.fetchone() lob = r[1] lob.write(image.read()) dCon.commit() return str(image.filename) +" was loaded" This did what I wanted it to do. What I was missing was the lob.write(image.read()) syntax. That took me awhile. Thanks to Maik and Dieter for their help. Mark |---------+----------------------------> | | Dieter Maurer | | | <dieter@handshake| | | .de> | | | | | | 03/11/2003 02:22 | | | PM | | | | |---------+----------------------------> >---------------------------------------------------------------------------------------------------------------------------| | | | To: "Mark Evans" <mark.evans.b(a)bayer.com> | | cc: zope(a)zope.org | | Subject: Re: [Zope] File Upload problems | >---------------------------------------------------------------------------------------------------------------------------| Mark Evans wrote at 2003-3-10 11:51 -0800: > .... > I am trying to upload an image file from a form to an External Method .... > .... > The external method is called from a DTML method called "execute_loadblob" which > contains the call: > > <dtml-var expr="writeBlob(image)"> > > The external method is: > > import sys,os,string,DCOracle2 as dco > def main(image): > ... > do something here with image, doesn't matter what > ... > return "Something was done" > > ============================================================= > > The gist of the error received, is that image is a " > ZPublisher.HTTPRequest.FileUpload instance at 1046b04" > instead of being something I can acutally manipulate. Why is this and how do I > access either the file or the URL pointing to the file? This error message does not seem to fit to your description. Instead, it looks as if the uploaded image were returned as result of the web request. This should never happen (Web request results should be elementary data types). When ZPublisher is confronted with an (non-elementary) object as response to a request it raises an error. Dieter

1 0

sendmail tag is quoting html
by AM 11 Mar '03

11 Mar '03

Hi, I have the following snippet in my standard_error_message: <dtml-sendmail mailhost="mail_host"> To: aseem(a)somain.com From: zope(a)host.domain.com Subject: Zope Error: <dtml-var error_type> Error Type: <dtml-var error_type> <dtml-var error_tb> -zope </dtml-sendmail> The problem is that the error_tb is sent quoted like in the stuff below. Any ideas why?? Any workarounds?? TIA AM _________________ Error Type: NotFound Traceback: <p>Traceback (innermost last): <ul> <li> Module ZPublisher.Publish, line 89, in publish</li> <li> Module ZPublisher.BaseRequest, line 329, in traverse</li> <li> Module ZPublisher.HTTPResponse, line 636, in debugError</li> </ul>NotFound: <TABLE BORDER="0" WIDTH="100%"> <TR VALIGN="TOP"> <TD WIDTH="10%" ALIGN="CENTER"> &nbsp; </TD> <TD WIDTH="90%"> <H2>Site Error</H2> <P>An error was encountered while publishing this resource. </P> <P><STRONG>Debugging Notice</STRONG></P> Zope has encountered a problem publishing your object.<p> Cannot locate object at: http://nbs.neuro-bs.com/dadada <HR NOSHADE> <P>Troubleshooting Suggestions</P> <UL> <LI>The URL may be incorrect.</LI> <LI>The parameters passed to this resource may be incorrect.</LI> <LI>A resource that this resource relies on may be encountering an error.</LI> </UL> <P>For more detailed information about the error, please refer to the HTML source for this page. </P> <P>If the error persists please contact the site maintainer. Thank you for your patience. </P> </TD></TR> </TABLE> </p> - zope __________________ -- ================================================================== 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 ==================================================================

3 2

Creating a LocalContent object from a Python script
by Igor Leturia 11 Mar '03

11 Mar '03

Hi! I need to create a LocalContent object from within a Python script, and I don't know how to do it. I think the function to be called is manage_addLocalContent, and I try it as if I were adding a file (context.manage_addLocalContent(id, title, languages)) but it says the function does not exist. Any ideas? Igor Leturia

3 2

ZServer stops responding
by AM 11 Mar '03

11 Mar '03

Hi, I have a Apache 2.0 and a ZServer w/ VHM behind it. The Apache uses RewriteRules to serve the ZServer content. The problem is every so often, the zope server stops responding with a *Proxy Error * The proxy server received an invalid response from an upstream server. The proxy server could not handle the request /GET / </>/. Reason: *Error reading from remote server* Apache/2.0.43 Server at nbs.neuro-bs.com Port 80/ / and my zope debug log has: 2003-03-10T19:09:03 INFO(0) Z2 Caught signal SIGTERM ------ 2003-03-10T19:09:03 INFO(0) Z2 Closing all open ZODB databases ------ 2003-03-10T19:09:03 INFO(0) Z2 Shutting down ------ 2003-03-10T19:09:03 INFO(0) zdaemon Started subprocess: pid 3382 ------ 2003-03-10T19:09:05 INFO(0) ZODB Opening database for mounting: '139321088_1042459884.937236' ------ 2003-03-10T19:09:05 INFO(0) ZODB Mounted database '139321088_1042459884.937236' at /temp_folder ------ 2003-03-10T19:09:05 INFO(0) ZServer HTTP server started at Mon Mar 10 19:09:05 2003 Hostname: balder.neuro-bs.com Port: 8080 ------ 2003-03-10T19:50:19 INFO(0) ZODB conflict error at /VirtualHostBase/https/nbs.neuro-bs.com:443/nbs_online/VirtualHostRoot/secure/ssl_logo (1 conflicts since startup at 2003-03-10T19:09:05) The zope access log has the following: ----------------------------------------------------------------------------------------------------------------------- 192.168.10.172 - Anonymous [11/Mar/2003:07:42:54 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/ HTTP/1.1" 200 10740 "" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:42:54 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/layout/global_css HTTP/1.1" 304 312 "http://nbs.neuro-bs.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:42:54 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/presentation_pic HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:42:54 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:42:54 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:02 -0700] "POST /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/util/contact/send_message HTTP/1.1" 302 8450 "http://nbs.neuro-bs.com/util/contact/user?to_id=0&subject=[NBS Forums] Re: Timing: backward masking" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:03 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/errors/e500?url=http://nbs.neuro-bs.com/util/contact/send_message HTTP/1.1" 200 9056 "http://nbs.neuro-bs.com/util/contact/user?to_id=0&subject=[NBS Forums] Re: Timing: backward masking" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:04 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/errors/e500?url=http://nbs.neuro-bs.com/util/contac…" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:04 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/errors/e500?url=http://nbs.neuro-bs.com/util/contac…" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:07 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/presentation HTTP/1.1" 200 12006 "http://nbs.neuro-bs.com/util/contact/user?to_id=0&subject=[NBS Forums] Re: Timing: backward masking" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:08 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/presentation" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:08 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/presentation" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:22 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/chatter_box HTTP/1.1" 200 25583 "http://nbs.neuro-bs.com/presentation" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:22 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:22 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/thumbtack HTTP/1.1" 304 311 "http://nbs.neuro-bs.com/chatter_box" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:22 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/locked HTTP/1.1" 304 311 "http://nbs.neuro-bs.com/chatter_box" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:23 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:26 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/chatter_box/view_board?id=6 HTTP/1.1" 200 26942 "http://nbs.neuro-bs.com/chatter_box" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:27 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box/view_board?id=6" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:27 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/notification_off HTTP/1.1" 304 310 "http://nbs.neuro-bs.com/chatter_box/view_board?id=6" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:27 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/spindle HTTP/1.1" 304 311 "http://nbs.neuro-bs.com/chatter_box/view_board?id=6" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:27 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box/view_board?id=6" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/chatter_box/view_thread?id=488 HTTP/1.1" 200 29330 "http://nbs.neuro-bs.com/chatter_box/view_board?id=6" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/title_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/notification_off HTTP/1.1" 304 310 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/down_all HTTP/1.1" 304 310 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/thread_nav HTTP/1.1" 304 310 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/email HTTP/1.1" 304 311 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:31 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/down HTTP/1.1" 304 310 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" 192.168.10.172 - Anonymous [11/Mar/2003:07:43:32 -0700] "GET /VirtualHostBase/http/nbs.neuro-bs.com:80/nbs_online/VirtualHostRoot/images/footer_bg HTTP/1.1" 304 313 "http://nbs.neuro-bs.com/chatter_box/view_thread?id=488" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" ----------------------------------------------------------------------------------------------------------------------- The zope process seems to be still there, but only a restart fixes the problem. Any ideas as to what is going wrong?? Thanks. 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

zope benchmarks now available
by J Cameron Cooper 11 Mar '03

11 Mar '03

A little while back I promised to run some benchmarks. Took a little while longer than I thought, and there is a lot to be desired, but I have published the preliminary results. My results (unfortunately) don't agree with the qualitative results of http://www.zope.org/Members/BwanaZulia/zope_benchmarks/benchmarks.html I imagine the more thorough tests I have planned will reveal more. Anyway, if you like numbers (and who doesn't?) you can find my results at http://zopeedge.com/benchmarks It's a little earlier than I had planned to make the site publicly known, so be well warned that the only thing there that really works is the benchmark area. --jcc

1 0

Understand ZODB Query?
by Heri 11 Mar '03

11 Mar '03

Hi, I'm starting to develop a zope products and I'm still confused on how to use ZODB. My current application development is using RDBMS concept such as following samples: employee table: Row First Name Last Name Age === ========== ========= === 1 Bob McBob 42 2 John Johnson 24 3 Steve Smith 38 - I can easily perform SQL statement to lookup for some information such as, total employee, who are above 30 years old, and who has the Lastname of 'Smith'. - I can easily retrieve information from multiple tables and combine it as data objects. But how can I do this in ZODB? I was looking at http://www.zope.org/Documentation/Books/ZDG/current/index_html but it just tell me briefly how to store objects and simple retrieval. I need to do complex queries or perform some transaction. Can anyone help me the way to query data in ZODB? thanks, Heri

5 8

problem uploading pdf file via localfs
by Deniz, Metin 11 Mar '03

11 Mar '03

Hi everybody, I hope you are the right people to address my question. If not, please tell me who might help me with the following question: I am trying to upload a pdf file via a localfs object. Unfortunatelly I am getting a blank page to see within ms-ie. This is the code I am using: <dtml-var standard_html_header> <a href="pdffiles/deutschA.pdf" type="application/pdf"> upload </a><br> <dtml-var standard_html_footer> Thanks in advance, Metin Deniz

3 2

REQUEST.SESSION
by Leonardo Fernandes 11 Mar '03

11 Mar '03

Hello again, First: Is there a way to prevent access to files in the server (pdf files, for instance). I intend to use sessions (REQUEST.SESSION) to control that. Is it possible? If not, what's the better option in this case? AccessRules also don't seem to work. Second: I'd like to use Session (REQUEST.SESSION) data as a parameter to another method (a Zsql Method for example). How can I do that in dtml? <dtml-with SESSION mapping> doesn't work. I guess I should use getSessionDataByKey, but I didn't figure out exactaly how. Can anyone help me? Thank you very much.

4 4