[Zope-DB] MySQL blob-field question

2008-04-08 Thread Robert Campbell
Hello, I'm new to the group and of course have a question. I'm trying our Zope 2.10.5-final. and have a new problem displaying images from a MySQL database.. Here is the code that works on my old 2.9.4 server. ZSQL Method: getImage select image, cType as filetype from images where

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so we don't specifically have a dba, but will talk with the person who set up the db.

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Charlie Clark
On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. Jamie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Jamie O'Keefe
Thanks for the suggestions, Charlie. Will try as you suggested. Jamie On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Andreas Jung
--On 6. April 2006 14:46:36 -0400 Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Huh...google will tell you that it runs even on Windows. -aj

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Charlie Clark
On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL was developed at the University of California, Berkeley and runs on a huge

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Andreas Jung
--On 6. April 2006 21:51:05 +0200 Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL was

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Chris Withers
Jamie O'Keefe wrote: try: result = context.updatePerson(**query_args) return text except Exception: This is insane code. If you want to get mailed errors, look at the MailingLogger product. The traceback error is: Exception Type Database Error Exception Value

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
Hi Chris On 4/5/06, Chris Withers [EMAIL PROTECTED] wrote: Jamie O'Keefe wrote: try: result = context.updatePerson(**query_args) return text except Exception: This is insane code. If you want to get mailed errors, look at the MailingLogger product. Did. What if you don't know

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
Hi Dieter, On 4/5/06, Dieter Maurer [EMAIL PROTECTED] wrote: Jamie O'Keefe wrote at 2006-4-5 01:32 -0400: I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt-python-db sql-db driver-db flow and work pretty well. Unfortunately,

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Jamie O'Keefe
What version of Zope/MySQL/mysqldb/ZMySQLDA are you using? Zope is 2.6.4 MySql is 3.22.32 ZMySQLDA 2.0.8 i don't know the version of mysqldb. I think this is 0.9. Jamie ___ Zope-DB mailing list Zope-DB@zope.org

[Zope-DB] mysql / zope db connection issue

2006-04-04 Thread Jamie O'Keefe
Hi, I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt-python-db sql-db driver-db flow and work pretty well. Unfortunately, if enough people use it, the number of open db connections grows until it hits a limit and the db stops

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
Ciao Dario, I want to use MySQL in my Zope Installation. But I'm not able to install software (I don't really understand what shall I use and what shall I do...) I'm using Zope: 2.8.1 MySQL 4.1 Windows XP You have to install MySQL for Python:

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: ...MSVCR71.dll not found (I receive a message in italian..) Thanks Dario I'm sorry, but I don't live in the Windows world... With a quick google-search I found: .NET Framework SDK Version 1.1:

[Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

2005-05-17 Thread Itziar Aldabe
transaction')* Can someone help us, please? Thanks! Itziar Message: 1 Date: Sun, 15 May 2005 16:30:38 -0400 From: Michael Schwartz [EMAIL PROTECTED] Subject: [Zope-DB] MySQL ZSQL Transactions or Commit in Zope? To: zope-db@zope.org Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=us

Re: [Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

2005-05-17 Thread Dieter Maurer
Michael Schwartz wrote at 2005-5-15 16:30 -0400: I am trying to find sample code for performing transactions in ZSQL with mysql 4.1. I'd like to do something like this: 1 - Insert record A into USER table 2 - Get auto_increment id for record A 3 - Insert record B into WIDGET table with