Nu finns det en MASSA temp filer. Men det går EXTREMT långsamt att komma in på sidan alltså!
SIDAN:
<html>
<head>
<title>Josefine Sundström Artist Page 2002</title>
<link rel="stylesheet" type="text/css" href="../josefine.css">
</head>
<body bgcolor="#BFC8C0">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="1">
<tr>
<td width="546"><!-- #include file="meny2.asp" --></td>
</tr>
<tr>
<td background="../images/background.gif" width="546" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="97%">
<tr>
<td width="74%" valign="top"><img border="0" src="../hoger_meny/mellan.gif" width="1" height="4"><%
If not Request.Querystring("url") = "" Then
Set MinCon = Server.CreateObject("ADODB.Connection")
Set RecSet = Server.CreateObject("ADODB.RecordSet")
db = "nyheter.mdb"
MinCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath(db)
SQL = "SELECT TOP 1 * From nyheter Where url=" & Request.Querystring("url") &" AND visa = 'sida'"
RecSet.Open SQL, MinCon, 3,3
Set objFS=Server.CreateObject("Scripting.FileSystemObject")
strName="temp" & round(Timer()) & ".asp"
' ---start av loopen---
Do While Not RecSet.EOF
Dim myMenu
myMeny = CInt(RecSet("kommentar"))
Select Case myMeny
Case 1
%><!-- #include file="home_menu.asp" --><%
Case 2
%><!-- #include file="information_menu.asp" --><%
Case 3
%><!-- #include file="contact_menu.asp" --><%
Case 4
%><!-- #include file="media_menu.asp" --><%
End Select
%>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" width="98%" height="1">
<tr>
<td width="68%" valign="top" height="1"><br><%
Set objFile=objFS.CreateTextFile(Server.MapPath(strName),True)
Call objFile.WriteLine(RecSet("kod"))
Call objFile.Close
Set objFile=objFS.CreateTextFile(Server.MapPath(strName),True)
Call objFile.Close
Loop
' ---slut på loopen---
Call obJFS.DeleteFile(Server.MapPath(strName))
Set objFS=Nothing
Call RecSet.Close
Set RecSet=Nothing
MinCon.Close
end if
'Följande if-sats körs bara om ?url är tom i querysting
If not Request.Querystring("url") = "" Then
SQL = "SELECT TOP 1 * From nyheter Where url=" & Request.Querystring("url") &" AND visa = 'nyhet'"
RecSet.Open SQL, MinCon
Do While Not RecSet.EOF
%>
<!-- #include file="home_menu.asp" -->
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" width="98%" height="1">
<tr>
<td width="68%" valign="top" height="1">
<br>
<img border="0" src="../logo/nyheter.gif"><br><br>
<%
If NOT RecSet("bild_2") = "" Then
%>
<img border="1" src="../abc123/news/<%=RecSet("bild_2")%>.gif"><br>
<img border="0" src="../green/mellan.rum.gif" width="1" height="1"><br>
<%
End If
If NOT RecSet("kommentar_2") = "" Then
%>
<font face="arial"><%=RecSet("kommentar_2")%></font><br>
<img border="0" src="../green/mellan.rum.gif" width="1" height="1"><br>
<%
End If
If NOT RecSet("foto_2") = "" Then
%>
<font face="arial">Foto: <%=RecSet("foto_2")%></font>
<%
End If
If NOT RecSet("bild_2") = "" Then
%>
<br><img border="0" src="../green/mellan.rum.gif" width="1" height="5"><br>
<%
End If
If NOT RecSet("bild") = "" Then
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="38" align="right">
<tr>
<td width="0%">
<img border="1" src="../abc123/news/<%=RecSet("bild")%>.gif"><br>
<img border="0" src="../green/mellan.rum.gif" width="1" height="1"><br>
</td>
</tr>
</table>
<%
End If
If NOT RecSet("kommentar") = "" Then
%>
<font face="arial"><%=RecSet("kommentar")%></font><br>
<img border="0" src="../green/mellan.rum.gif" width="1" height="1"><br>
<%
End If
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="0%">
<tr>
<td width="100%">
<%
If NOT RecSet("foto") = "" Then
%>
<font face="arial">Foto: <%=RecSet("foto")%></font>
<%
End If
If NOT RecSet("bild") = "" Then
%>
</td>
</tr>
</table>
<%
End If
%>
</td>
<td width="4"><img border="0" src="../green/mellan.rum.gif" width="4" height="1"></td>
</tr>
</table>
<font size="2"><b><%=RecSet("rubrik")%></b></font><br>
<img border="0" src="../green/mellan.rum.gif" width="1" height="3"><br>
<b><%=RecSet("intro")%></b>
<br><img border="0" src="../green/mellan.rum.gif" width="1" height="3"><br>
<%
Fixa = Server.HTMLEncode(RecSet("nyhet"))
Fixa = Replace(Trim(Fixa),"[line]","<img src=images/line.gif>")
Fixa = Replace(Trim(Fixa),"[","<")
Fixa = Replace(Trim(Fixa),"]",">")
Fixa = Replace(Trim(Fixa), vbCrLf, "<br>")
Response.Write Fixa
%>
<br><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="201">
<tr>
<td width="75"><b>Publicerad:</b></td>
<td width="126"><i><%=RecSet("datum")%></i></td>
</tr>
<tr>
<td width="75"><b>Uppdaterad:</b></td>
<td width="126"><i><%=RecSet("updated")%></i></td>
</tr>
</table>
<%
Count = Count + 1
RecSet.MoveNext
Loop
RecSet.Close
MinCon.Close
SQL = "SELECT TOP 1 * From nyheter Where url=" & Request.Querystring("url") &" AND visa = 'dagbok'"
RecSet.Open SQL, MinCon
Do While Not RecSet.EOF
%>
<!-- #include file="information_menu.asp" -->
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" width="98%" height="1">
<tr>
<td width="68%" valign="top" height="1">
<br><img border="0" src="../logo/dagbok.gif"><br><br>
<b><%=RecSet("rubrik")%></b><br>
<img border="0" src="../hoger_meny/mellan.gif" width="1" height="5"><br>
<%
Fixa = Server.HTMLEncode(RecSet("kod"))
Fixa = Replace(Trim(Fixa), vbCrLf, "<br>")
Response.Write Fixa
%>
<br><br>
<b>Publicerad:</b> <%=RecSet("datum")%><br><br>
<%
Count = Count + 1
RecSet.MoveNext
Loop
RecSet.Close
MinCon.Close
SQL = "SELECT TOP 1 * From nyheter Where url=" & Request.Querystring("url") &" AND visa = 'disko'"
RecSet.Open SQL, MinCon
Do While Not RecSet.EOF
%>
<!-- #include file="information_menu.asp" -->
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" width="98%" height="1">
<tr>
<td width="68%" valign="top" height="1">
<br><img border="0" src="../logo/diskografi.gif"><br><br>
<b><%=RecSet("rubrik")%><br>
</b><%=RecSet("skivdatum")%><br><br>
<img border="0" src=" http://www.josefine-sundstrom.net/<%=RecSet("bild")%>">
<a target="_blank" href="%20http:/www.cdon.com/SE">Beställ på CDON.com</a><br><br>
<%
Response.Write(RecSet("kod"))
Count = Count + 1
RecSet.MoveNext
Loop
RecSet.Close
MinCon.Close
End If
%>
<img border="0" src="images/pixel.gif">
</td>
</tr>
</table>
</td>
<td width="60%" valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="118">
<tr>
<td width="100%"><!-- #include file="meny_hoger.asp" --></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</td>
</tr>
<tr>
<td width="546" align="center"><img border="0" src="images/copy_down.gif"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>