Though I replied already, I'll add this. Nested dtml-in's are one way of enforcing one-to-many relations. Also uses of foreign keys between two databases is helpfull. I use it very often in my zope apps. What you want can be done in one zsql method by using SELECT AS and SELECT INTO. But for componentization and ability for these tables to independantly change, it would be better to do it in two. See previous email from me. Paz -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Gitte Wange Sent: Thursday, April 05, 2001 2:32 PM To: Tim Hicks Cc: zope@zope.org Subject: Re: [Zope] Putting a <dtml-in> tag into a <dtml-in> tag On 05 Apr 2001 13:22:31 +0100, Tim Hicks wrote:
----- Original Message ----- From: "Gitte Wange" <gitte@mmmanager.org> To: <zope@zope.org> Sent: Thursday, April 05, 2001 1:08 PM Subject: [Zope] Putting a <dtml-in> tag into a <dtml-in> tag
Hmmm confusing subject :-)
What I need to do is this: Get some data out of my database (in a <dtml-in> tag) While iterating through this data, I need to get some more data out out my database (another <dtml-in> tag. I tried to call the second sql method with a <dtml-var> from the first sql method but I get an error.
So how do I collect some data from my database with a result from the first sql method ?
Wouldn't it be easier to put all the 'data collection' within one zsql method?
tim
Well I just thought of that :-) But actually I don't know how. Maybe someone here could help. I need to this this: First select all clips that belongs to a playlist from the playlist table (clips is identified by clipid's) Then select the specific clip-data from the clip table from the clipid Anyone ? -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************ _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )