<% DIM peopleID, mediaID, subMedia, showMediaTags, medium, t if request("peopleID") = "" Then peopleID = 0 else peopleID = request("peopleID") end if if request("mediaID") = "" Then mediaID = 0 else mediaID = request("mediaID") end if if request("subMedia") = "" Then subMedia = 0 else subMedia = request("subMedia") end if ' ### STRINGS VERVANGEN Function ReplaceSTR(str) returnStr = Replace(str, "'","''") ReplaceSTR = returnStr End Function ' ### ALLE MEDIA VAN EEN PERSOON TONEN Function getPersonMedia(nr) on error resume next Set RS = Server.CreateObject("ADODB.Recordset") RS.Open "Select * From TB_MEDIA WHERE peopleID = " & nr & " And LEN(mediaTitle) > 1 ORDER BY mediaTitle", objConn, 1, 3 If Not RS.EOF Then Do While Not RS.EOF deTags = showMediaTagsFunction(RS("ID")) mList = mList & "" & RS("mediaTitle") & "" & getMediaMainCat(RS("mediaMainCat")) & "" & getMediaType(RS("mediaType")) & "" & RS("mediaPubDay") & "-" & RS("mediaPubMonth") & "-" & RS("mediaPubYear") & "" & RS("mediaEndDay") & "-" & RS("mediaEndMonth") & "-" & RS("mediaEndYear") & "" & RS("inMyPossession") & "" & vbCrLf mList = mList & "" & deTags & "" & vbCrLf ' mList = mList & getMediaLink(RS("ID")) RS.MoveNext Loop End If Set RS = Nothing response.write err.description getPersonMedia = mList End Function ' ### ALLE SUB MEDIA VAN EEN MEDIA CONTAINER Function getSubMedia(nr) on error resume next Set RS = Server.CreateObject("ADODB.Recordset") RS.Open "Select * From TB_MEDIA WHERE mediaID = " & nr & " ORDER BY mediaTitle", objConn, 1, 3 If Not RS.EOF Then Do While Not RS.EOF ' deTags = showMediaTagsFunction(RS("ID")) mList = mList & "" & RS("mediaTitle") & "" & getMediaMainCat(RS("mediaMainCat")) & "" & getMediaType(RS("mediaType")) & "" & RS("mediaPubDay") & "-" & RS("mediaPubMonth") & "-" & RS("mediaPubYear") & "" & RS("mediaEndDay") & "-" & RS("mediaEndMonth") & "-" & RS("mediaEndYear") & "" & RS("inMyPossession") & "" & vbCrLf ' mList = mList & "" & deTags & "" & vbCrLf ' mList = mList & getMediaLink(RS("ID")) RS.MoveNext Loop End If Set RS = Nothing response.write err.description getSubMedia = mList End Function %> ALEXANDRINA
<% If subMedia = 0 Then %> <% Else %> <% End If %>
 Home / <%= getPersonName(peopleID) %> / [Media List]
 Home / <%= getPersonName(peopleID) %> / <%= getMediaTitle(subMedia) %> [Media List]
<% If mediaID = 0 Then %> <%= getPersonMedia(peopleID) %> <% Else %> <%= getSubMedia(subMedia) %> <% End If %>
TitleCategoryTypeStart/PublishedEndOwnedEditDelete
[Add New]
[Add New]
<% set objConn = Nothing %>