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
What about one sql method:
select @noteid:=note_id from artist where dtml-sqltest artist_id type=int
dtml-var sql_delimiter
update note set notes =dtml-sqlvar notes type=string
where note_id = @noteid
-Original Message-
From: Richard Moon [mailto:[EMAIL PROTECTED]]
Sent: Monday,
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 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