<%@LANGUAGE="VBSCRIPT"%> <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="" MM_authFailedURL="index.asp" MM_grantAccess=false If Session("MM_Username") <> "" Then If (true Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString() MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer) Response.Redirect(MM_authFailedURL) End If %> <% Dim rs_documents__MMColParam rs_documents__MMColParam = "1" If (Request.QueryString("DocumentID") <> "") Then rs_documents__MMColParam = Request.QueryString("DocumentID") End If %> <% Dim rs_documents Dim rs_documents_cmd Dim rs_documents_numRows Set rs_documents_cmd = Server.CreateObject ("ADODB.Command") rs_documents_cmd.ActiveConnection = MM_conRemax_STRING rs_documents_cmd.CommandText = "SELECT * FROM remax_stratfordhomes_ca.intra_documents WHERE DocumentID = ?" rs_documents_cmd.Prepared = true rs_documents_cmd.Parameters.Append rs_documents_cmd.CreateParameter("param1", 5, 1, -1, rs_documents__MMColParam) ' adDouble Set rs_documents = rs_documents_cmd.Execute rs_documents_numRows = 0 %> Remax a-b realty ltd. Intranet

Documentation
Type
<%=(rs_documents.Fields.Item("DocumentType").Value)%>
File
Description <%=(rs_documents.Fields.Item("DocumentDescription").Value)%>
Text
<%=(rs_documents.Fields.Item("DocumentText").Value)%>
Date Entered
<%= DoDateTime((rs_documents.Fields.Item("DocumentDateEntry").Value), 1, -1) %>
Date Updated <%= DoDateTime((rs_documents.Fields.Item("DocumentDateUpdate").Value), 1, -1) %>

Site Design By

<% rs_documents.Close() Set rs_documents = Nothing %>