- Zope - Zope lists

RE: [Zope] Zope is not getting MySQL SELECT results ...
by Dave Woolston 24 Jan '01

24 Jan '01

Hello Gerald, >Hello Gerald, > >> >> Hi all. >> >>I have set up, in a clean Zope installation, a MySQL database adapter. My >>connection string is "test test test", indicating a user test with password >>test connection to the test database. >> >>The adapter indicates that it can connect to the database, and I can send >>queries to the database. CREATE TABLE, INSERT, UPDATE, and other queries >>work just fine through the "test" tab of the adapter management interface, >>but it does not seem to be able return any data through a SELECT query. >>This does not work in the "test" table nor in a SQL method. Using a query, >>such as "select * from test", it always replies with: >> >>-------------------------------------------- >>There was no data matching this My Query query. >> >>SQL used: >>select * from test >>-------------------------------------------- >> >> > >This may seem like a silly response, but have you tried the same select >statement from outside zope - say from the mysql client? perhaps your >select statement is truly returning an empty set. We use zope with >PostgreSQL and MySQL (and have been for a few years) and haven't had any >problems. > This is some good advice - Also, just based on your example - you could be connected to your database (test) correctly, but you need to have a table called test for the query to work - you didn't really state if you had a table called test. Below - I have a database called test that I can connect to - but no tables called test: mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | bigstuff | | groups | | shop | | t_chunks | | t_largeobj | | user_group_map | | users | +----------------+ 7 rows in set (0.00 sec) mysql> select * from test; ERROR 1146: Table 'test.test' doesn't exist As you can see - you would get the result you described if you did not have a table defined. HTH ================================= Dave Woolston davew(a)digicool.com Digital Creations www.digicool.com (716) 262-4715

2 1

download file from LocalFS
by Ulrich Wisser 24 Jan '01

24 Jan '01

Hello, my users are not allowed to access the whole LocalFS. Therefor I setup a proxy method to check their access rights. If they are allowed I would like to return the file. This is what I came up with: 1. Make the LocalFS accessible through PathHandler 2. The PathHandler DTML method checks the access rights 3. if a directory is accessed a listening is returned if a file is accessed the file is returned Now pleasse see my code: <h1>Path to handle <dtml-var path_to_handle></h1> <dtml-let user="AUTHENTICATED_USER.getUserName()"> <dtml-if "user in lfs.fileIds()"> <dtml-call "REQUEST.set('mylfs',lfs[user])"> <dtml-in path_to_handle> <dtml-call "REQUEST.set('mylfs',mylfs[_['sequence-item']])"> </dtml-in> <p>meta_type = <dtml-var "mylfs.meta_type"></p> <dtml-if "mylfs.meta_type != 'Local Directory'"> THE FILE SHOULD BE RETURNED HERE! <dtml-else> HERE COMES THE DIRECTORY INDEX. </dtml-if> <dtml-else> <dtml-raise type="No Access"> No access granted.<br> User: <dtml-var AUTHENTICATED_USER> </dtml-raise> </dtml-if> </dtml-let> When mylfs references a directory meta_type is 'Local Directory' but if mylfs references a file meta_type is 'File'. How can I let the user download the file? Ulrich -- Searchengine Know How - Webpromotion - Optimization - Internal Search World Wide Web Publisher, Ulrich Wisser, Odensvag 13, S-14571 Norsborg http://www.publisher.de Tel: +46-8-53460905 Fax: +46-8-534 609 06

2 1

Style guide?
by J B Bell 24 Jan '01

24 Jan '01

Having read the Python style guide (and having found it, if a bit confusing, at least not intolerably strict), I am now curious about what style people like to use in Zope. Are folders classes, or objects? In the examples in the Book, most of the folders are done in StudlyCaps, while the documents and methods are in mixedCase. Although, of course, index_html is under- score_separated. Aigh! Is there any consistent guide to this? I generally prefer good old underscores, having come from a Perl background. Looking on the web gives me the ZDP's style guide for their documentation, but not for Zope itself. Any guidance would be much appreciated. I hope I have not revived an old holy war. --JB

1 0

Re: Some help required but no sarcastic comments this time please
by Alan Capesius 24 Jan '01

24 Jan '01

I understand your comments about sarcasm, but realize that this community is riddled with Unix bigots and just ignore it. Just listen to those willing to help. If you don't have to use MySQL, try either SQL Server or MS Access (small databases). See my pages on Zope NT SQL at http://techsite.tech-world.com/zopetips.htm for NT specific info. I would also recommend NOT using Win9x for ANYTHING. I always use NT. Other than that, have you installed the Win32 python extensions? Not sure if these are required with mySQL as I haven't used it myself. Alan > <alankirk(a)genie.co.uk> wrote: > > > I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic = > > comments this time) > > Feel free to interpret every comment you don't like as "sarcastic", but it > will not save your business. > > > to this address) and the response has been pretty poor, i've even tried = > > to email people involved with the mysql database adaptors and got no = > > response. > > You use a commercial operating system: pay for a commercial support. > > > It is really important that i get this problem sorted now if possible as = > > my final year project for university depends on this 'bug' getting = > > fixed. > > If it is important, do not run it on MS-Windows. Otherwise, some people may think > you know nothing about software...

