[Zope] MYSQL Problem
I installed mySQL-3.23.32 mySQLdb 0.3.1 ZmySQLDA 2.0.4 on Win98 From the following SQL statmentI get the result 233L and not 233 as expected select count(PID)from product When I run this SQL Statment from another program I get the expected value 233. In my installation there are a lot of Z SQL Methods that should return an int value and when I use field description int in the databaseI always get this 'L' behind the expected result. A lot of things don´t work because of this. When I change to mediumint (database field description)I get the expected 233. How can I fix this. Thanks Jens
Re: [Zope] ISPs that host zope
Hi Keith, check out http://www.zope.org/Resources/ZSP Jens Grewen - Original Message - From: "Keith Alperin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 07, 2000 2:43 AM Subject: [Zope] ISPs that host zope Greetings. I am a complete zope newbie but am enthralled by the technology. I am about to begin working on a personal web project and would like to build it in/with zope. Can anyone recommend a good ISP that will: -host and support zope -give me access to an RDBMS (MySQL or any other system would more than suffice) -give me a reasonable amount of space (50MB) -not break my budget ($30.00 per month.) Does such an animal exist? Please let me know what your experiences are with zope-friendly ISPs regardless of whether they meet my aforementioned criteria. Thank you so much. Keith R. Alperin Sr. Web Developer Ignite Sports Media [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] PIL/Zope Problem
Hi ,
I use this external Methode to generate thumbs from an image an write both
in an mysql database.
May this helps you
from PIL.Imageimport BICUBIC, BILINEAR, NEAREST
from cStringIOimport StringIO
import _mysql
import MySQLdb
import PIL
def write(filename, pid):
db=MySQLdb.connect(db="shop",user="zope",passwd="")
c=db.cursor()
imgfile=open(filename,'rb')
sql_reset_img1="update PRODUCT set PIMAGE=NULL where PID="+ pid
sqlstr="update PRODUCT set PIMAGE='" +
_mysql.escape_string(imgfile.read()) +"' where PID="+ pid
# do reset...
c.execute(sql_reset_img1)
# do the "update" load...
c.execute(sqlstr)
imgfile.close()
im = PIL.Image.open(filename)
fmt = im.format
if fmt == 'PNG':
fmt = 'JPEG'
size = (int('75'),int('75'))
x, y = im.size
if x size[0]: y = y * size[0] / x; x = size[0]
if y size[1]: x = x * size[1] / y; y = size[1]
size = x, y
im.draft(None, size)
im = im.resize(size)
im.size = size
im.save('/home/zope/tempimage/temp.jpg', fmt)
tempfile=open('/home/zope/tempimage/temp.jpg','rb')
sql_reset_img2="update PRODUCT set PTHUMB=NULL where PID="+ pid
sqlstri="update PRODUCT set PTHUMB='" +
_mysql.escape_string(tempfile.read()) +"' where PID="+ pid
# do reset...
c.execute(sql_reset_img2)
# do the "update" load...
c.execute(sqlstri)
tempfile.close()
return 'image was written to db successfull'
Jens
- Original Message -
From: "Marcello Lupo" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 2:38 PM
Subject: [Zope] PIL/Zope Problem
Hi to all,
i read all the documentation and made all things to let interact PIL and
Zope and i cannot find the way to make it work.
If i try to import PIL from pyton interpreter it works perfectly with:
***
Python 1.5.2 (#1, Jul 17 1999, 22:10:16) [GCC egcs-2.91.66
19990314/Linux (egcs- on linux2
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
import PIL
data=PIL.Image.open("/home/httpd/listanozze/docs/images/prove/ccc.jpg","r")
print data.format
JPEG
print data.info
{'adobe_transform': 1, 'progression': 1, 'adobe': 100, 'jfif': 258}
print data.size
(450, 309)
**
as you can see it works.
But when i try to access PIL.Image.open from an external method in Zope
i get:
***
Error Type: AttributeError
Error Value: Image
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 /home/httpd/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line
214, in publish_module
File /home/httpd/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line
179, in publish
File /home/httpd/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202,
in zpublisher_exception_hook
(Object: ElementWithAttributes)
File /home/httpd/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line
165, in publish
File /home/httpd/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line
160, in mapply
(Object: pippo)
File /home/httpd/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line
102, in call_object
(Object: pippo)
File /home/httpd/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line
150, in __call__
(Object: pippo)
File
/home/httpd/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py,
line 502, in __call__
(Object: pippo)
File
/home/httpd/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, line
335, in eval
(Object: resize_image(foto))
(Info: foto)
File string, line 0, in ?
File
/home/httpd/Zope-2.1.6-src/lib/python/Products/ExternalMethod/ExternalMethod
.py,
line 255, in __call__
(Object: resize_image)
(Info: ((ZPublisher.HTTPRequest.FileUpload instance at 8565c90,),
{}, None))
File /home/httpd/Zope-2.1.6-src/Extensions/image_op.py, line 7, in
resize_image
(Object: ElementWithAttributes)
AttributeError: (see above)
*
My external Method say:
import PIL
def resize_image(self, foto):
if foto:
data=PIL.Image.open(foto)
data=data.resize((128, 128))
return data.size
else:
return "Nothing"
Re: [Zope] Z SQL Objects (Newbie)
Hi, Arguments| team Query template dtml-if "team == '5'" select * from data dtml-else select * from data/dtml-if this is normal but may it helps if you post the traceback of the error message Jens Grewen - Original Message - From: Yvonne Totty To: [EMAIL PROTECTED] Sent: Thursday, October 26, 2000 3:22 PM Subject: [Zope] Z SQL Objects (Newbie) I have the O'Reilly book, but can't seem to find more complete information on how to do 'if's' in a SQL thing. Here's the scenario: I have three different 'teams' and want to run a call specific to each team. I am passing in three parameters, two of which go in the sql statement, the other goes in the if statement: :if "team='S"' sql statement :elif "team='C'" blah, blah /:if It tells me it doesn't like the syntax of the 'if' (I have stuff in the python file that lets me use ':' in place of 'dtml-'). I have tried all the flavors: "team=='S'", "team=S", "team==S", etc. and it doesn't like any of them. If you guys know of another reference, please let me know! TIA, Yvonne 8) ~~~ Yvonne Totty Database Engineer - Wolverine: You actually go outside in these things?Cyclops: Well, what would you prefer? Yellow spandex?
Re: [Zope] dtml-if url type contruct
Hi,
I am not quite sure if this is what you want but may this helps
dtml-with bar
dtml-if "REQUEST.has_key('foo')"
do something
/dtml-if
/dtml-with
This is not resolving the URL.
If you found a solution let me know.
Jens Grewen
- Original Message -
From: "kosh" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 24, 2000 10:56 PM
Subject: [Zope] dtml-if url type contruct
What would be the correct dtml-if contrstruct for this behavior?
I want to check and see if zope can resolve a url to a valid object.
Ie does http://foo.com/bar/foo get you to a valid page or is it not
found.
I need something like dtml-if http://foo.com/bar/foo that way I can know
when to rewrite the url based on zope finding the object or not.
Thanks
Kosh
___
Zope maillist - [EMAIL PROTECTED]
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 )
___
Zope maillist - [EMAIL PROTECTED]
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 )
[Zope] Re: [Zope-dev] Problems with offline MS IE 5
I was fighting with the same problem and I thought it depends on my proxy setting. But now I thing it depends on the Browser version because I installed IE5.5 and the problem was gone. (ocularly same settings). - Original Message - From: "Ross Boylan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 20, 2000 8:09 AM Subject: [Zope-dev] Problems with offline MS IE 5 I recently tried doing some Zope development on a laptop and ran into a problem: when I updated a product the updates did not "take." In particular, when I edited the text in a .dtml file and restarted Zope, I still saw the old text when I got to the appropriate point (the file was wrapped in an HTMLFile() and used for creating a new instance of one of the products in the package). I think I checked all of the following: * the file was getting updated * all instances of explorer were shut down * MSIE options set to "Check for newer version of stored page on every visit to the page" A notable peculiarity was that whenever I tried to access my local zope, I would get a "you are offline, do you wish to go online" message (I even used localhost as the machine name!). I would say yes, it would say it couldn't connect and ask if I wanted to try again. I said yes, but then I ran into the problems described above. Zope 2.2.2 on MS W2K with MS IE 5.0. Does this ring any bells with anyone? Is it an IE problem? a Zope problem? an interaction? ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Problems with mysql and sql methode
Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICEfrom MERCHANTPAYMENT, PAYMENTwhere MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT - MPID int(30) MEID int(30) PYID int(30) - PAYMENT - PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) - the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen
Re: [Zope] Problems with mysql and sql methode
Ok know I get this problem Error, _mysql.OperationalError: (1109, "Unknown table 'MERCHANTPAYMENT' in where clause") SQL used: select PYNAME, PYPRICE from PAYMENT where MERCHANTPAYMENT.MEID = '418' and MERCHANTPAYMENT.PYID = PYID other ideas? Thanks Jens Grewen - Original Message - From: "Farrell, Troy" [EMAIL PROTECTED] To: "'Jens Grewen'" [EMAIL PROTECTED]; "Zope Maillist" [EMAIL PROTECTED] Sent: Friday, October 20, 2000 10:04 PM Subject: RE: [Zope] Problems with mysql and sql methode You may try: SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would. Troy -Original Message- From: Jens Grewen [mailto:[EMAIL PROTECTED]] Sent: Friday, October 20, 2000 11:04 AM To: Zope Maillist Subject: [Zope] Problems with mysql and sql methode Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT - MPID int(30) MEID int(30) PYID int(30) - PAYMENT - PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) - the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Problems with mysql and sql methode
Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICEfrom MERCHANTPAYMENT, PAYMENTwhere MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT - MPID int(30) MEID int(30) PYID int(30) - PAYMENT - PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) - the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen
