<!-- #INCLUDE FILE="1.asp" -->
<br><h2>List new Sent Comments >> Edit</h2>
<br>
<%
    ' -- view.asp --
    Response.Buffer = True
    Dim connectionString
    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("news99.mdb") 

    ' ID of the file to retrieve
    Dim ID
    ID = Request("ID")

    If Len(ID) < 1 Then
       ID = 0
    End If

    ' Recordset Object
    Dim rs
    Set rs = Server.CreateObject("ADODB.Recordset")

    ' opening connection
    rs.Open "SELECT * FROM Files WHERE ID="& ID, connectionString, 3, 4

    If Not rs.EOF Then

        While Not rs.EOF
%>


<br>
	<form method="POST" enctype="multipart/form-data" action="update9.asp?ID=<% =rs("ID")%>">
	<table border="0">
	<tr>
		<td>Headline :<br><input type="text" value="<% =rs("news_headline")%>" name="news_headline" size="40"></td>
	</tr>
	<tr>
		<td>Date :<br><input type="text" value="<% =rs("news_datetime")%>" name="news_datetime" size="40"></td>
	</tr>
	</tr>
	<td>Comment :<br>
	<%
	Dim str1
	str1 = RS("news_text")
	If isNull(str1) Then
		str1 = ""
	Else
		str1 = Replace(str1, "<BR>", vbCrLf)
	End If
%>
		<textarea style="WIDTH: 480px; HEIGHT: 263px" name="news_text" rows="3" cols="20"><%=str1%></textarea></td>
	</tr>
	<td>Name :<br><input type="text" value="<% =rs("news_writer")%>" name="news_writer" size="40">
	</td></tr>
	<td>Picture :<br><font color=red>...should be 445px</font><br>
		<input type="file" name="file" size="40"></td></tr>
	<td>Approve?:<br>
	<select name="file_desc">
		<option value="<% =rs("file desc")%>" Selected><% =rs("file desc")%></option>
		<option value="NO">NO</option>
		<option value="YES">YES</option>
	</select>
		</td></tr>
	<td>
		<input type="submit" value="Edit"></td></tr>
	</form>
	</tr>
	</table>

<br><br><a href="list9.asp">BAck to Sent Comments</a> or <a href="login.asp">Back to admin start page</a>


<%
            rs.MoveNext
        Wend
    Else
        Response.Write "No Record Found"
    End If

    rs.Close
    Set rs = Nothing

%>
<%End If%>
		</td>
	</tr>
</table>

										