Re: [Zope] MySQL-python-1.2.2 ImportError

2009-01-21 Thread Michael Backhaus
Well, I guess it was my bet ... solaris uses 'crle' for the ld configuration. I included the mysql-lib directory and it seems to work now. On Wed, 2009-01-21 at 06:20 +0530, Chetan Kumar wrote: > On Wed, Jan 21, 2009 at 3:19 AM, SolidEther wrote: > > ImportError: ld.so.1: python: fatal: libmysqlc

Re: [Zope] mysql and LOAD DATA INFILE

2008-10-15 Thread Andreas Jung
On 15.10.2008 13:16 Uhr, [EMAIL PROTECTED] wrote: hello everybody! this is a 50%zope and 50%mysql question..hope somebody here will help me..:-) in PC1: are running a mysql and zope+Plone server. A zsql method imports a csv file into mysql using a LOAD DATA LOCAL INFILE and all runs OK when the

Re: [Zope] MySQL reconnects on zope application level

2008-07-17 Thread Jonas Meurer
On 16/07/2008 Peter Bengtsson wrote: > I don't have an easy answer but if you do dig into Andy's code and try > to implement this, I would suggest you look at the ZPsycopgDA code > perhaps and look for inspiration since I think that one works much > better. Thanks, but finally I found an easier so

Re: [Zope] MySQL reconnects on zope application level

2008-07-16 Thread Peter Bengtsson
I don't have an easy answer but if you do dig into Andy's code and try to implement this, I would suggest you look at the ZPsycopgDA code perhaps and look for inspiration since I think that one works much better. 2008/7/16 Jonas <[EMAIL PROTECTED]>: > Hello, > > On several zope 2.10.6 instances w

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread Hugo Ramos
Hi Tino, Is "I've never used Postgres before and all my web life experience is MySQL based" reason enough? :-) Thanks Hugo On Thu, Feb 21, 2008 at 3:31 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Hugo Ramos wrote: > > Well, > > > > I went googling for this error... Google gives 1 (one)

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread Tino Wildenhain
Hugo Ramos wrote: Well, I went googling for this error... Google gives 1 (one) answer!!! The worst part is that it's related to django and mod_python. I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger). You could also forward to Postgres :-) Unless you have a very spe

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread David Pratt
Hi Hugo. Yes, that's true but of course you have to consider all of the other frameworks that apple has already put on your machine. Much of the problem will come when linking the libraries when compiling. So in fact it is a bigger issue and requires much of the base software to recompiled usin

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread Hugo Ramos
Hello David, It makes sense to me! The only thing I was using as a binary was Python 2.4.4 universal binary. I guess if I was using Python from the source it should work then. Thank you very much. Hugo On Thu, Feb 21, 2008 at 3:01 AM, David Pratt <[EMAIL PROTECTED]> wrote: > Hi Hugo. I believe

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread David Pratt
Hi Hugo. I believe 'file is not of required architecture' may be the clue here. Ever since mac went to universal binaries, folks with ppc have been having trouble since it is compiled with i386 arch flags and vice versa for folks with intel macs (with ppc arch flags). The only way to get around

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Man... I should buy you a drink at Lisbon when you decide to come here!!! :-) The binary package works fine now! I just wish someone would answer about the compilation warning and import error in Zope. Thank you very much Really appreciated Hugo On Wed, Feb 20, 2008 at 8:47 PM, Giampiero Ben

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Forget it... Just found the file at: http://pythonmac.org/packages/py24-fat/index.html Thanks a lot! Hugo On Feb 20, 2008 5:57 PM, Hugo Ramos <[EMAIL PROTECTED]> wrote: > Where did you get that file? MySQL-Python at sourceforge? > > > Thanks > > > On Feb 20, 2008 5:28 PM, Giampiero Benvenuti >

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Where did you get that file? MySQL-Python at sourceforge? Thanks On Feb 20, 2008 5:28 PM, Giampiero Benvenuti <[EMAIL PROTECTED]> wrote: > I used MySQL_Python-1.2.1_p2-py2.4-macosx10.4.zip with 10.5 and It works > just fine. > > Giampiero > > > > On Feb 20, 2008, at 8:52 AM, Hugo Ramos wrote: >

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Well, I went googling for this error... Google gives 1 (one) answer!!! The worst part is that it's related to django and mod_python. I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger). omg... Thanks Hugo On Feb 20, 2008 12:31 PM, Hugo Ramos <[EMAIL PROTECTED]> wrote:

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Hello Chetan, Well thank you very much! I must be very tired to forget to compile MySQL without --enable-thread-safe-client !!! It seems that MySQL-python now compiles with a warning: ld: warning in /usr/local/mysql/lib/mysql/libmysqlclient_r.dylib, file is not of required architecture But when

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Hey Kumar, I like to think that the amount of time I could make anyone here spend looking for something is VERY well spent. That link you sent me is just 1 of the about 50 I searched on google before posting the problem. :-) I can tell you now that cp, mv and ln are not the solution. I can also t

Re: [Zope] MySql connector error

2007-08-27 Thread Kevin
Your right, the older mysql da I was using gave 'Shouldn't Load State When Connection is Closed'. It turns out that my DA is implemented correctly, but the database cursor is being persisted in another object(past transaction commit) as you noted. So, with some readjusting, the error seems reso

Re: [Zope] MySql connector error

2007-08-27 Thread Pelletier Vincent
Le Samedi 25 Août 2007 17:07, Kevin a écrit : > Intermittently, I recieve an error *Shouldn't load state for 0xf5f137 > when the connection is closed > * This means there is somewhere a reference to a persistent object which keeps it past transaction commit, which is a bad behaviour. > I impleme

Re: [Zope] Mysql Lock Unlock with zsql

2007-05-04 Thread Andreas Jung
--On 4. Mai 2007 17:34:23 +0200 [EMAIL PROTECTED] wrote: Hi, I must use mysql lock/unlock with zsql. I haven't found anything about it. There is any solutions? I must lock a table but i don't know how do it :( Since LOCK is a SQL statement you can *of course* integrate with ZSQL method

Re: [Zope] mysql socket problem, MOSX 10.4.7

2006-08-09 Thread Dieter Maurer
baiewola wrote at 2006-8-9 05:16 -0700: > ... >We can connect with PHP apps, Filemaker Pro, and MySQL client. However, >all Z MySQL database connections are broken. Here is the error: >OperationalError: (2002, "Can't connect to local MySQL server through >socket '/tmp/mysql.sock' (2)") > >After goo

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Paul Winkler
On Tue, Aug 01, 2006 at 02:50:19PM -0400, Muk Yan wrote: > Dear Coveted Braintrust, > > I was wondering if anyone had any experience with MySQL queries in Python in > Zope: People have already answered your main question, but: > SELECT name > FROM person > WHERE ID = Never ever pass raw user i

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Dennis Allison
Usually you install the database adaptor ZMySQLDB and make queries through a ZSQL Method object. On Tue, 1 Aug 2006, Muk Yan wrote: > Dear Coveted Braintrust, > > I was wondering if anyone had any experience with MySQL queries in Python in > Zope: > > import MySQLdb > import string > > reque

Re: [Zope] MySQL queries in Python

2006-08-01 Thread John Barham
import MySQLdb This is probably redundant. import string request = container.REQUEST session = request.SESSION result = (context.aq_parent).selects.select_from_table() print result Assuming you want the person's name printed, change this line to: print result[0].name Think of the resul

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Andreas Jung
--On 1. August 2006 14:50:19 -0400 Muk Yan <[EMAIL PROTECTED]> wrote: I know the MySQL query works, but I get garbage results from the python script (). All I want is to contain the results of the SQL query in a list or container. Zope Book 2.7 edition -> RDBMS chapter. The result object i

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Jonathan
Have a look at this:   http://www.zope.org/Members/spinwing/ZSQL_Results       Jonathan - Original Message - From: Muk Yan To: zope@zope.org Sent: Tuesday, August 01, 2006 2:50 PM Subject: [Zope] MySQL queries in Python Dear Coveted Braintrust,I was wondering if

Re: [Zope] MySql 5.0, ZMySQLDA and stored procedures

2006-01-17 Thread Dieter Maurer
Cameron Beattie wrote at 2006-1-17 17:37 +1300: >I was getting the following error when attempting to call a stored procedure >via a Z SQL Method: >_mysql_exceptions.OperationalError: (1312, etc You consult your MySQL documentation to find out what the error code "1312" means... -- Dieter _

Re: [Zope] MySql 5.0, ZMySQLDA and stored procedures

2006-01-17 Thread Greg Fischer
Yeah, I put up a patch on the MySQLDb Sourceforge page a long time ago for that.  Doing almost the same thing. Only I made it so you specify the client flag in the Zope connection object.  Doesnt do any good for windows though, they still have a problem with the mysql lib. (I think I posted a bug o

Re: [Zope] MySql problems

2005-12-01 Thread Tino Wildenhain
Am Donnerstag, den 01.12.2005, 15:45 -0800 schrieb Dennis Allison: > I have not yet completed differential diagnosis, but I was hoping someone > had encountered a similar problem and could pass along a fix/workaround. > > The following program fails to do the writes -- > > import MySQLdb > init

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Greg Fischer
I guess it's not a matter of should, but rather a preference.  I am running it just fine on Linux.  Had to do some tweeks to the ZMySQLDA, but it works great.  Stored Procedures and everything.  I just havent seen hardly anyone testing it, so I thought I would ask around and see if others are runni

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Tino Wildenhain
Greg Fischer schrieb: This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now. why should one? :) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Chris Withers
Richard Smith wrote: A very quick test shows the basics work just fine (adding a record to a table and displaying the whole table). Just watch authentication - they've changed the password algorithms again as in the 3/4 upgrade. The work around is in the manual. rats, probably only an issue

Re: [Zope] Mysql 5? Just curious.

2005-10-05 Thread Chris Withers
Greg Fischer wrote: This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now. That would be some achievement! ISn't MySQL written in C++ or something? Seriously though, Andy Dustman is your man, maybe try compiling mySQLdb and seeing if it'll

Re: [Zope] mysql-python build error

2005-09-13 Thread Sophia Grimm
It turned out there were two different problems at work here. First, I had to hard code the paths of my include_dirs and include_lib. Second, I didn't realize my bash shell wasn't taking the export command. I had to edit my bash profile to set the mysqlclient environment variable (which is the pa

Re: [Zope] MySQL timestamp issue

2005-06-06 Thread Hugo Ramos
Yellow Andy, In fact what you've said works! That line was missing on db.py and after I inserted it there everything works the right way. I guess this thread is now over. Thanks!!! Cheers Hugo On 6/3/05, Andy Dustman <[EMAIL PROTECTED]> wrote: > On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrot

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote: > Yellow, > > I wrote the wrong version. > I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3 Take a look at ZMySQLDA/db.py: http://cvs.sourceforge.net/viewcvs.py/mysql-python/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py?rev=

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Hugo Ramos
Yellow, I wrote the wrong version. I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3 This is the DTML code generating the error: docdataemissao is a timestamp field in a table like: 200406011023 The traceback: Error Type: ValueError Error Value: unsupported format chara

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote: > I already know what exactly makes Zope hang! > The problem is located at times.py that was installed by MySQL-Python > 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip) This is a package for Python-2.4. Are you using Python-2.4 with Zope-2.7? If you

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Hugo Ramos
I already know what exactly makes Zope hang! The problem is located at times.py that was installed by MySQL-Python 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip) ==OLD== def mysql_timestamp_converter(s): """Convert a MySQL TIMESTAMP to a Timestamp object.""" s = s +

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Chris Withers
Hugo Ramos wrote: Could anyone explain me why this works in Zope 2.7.0 final and doesn't work in Zope 2.7.6 final and/or 2.8.0b1 ?? If Zope is really hanging, look at DeadlockDebugger and find out where it's hanging... Chris -- Simplistix - Content Management, Zope & Python Consulting

Re: [Zope] MYSQL Problem

2001-01-29 Thread Andy Dustman
On Sun, 28 Jan 2001, Jens Grewen wrote: > I installed > > mySQL-3.23.32 > mySQLdb 0.3.1 > ZmySQLDA 2.0.4 > > When I change to mediumint (database field description) I get the > expected 233. > > How can I fix this. You just did. :) If a mediumint is big enough for you, use that. As Ron point

