Sorry ... I forgot a query for the clips .. thats why I had trouble getting the serverid .. But now I have another problem. I get a KeyError on "server" ... my code looks like this: <TABLE BORDER="1" WIDTH="100%"> <TR> <TD> <dtml-in sqlGetShowClips> <dtml-in expr="sqlGetClipData(clipid=clipid)"> <dtml-with expr="sqlServeridNameQuery(serverid=serverid)"> <dtml-with expr="sqlFilenameQuery(basefile=basefileid)"> <LI><A HREF="http://<dtml-var server>/smil/<dtml-var showid>-<dtml-var clipid>" onClick="document.vid.DoPlay()"><dtml-var clipid></A> </dtml-with> </dtml-with> </dtml-in> </dtml-in> </TD> <TD> </TABLE> The <dtml-var server> is a column in the sqlServeridNameQuery .. but Zope obviously doesn't receive this column ? Any good answers? Gitte On 26 Apr 2001 13:16:45 +0200, Gitte Wange wrote:
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
_______________________________________________ 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 )