[Zope] Putting a <dtml-in> tag into a <dtml-in> tag

[Paul Zwarts]

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 )