RE: [Zope] MYSQL Problem

2001-01-27 Thread Ron Bickers
The trailing L identifies a long int in Python. As of ZMySQLDA 2.0.4, MySQL integers use Python longs because an unsigned MySQL integer could overflow a Python int. So, it's a bug fix. A couple solutions (found at http://dustman.net/andy/python/ZMySQLDA/2.0.4) are to use or something similar t

Re: [Zope] MySQL

2001-01-26 Thread Andy Dustman
On Fri, 26 Jan 2001, Piotr Kozbial wrote: > I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were > broken.Thus I have installed latest > ZMySQLDA-2.0.4 and MySQLdb 0.3.1. MySQL-3.23.32 would be a good idea. It has at least one security fix, and a lot of bug fixes. > Ufter upg

Re: [Zope] MySQL connection string.

2001-01-21 Thread Joachim Werner
Indra Gunawan wrote: > Hello, > could anyone tell me how to make connection string to MySQL in Linux? > I use Zope 2.3 and I've tried the > > database@[host] username password This should work. Your problem is probably somewhere else. Are you sure that the database adapter, database etc. are

Re: [Zope] mysql connection string

2001-01-15 Thread Oleg Broytmann
On Mon, 15 Jan 2001, Olaf Zanger wrote: > right now my setup uses a connection string "db root" which doesn't seam > to give a lot of savety :-). > at my provider i have a login, but sure no root access to the db. > * how does the connection string look for user name "peter-hauser" and > password

