Something like this makes it possible:
<% 'no security checking %>
<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
%>
<!--#include file="db.asp"-->
<%
response.buffer = true
'get key
key = request.querystring("key")
if key="" or isnull(key) then
key=request.form("key")
end if
if key="" or isnull(key) then response.redirect "tblPMMessagelist.asp"
'get action
a=request.form("a")
if a="" or isnull(a) then
a="I" 'display with input box
end if
' Open Connection to the database
set conn = Server.CreateObject("ADODB.Connection")
conn.Open xDb_Conn_Str
Select Case a
Case "I": ' Get a record to display
tkey = key
strsql = "SELECT * FROM [tblPMMessage] WHERE [PM_ID]=" & tkey
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn
If rs.EOF Then
Response.Clear
Response.Redirect "tblPMMessagelist.asp"
Else
rs.MoveFirst
End If
' Get the field contents
x_PM_ID = rs("PM_ID")
x_Author_ID = rs("Author_ID")
x_From_ID = rs("From_ID")
x_PM_Tittle = rs("PM_Tittle")
x_PM_Message = rs("PM_Message")
x_PM_Message_Date = rs("PM_Message_Date")
x_Read_Post = rs("Read_Post")
x_Email_notify = rs("Email_notify")
rs.Close
Set rs = Nothing
End Select
%>
<!--#include file="header.asp"-->
<p><font size="-1">View TABLE : tbl PMMessage<br><br><a href="tblPMMessagelist.asp">Back to List</a></font></p>
<p>
<form>
<table border="0" cellspacing="1" cellpadding="5" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">PM ID</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% response.write x_PM_ID %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">Author ID</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% response.write x_Author_ID %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">From ID</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% response.write x_From_ID %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">PM Tittle</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% response.write x_PM_Tittle %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">PM Message</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><%= replace(x_PM_Message & "",chr(10),"<br>") %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">PM Message Date</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% response.write x_PM_Message_Date %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">Read Post</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% If x_Read_Post = True Then %><%= "Yes" %><% Else %><%= "No" %><% End If %></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">Email notify</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><% If x_Email_notify = True Then %><%= "Yes" %><% Else %><%= "No" %><% End If %></font> </td>
</tr>
</table>
</form>
<p>
<!--#include file="footer.asp"-->
Created this with aspmaker