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
, October 16, 2000 2:48 AM
To: [EMAIL PROTECTED]
Subject: [Zope] MySQL and Zope struggles
I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL
(Why ? - because I've got a kind offer of free hosting if I use MySQL).
MySQL offers a limited set of features and is missing
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
I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL
(Why ? - because I've got a kind offer of free hosting if I use MySQL).
MySQL offers a limited set of features and is missing, among other things,
the ability to use subqueries - so for example in PostgreSQL you can
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
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 know if the following link