Re: [Zope] MySQL

2001-01-11 Thread Petter Enholm
e the quality of the available documentation. Best regards Petter Enholm Also: - Original Message - From: "Eric Walstad" <[EMAIL PROTECTED]> To: "vishnu prasad" <> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2

RE: [Zope] MySQL

2001-01-11 Thread Eric Walstad
http://www.zope.org/Members/alanpog/zmysqlda_steps Should get you started... Eric. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of vishnu prasad Sent: Tuesday, January 09, 2001 3:17 PM To: [EMAIL PROTECTED] Subject: [Zope] MySQL can anyone update me with

RE: [Zope] MySQL connection woes

2001-01-09 Thread paul_s_johnson
One other bizarre symptom: when I test the database connection with a INSERT query it works and inserts data into the designated MySQL table in the query, although there is no indication that it is working in Zope. I changed the user table for the MySQL user cited in the connection string so th

RE: [Zope] MySQL connection woes

2001-01-09 Thread paul_s_johnson

Re: [Zope] MySQL connection woes

2001-01-09 Thread Luciano Ramalho
I don't know how to create a null login in MySQL, but I know a better solution. The last time I had a problem like yours I created a user in MySQL and used it connect Zope. In mysql you type: GRANT ALL ON my_database.* TO my_user IDENTIFIED BY my_passwd (The .* part is a wildcard meaning all ta

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Lloyd Kvam
I came across links that recommended recompiling both MySQL and the MySQL DA. I did so without too much difficuly. The batch compile scripts did not work, but compiling through the MicroSoft IDE did work. The source code I pulled down required the Microsoft compiler, not gcc++. I still have th

RE: [Zope] mySQL DA on Win32

2000-12-14 Thread sean . upton
Couldn't one just use MyODBC and the ODBC DA? What disadvantages (besides latency from yet another API to go through) are there to this approach? Sean ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross po

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Jim Washington
Hi, Lee I got zope and mysql working together last night on win2k. I used the instructions in http://www.zope.org/Members/philh/mysql (Thanks, Phil Harris!) I did have to use the custom dll and pyd mentioned there. http://www.google.com/search?q=mysql+zope+win32 might have more clues if this

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Petter Enholm
> From: "Lee Reilly CS1997" <[EMAIL PROTECTED]> > > I have seen the mySQL DA on Zope.org but I understand that it "does not > support win32 platforms at this time". I need database access ASAP so > can anyone offer any advice? There is a HOW-TO for this: How-To: ZMySQLDA on Win32 Search for it

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Phil Harris
Lee, Have you read the MySQL on Win32 howto? btw, give my regards to Duncan. Phil [EMAIL PROTECTED] - Original Message - From: "Lee Reilly CS1997" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 14, 2000 2:46 PM Subject: [Zope] mySQL DA on Win32 > Hi, > > Zop

Re: [Zope] mysql & zope

2000-11-30 Thread Dieter Maurer
Alexander DePauli writes: > ... using Zope management interface with custom objects ... The form actions of the Zope management interface are not built in. They are methods of the managed objects. This implies, if your objects override these management method, you get different behaviour. I

RE: [Zope] MySQL

2000-11-30 Thread Eric Walstad
http://www.zope.org/Members/alanpog/zmysqlda_steps -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K H Subrahmanyan Sent: Thursday, November 30, 2000 4:08 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [Zope] MySQL hi, I want to add MySQL to

Re: [Zope] mysql & zope

2000-11-30 Thread Steve Spicklemire
Hi Ruediger, You might consider ZPatterns. It allows you to develop applications with ZODB, and then, later, 'easily' switch to other forms of attribute storage for your objects. -steve > "Alexander" == Alexander DePauli <[EMAIL PROTECTED]> writes: Alexander> Hi Zopistas! Al

Re: [Zope] MySQL

