|
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
-------------
|