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-18 Thread Baker, Dennis [sjmr]
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,

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

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

RE: [Zope] MySQL and Zope struggles

2000-10-16 Thread dale . w . lance
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