2000-11-30 Thread Chris Withers
K H Subrahmanyan wrote: > > hi, >I want to add MySQL to my ZOPE. > > Please help me in installing it. > > Please give the links, necessary information. How about actually doing some work for yourself for a change rather than expecting everyone else to do it for you? Chris ___

RE: [Zope] MySQL Connection String

2000-11-17 Thread Eric Walstad
I use the following format: users@frankenstein privileged_user ThePassWord - or in general terms - TableName[@HostNameOfMachineMySQLIsRunningOn] MySQLUserName ThePassWord I guess the "@HostNameOfMachineMySQLIsRunningOn" part is optional, but I needed to put it in there for my setup. The "privile

Re: [Zope] MySQL Connection String

2000-11-17 Thread Tony McDonald
On 17/11/00 4:36 pm, "Aitor Grajal Crespo" <[EMAIL PROTECTED]> wrote: > I have installed ZMySQLDA 1.1.4, > anybody knows the format of the database connection string??? > > I have put database user passw , and doesn't work > > Thanks > > database@host user passwd 'host' can be 'localhost' f

RE: [Zope] MySQL and Zope struggles

2000-10-18 Thread Baker, Dennis [sjmr]
What about one sql method: select @noteid:=note_id from artist where update note set notes = where note_id = @noteid -Original Message- From: Richard Moon [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 2:48 AM To: [EMAIL PROTECTED] Subject: [Zope] MySQL and Zope stru

Re: [Zope] MySQL and Zope struggles

2000-10-18 Thread Richard Moon
Thanks Monty, I did try the temporary table route - problem is that Zope keeps the connection open so the temporary table stays there. Of course you can explicitly drop the temporary table after you've used it. However if the update fails for any reason the temporary table will still exist so

Re: [Zope] MySQL and Zope struggles

2000-10-17 Thread Monty Taylor
You can do it with temporary tables. Like this- create temporary table foo ( note_id int, notes varchar ); insert into foo select Note.note_id, Note.notes from Note, Artist where Note.note_id=Artist.note_id and Artist.artist_id=23; update foo set notes="asdlfna"; replace into Note select n

RE: [Zope] MySQL and Zope struggles

2000-10-16 Thread Richard Moon
Nice idea. Trouble is the note table is used to hold notes for many different reasons, so it looks like this - --- | Artist| | Recording | | Label | etc. --- | artist_id | |recording_id| |label_id| | note_id

RE: [Zope] MySQL and Zope struggles

2000-10-16 Thread dale . w . lance
is another way around this. It probably doesn't solve real complex scenarios either. JAT Dale -Original Message- From: administrator [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 6:11 AM To: zope Cc: administrator Subject: Re: [Zope] MySQL and Zope struggles I don't k

Re: [Zope] MySQL and Zope struggles

2000-10-16 Thread administrator
I don't know if the following link can solve your problem, but maybe it gives you an idea: http://www.zope.org/Members/Roug/new_record_with_subrecords (How-To: Creating a new record with subrecords in MySQL) Arno > I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL > (W

Re: [Zope] mySQL - Z SQL - dtml-var

2000-07-17 Thread Dieter Maurer
Gijs Reulen writes: > INSERT INTO test1 > ( id, content, phone ) > VALUES ( > , > , > > ) > > According to the doc I should be able to use dtml-var statements in Z SQL > Methods. However, this returns an error: Error, exceptions.KeyError: 12.12 This is indeed a strange variable name (1

Re: [Zope] MySQL LIKE operator

2000-07-13 Thread Phill Hugo
> > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 12, 2000 11:03 AM > > To: [EMAIL PROTECTED] > > Subject: [Zope] MySQL LIKE operator > > > > > > Hello, > > > > I'm writing a search query to a MySQL database. I want to keep > > peo

RE: [Zope] MySQL LIKE operator

2000-07-12 Thread Ron Bickers
You should be able to use something like this (untested): That way you get the SQL quoting without the surrounding quotes. ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesda

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-04 Thread Monty Taylor
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/4/00, 12:47:07 AM, Andy Dustman <[EMAIL PROTECTED]> wrote regarding Re: [Zope] MySQL transaction support (was: MySQL S

Re: [Zope] MySQL Select Statements

2000-07-03 Thread Andy Dustman
On Sat, 1 Jul 2000, Dieter Maurer wrote: > I recently found out that Oracle returns column names > converted into all uppercase. I needed about 2 hours > to analyse this weird behaviour. That's actually not too weird. Solid does the same thing. It is a standard "feature" of SQL-89 that column na

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
On Tue, 4 Jul 2000, Hannu Krosing wrote: > AFAIK the transaction support is enabled on table-by-table basis, so > there > is no way to know for sure if transactions are > supported/partially-supported/unsupported for a particular set of > queries True enough. There are several problems here:

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Hannu Krosing
Andy Dustman wrote: > > There are two factors which determine whether or not transactions can be > supported. Actually, there's only one, but it can't be directly tested > for: > > 1) If the server version (easily obtained upon establishing the > connection) is < 3.23.15, transactions are defini

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
On Mon, 3 Jul 2000, Monty Taylor wrote: > Why not have one ZmySQLDA that attempts to determine whether it is > transactional or not when the connect method is executed. That way you > could have a DA connect to your 3.22 database, upgrade your database to > >3.23.15 and not see any problems. A

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Monty Taylor
Why not have one ZmySQLDA that attempts to determine whether it is transactional or not when the connect method is executed. That way you could have a DA connect to your 3.22 database, upgrade your database to >3.23.15 and not see any problems. A combination of try-except:ing an attempted "beg

Re: [Zope] MySQL Select Statements

2000-06-30 Thread Dieter Maurer
Michael Blewett writes: > Select Column1, Column2 etc > from TableA. > > Instead I must use the AS statement ie > > Select Column1 AS Column1, Column2 AS Column2 > from TableA. Zope should not be responsible for this strange behaviour. It simply executes the SQL statement and asks the re

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Ron Bickers
> -Original Message- > From: Andy Dustman [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 30, 2000 4:08 PM > To: Ron Bickers > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [Zope] MySQL transaction support (was: MySQL Select > Statements) > with B

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Andy Dustman
On Fri, 30 Jun 2000, Ron Bickers wrote: > > That's the problem: They don't get control over when BEGIN/COMMIT/ROLLBACK > > are used. Zope does that if you are using the Transaction Manager. And the > > only way to control use of the Transaction Manager is by > > selection of DA. > > > > That's wh

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Ron Bickers
> -Original Message- > From: Andy Dustman [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 30, 2000 1:25 PM > To: Ron Bickers > Cc: Michael Blewett; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [Zope] MySQL Select Statements > That's the problem: They d

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Andy Dustman
On Fri, 30 Jun 2000, Ron Bickers wrote: > It should be as simple as the application designer actually knowing what > they're doing by knowing whether or not they're working with a table that > supports transactions or not, and just not using BEGIN/COMMIT/ROLLBACK when > they're not. Or is it too

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Ron Bickers
> -Original Message- > From: Andy Dustman [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 30, 2000 11:42 AM > To: Michael Blewett > Cc: Ron Bickers; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [Zope] MySQL Select Statements > > It's a matter of pers

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Andy Dustman
I should point out that 0.2.2 has not been fully released yet. There's a bug I have to iron out of it first. Probably next week. Also, for general MySQLdb questions, send them to [EMAIL PROTECTED] (mailing list). Or subscribe, it's low-volume and won't fatten your mailbox. On Fri, 30 Jun 2000, Mi

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers
> If I don't specify my Selects using "AS", I then get the following error > message: > > Error Type: KeyError > Error Value: SubjectName Traceback (innermost last): File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1

Re: [Zope] MySQL Select Statements

2000-06-29 Thread Michael Blewett
At 14:08 30/06/2000 +1000, Curtis Maloney wrote: > > Is this just an oddity with the MySQLDA/Db adapters or am I overlooking > > something blatantly obvious here? All the examples on zope.org don't have > > the extra "AS Column1" additions on them and I was wondering if this is a > > Zope/mySQL-u

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Michael Blewett
Hi Ron, If I don't specify my Selects using "AS", I then get the following error message: Error Type: KeyError Error Value: SubjectName Traceback (innermost last): File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers
Why do you say you "must" use the AS statement? Do you get an error otherwise? MySQLdb 0.2.2 is broken when used with ZMySQLDA. But 0.2.1 works okay for me. Andy Dustman (author of the MySQLdb) said he will fix it and hinted that one should use the ZMySQLDA that is on Zope.org (v1.2.0 now I be

Re: [Zope] MySQL Select Statements

2000-06-29 Thread Curtis Maloney
On Fri, 30 Jun 2000, Michael Blewett wrote: > Hi Everyone, > Just need someone to put me straight here. When I use Select statements in > an SQL Method I cannot simply : > > Select Column1, Column2 etc > from TableA. > Depending on the column names, yes you can. I just tested it not, and it wor