[Zope] Using result from a sql query in another query

[Gitte Wange]

Hello,

I am having some problems on doing subject ... maybe I havent't
understood the <dtml-in> and <dtml-with> tags properly but ...
I need to do the following.

First I need to find all specific clips belonging to a show. I do it
like this:
<dtml-in sqlGetShowClips>

It returns a lot of records. Now for each record I need to find a
servername in a server table and a filename in a filename table. The
sqlGetShowClips returns some columns named serverid and fileid.

I tried to do this:
<dtml-with sqlGetServerName>
<dtml-with sqlGetFilename>

But it doesn't find anything.

Is there a good explanation of how I "nest" these calls ???
I need the values to generate a URL

Gitte