%
function replaceXML(value)
if not isNull(value) then
value = Replace(value,"&","&")
value = Replace(value,vbcrlf,"
")
value = Replace(value,"&","&")
value = Replace(value,"'","'")
value = Replace(value,"""",""")
value = Replace(value,"'","'")
'value = Replace(value,"'","'")
value = Replace(value,""","""")
end if
replaceXML=value
end function
function get_PathNav(idR,objConn,idC)
set rsPath=Server.CreateObject("ADODB.recordset")
sqlPath = "SELECT * FROM T_TT_TreeTrasparenza WHERE TT_id=" & idR
rsPath.Open sqlPath,objConn,3,3
if not rsPath.EOF then
if idR=idC then
strPath = rsPath("TT_Desc")
else
strPath = "" & rsPath("TT_Desc") & ""
end if
if rsPath("TT_idP")<>"0" then
strPath = get_PathNav(rsPath("TT_idP"),objConn,idC) & " > " & strPath
else
strPath= "Amministrazione trasparente " & strPath
end if
else
strPath= "Amministrazione trasparente "
end if
get_PathNav=strPath
rsPath.Close
set rsPath=nothing
end function
%>
<%
Dim idP
if Trim(Request.QueryString("idP"))="" then
idP=0
else
idP=Request.QueryString("idP")
end if
set dbConn = Server.CreateObject("ADODB.connection")
dbConn.Open DB_ASL9_READ,"",""
if idP<>0 then
set rsTP= Server.CreateObject("ADODB.recordset")
sqlTP = "SELECT * FROM T_TT_TreeTrasparenza WHERE TT_id=" & idP & " ORDER BY TT_Order"
rsTP.Open sqlTP,dbConn,3,3
if rsTP.EOF then
title="Amministrazione trasparente"
else
title=rsTP("TT_Desc")
if Len(rsTP("TT_Testo"))>0 then
txtDesc = replaceXML(rsTP("TT_Testo"))
end if
end if
else
title="Amministrazione trasparente"
end if
set rsTree = Server.CreateObject("ADODB.recordset")
sqlTree = "SELECT * FROM T_TT_TreeTrasparenza WHERE TT_idP=" & idP & " ORDER BY TT_Order"
rsTree.Open sqlTree,dbConn,3,3
%>