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

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