2 1

RE: [Zope] Is it possible to make a thumbnail from an added image ..?
by Farrell, Troy 24 Jan '01

24 Jan '01

You could use the Python Imaging Library with some external methods: http://www.pythonware.com/products/pil/index.htm <dtml-var typical_open_source_hint_hint_hint> Troy -----Original Message----- From: dale.w.lance(a)mail.sprint.com [mailto:dale.w.lance@mail.sprint.com] Sent: Wednesday, January 24, 2001 8:19 AM To: thomas(a)3dfestival.com; zope(a)zope.org Subject: RE: [Zope] Is it possible to make a thumbnail from an added image..? You could try: http://www.zope.org/Members/haqa/archive/ZPhotoAlbum http://www.zope.org/Members/Drew/Photo These seem to do something similar to what you are asking. If not well, <dtml-var typical_open_source_quote>. Dale -----Original Message----- From: thomas [mailto:thomas@3dfestival.com] Sent: Wednesday, January 24, 2001 4:28 AM To: zope Cc: thomas Subject: [Zope] Is it possible to make a thumbnail from an added image..? Just a quick Idea: Can somebody make a routine RESIZING an image...? It would be great if someone could make something like that... Just imagine it: You add an Image_with_thumb... Browse for the image, then it adds your image to the site AND it is being resized to, for instance, 16x16pixels, and you can use that thumb as an icon for the image...! Wouldn't that be great...? Sorry about this silly question... It will not happen again (I hope) = ) ( = Stoons = ) - Webmaster @ 3D festival (http://www.3dfestival.com) _______________________________________________ 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

Help - Python
by Paula Mangas 24 Jan '01

24 Jan '01

Hi, I'm a newbie and i would like to know how can i create a DTMLDocument from a Python method. Thanks, Paula Mangas

2 1

Is it possible to make a thumbnail from an added image..?
by 3dfestival - WebMaster 24 Jan '01

24 Jan '01

Just a quick Idea: Can somebody make a routine RESIZING an image...? It would be great if someone could make something like that... Just imagine it: You add an Image_with_thumb... Browse for the image, then it adds your image to the site AND it is being resized to, for instance, 16x16pixels, and you can use that thumb as an icon for the image...! Wouldn't that be great...? Sorry about this silly question... It will not happen again (I hope) = ) ( = Stoons = ) - Webmaster @ 3D festival (http://www.3dfestival.com)

2 1

Dowloading images from another site with external method?
by Etienne Labuschagne 24 Jan '01

24 Jan '01

Hi all I have an external Python method in Zope that accesses a map server through an ActiveX connector. This map server creates a map and gives me the URL where I can download the map eg. "http:\\www.mysite.com\images:8081\img1234545.png" I want to download this image with the method, put it in a folder on my Zope server's disk, do some image processing with PIL and then upload it into my Zope site. My problem is that I don't know how to download the image from the URL above! I can have zope display it from that address, but that won't work as the map server eventually deletes the rendered maps (also I want to edit it first) I cannot use ftplib as the map server does not handle ftp requests, only http. I don't know how to use the httplib (or whatever) to download that image to my disk. Any help? Thanks Etienne Tel: (012) 348 4586 Cel: 082 442 8981 Fax: (012) 361 8355

2 1

SQLSession not working
by Paul Zwarts 24 Jan '01

24 Jan '01

Hi all, I have a unix machine with PGSQL and Zope 2.2.1? and my app uses SQL session brilliantly. But I've created another test machine with Zope 2.2.5, Win2kPro and MySQL 3.3.23 (i think)... and SQL Session no longer works properly. Every time I call a page, a different Session is used and Im not maintaining any kind of session context... which basically destroys my whole navigation system... Beyond that, I can put stuff into MySQL using Zope, but nothing comes out... not even a simple SELECT * from TABLE does nothing... Can anyone make suggestions? Im using the ZMySQLDA product... 0.1.2 Cheers, Paz

1 0

Some help required but no sarcastic comments this time please
by alankirk 24 Jan '01

24 Jan '01

Hi there, i sent an email the other week regarding problems i've been experiencing with zope and MySQL. I've set up a database connection for zope and mysql and it sort of works. I can send queries to add data to my database ok but when i send a query to get data from my database i get one of 3 errors and my python server that zope runs from stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time) I've sent a few emails about this problem to various people (including to this address) and the response has been pretty poor, i've even tried to email people involved with the mysql database adaptors and got no response. It is really important that i get this problem sorted now if possible as my final year project for university depends on this 'bug' getting fixed. If you can give me help on this or point me in the direction of someone who can, i'd be grateful Cheers Alan

7 6