En loop
Det er loopen det er galt med .. hvad gør jeg galt ? Den låser når jeg går ind på siden ..Håber i forstår hvad jeg laver ;) .. ellers stil spørgsmål .. skal have det her lort til at virke ..
Source of new.asp:
<% response.Expires = 0 %>
<% response.Buffer = TRUE %>
<%
If isEmpty(Session(\"UserID\")) Then
Response.Redirect(\"index.asp?frame=admin\")
End If
%>
<%
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database/strip.mdb\") & \";UID=admin;PWD=unga;\"
If Request.Form(\"yepper\") = \"Submit\" then
If Request.Form(\"vildu\") = \"yes\" then
\'####### Add lortet #######
Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \" & Request.Form(\"filename\") & \" \"
rs.Execute StrSQL
danick = rs(\"nick\")
daemail = rs(\"email\")
daurl = rs(\"url\")
datitle = rs(\"title\")
dapicture = rs(\"picture\")
dacomment = rs(\"comment\")
dadate = rs(\"date\")
datime = rs(\"time\")
rs.Close
rs.Open \"SELECT * FROM pictures WHERE (ID = 0)\",tempConn
rs.AddNew
rs(\"nick\") = danick
rs(\"email\") = daemail
rs(\"url\") = daurl
rs(\"title\") = datitle
rs(\"picture\") = dapicture
rs(\"comment\") = dacomment
rs(\"date\") = dadate
rs(\"time\") = datime
rs.Update
rs.Close
Set rst = Server.CreateObject(\"ADODB.Connection\")
rst.Open \"DELETE * FROM uploads where picture =\" & \"\'\" & Request.Form(\"filename\") & \"\'\" & \" \",tempConn,adOpenStatic
rst.Close
Set myConn = nothing
End If
If Request.Form(\"vildu\") = \"no\" then
\'####### Delete lortet #######
StrSql = \"DELETE * FROM uploads where picture =\" & \"\'\" & Request.Form(\"filename\") & \"\'\" & \" \"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open tempConn
myConn.Execute(StrSql)
myConn.Close
Set myConn = nothing
End If
End If
%>
<!--#Include file=\"inc/starthtml.inc\" -->
<p align=\"center\"><b><font CLASS=\"medium\">#STRIPCOMPO2 - New Pictures</font></b></p>
<%
Set Image = Server.CreateObject(\"AspImage.Image\")
Set RS = Server.CreateObject(\"ADODB.RecordSet\")
RS.Open \"SELECT * FROM uploads\",tempConn,adOpenStatic
Do While Not rs.EOF
nick = rs(\"nick\")
email = rs(\"email\")
url = rs(\"url\")
title = rs(\"title\")
picture = rs(\"picture\")
dato = rs(\"date\")
tid = rs(\"time\")
comment = rs(\"comment\")
If url = \"http://\" OR url = \"\" then
url = \"No Homepage Entered.\"
End If
Image.Loadimage(\"c:\\inetpub\\wwwroot\\newstrip\\uploads\\\" & picture)
height = Image.MaxY
width = Image.MaxX
%>
<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"1\">
<tr>
<td width=\"100%\" colspan=\"3\" align=\"center\"><font><%=title%></font></td>
</tr>
<tr>
<td width=\"100%\" colspan=\"3\" align=\"center\"><img src=\"uploads/<%=picture%>\" height=\"<%=height%>\" width=\"<%=width%>\" border=\"0\"></td>
</tr>
<tr>
<td width=\"100%\" colspan=\"3\" align=\"center\"><font>Comment:<br><br><%=comment%></font></td>
</tr>
<td width=\"33%\"><a href=\"mailto:<%=email%>\"><font><%=nick%></font></a></td>
<td width=\"33%\"><a href=\"<%=url%>\"><font><%=url%></font></a></td>
<td width=\"34%\"><font>Added: <%=dato%> @ <%=tid%></font></td>
</tr>
<tr>
<td width=\"100%\" colspan=\"3\"><form method=\"POST\" action=\"new.asp\">
<font>Do you want to add the picture ?</font><br>
<input type=\"radio\" value=\"yes\" checked name=\"vildu\">Yes<br>
<input type=\"radio\" name=\"vildu\" value=\"no\">No
<input type=\"hidden\" name=\"filename\" value=\"<%=picture%>\">
<br><input type=\"submit\" value=\"Submit\" name=\"yepper\">
</form></td>
</tr>
</table>
<%
rs.MoveNext
Loop
Set tempConn = nothing
Set rs = nothing
Set image = nothing
%>
<!--#Include file=\"inc/endhtml.inc\" -->
