Image
 

eKey

Your Integrated Key Solution

Supra offers eKey software compatible with many of today's best new mobile devices. The eKey program is installed on your phone, and allows you to access Supra Keyboxes and use all the other functions the system offers right from your mobile device.

eKey supports most current smartphones, including the iPhone, Android phones, and all current BlackBerry models. Since none of these phones have an onboard infrared transceiver, they require a separate piece of equipment in order to communicate with Keyboxes. This device can be purchased along with your eKey serivce at RAMC for a one-time cost of $55, and are required for use of the eKey system.

Full MLS information on your internet-enabled mobile phone is also available, though it is not a Supra product. See our MLXChange Mobile Page for more information.

For more information about the cost and requirements for an eKey, download the eKey order form or email Jeremey at jeremey@martin-realtors.org
This is an iMIS Web site

Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /AM/Template.cfm
Time Stamp 28-Apr-11 11:27 AM
Locale English (US)
User Agent
Remote IP 65.245.209.177
Host Name 65.245.209.177

Execution Time

Total Time Avg Time Count Template
78 ms 78 ms 1 top level C:\USERS\RAMC\WWW\AM\Template.cfm
47 ms 47 ms 1 C:\USERS\RAMC\WWW\AM\Templates\TemplateHeader\RAMCONLINE_1505_20090807T100246_LayoutHeader.cfm
32 ms 8 ms 4 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateInteriorNav.cfm
16 ms 5 ms 3 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\Templates\TemplateFooter\RAMCONLINE_1505_20090807T100246_LayoutFooter.cfm
15 ms 15 ms 1 C:\USERS\RAMC\WWW\AM\DetermineHeader.cfm
15 ms 15 ms 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Application.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\ApplicationCustom.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\ApplicationUDFs.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\CM\HTMLDisplay.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\LoadSessionVariables.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\OnRequestEnd.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\TemplateBody.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\TemplateSection.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Templates\FooterInclude.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Templates\HeaderInclude.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateDropDownRenderTag.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateHeaderConfigFile.cfm
0 ms 0 ms 2 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationSetNavCSS.cfm
0 ms 0 ms 6 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateUtilityLinksTag.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
78 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

GetSystemVariables (Datasource=RAMCNEW, Time=0ms, Records=38) in C:\USERS\RAMC\WWW\AM\LoadSessionVariables.cfm @ 11:27:51.051
  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'
qNavInfo (Datasource=, Time=0ms, Records=4) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm @ 11:27:52.052
       SELECT Name, SortOrder
         FROM l_NavMenu
        WHERE 
                (
                
                
                ShowInSideFlag = 'Y'
                )
               
              AND WebsiteKey = '8e8a2045-bd8a-4ed9-977f-a42863617bd0'
     ORDER BY SortOrder
qSearchNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateUtilityLinksTag.cfm @ 11:27:52.052
     SELECT Name
       FROM l_NavMenu
      WHERE WebsiteKey = '8e8a2045-bd8a-4ed9-977f-a42863617bd0' AND
            Title = 'Search'
qContentRecordInfo (Datasource=RAMCNEW, Time=16ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
      SELECT CASE
               WHEN a.WorkflowStatusCode = ? THEN a.ContentID
               WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
             END AS ContentID
        FROM vCurrent_Content a LEFT OUTER JOIN Content c ON
              CASE
                WHEN a.WorkflowStatusCode = ? THEN a.ContentID
                WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
              END = c.ContentID
       WHERE a.NavMenuID = ?
    ORDER BY a.SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = P
Parameter #2(CF_SQL_CHAR) = W
Parameter #3(CF_SQL_CHAR) = A
Parameter #4(CF_SQL_CHAR) = P
Parameter #5(CF_SQL_CHAR) = W
Parameter #6(CF_SQL_CHAR) = A
Parameter #7(CF_SQL_NUMERIC) = 577.0

GetContentInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1255
Parameter #2(CF_SQL_NUMERIC) = 1255
Parameter #3(CF_SQL_NUMERIC) = 1255

qNavInfo (Datasource=, Time=0ms, Records=7) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm @ 11:27:52.052
       SELECT Name, SortOrder
         FROM l_NavMenu
        WHERE 
                (
                ShowInTopFlag = 'Y'
                
                
                )
               
              AND WebsiteKey = '8e8a2045-bd8a-4ed9-977f-a42863617bd0'
     ORDER BY SortOrder
qContentRecordInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
      SELECT CASE
               WHEN a.WorkflowStatusCode = ? THEN a.ContentID
               WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
             END AS ContentID
        FROM vCurrent_Content a LEFT OUTER JOIN Content c ON
              CASE
                WHEN a.WorkflowStatusCode = ? THEN a.ContentID
                WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
              END = c.ContentID
       WHERE a.NavMenuID = ?
    ORDER BY a.SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = P
Parameter #2(CF_SQL_CHAR) = W
Parameter #3(CF_SQL_CHAR) = A
Parameter #4(CF_SQL_CHAR) = P
Parameter #5(CF_SQL_CHAR) = W
Parameter #6(CF_SQL_CHAR) = A
Parameter #7(CF_SQL_NUMERIC) = 583.0

GetContentInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1264
Parameter #2(CF_SQL_NUMERIC) = 1264
Parameter #3(CF_SQL_NUMERIC) = 1264

qContentRecordInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
      SELECT CASE
               WHEN a.WorkflowStatusCode = ? THEN a.ContentID
               WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
             END AS ContentID
        FROM vCurrent_Content a LEFT OUTER JOIN Content c ON
              CASE
                WHEN a.WorkflowStatusCode = ? THEN a.ContentID
                WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
              END = c.ContentID
       WHERE a.NavMenuID = ?
    ORDER BY a.SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = P
Parameter #2(CF_SQL_CHAR) = W
Parameter #3(CF_SQL_CHAR) = A
Parameter #4(CF_SQL_CHAR) = P
Parameter #5(CF_SQL_CHAR) = W
Parameter #6(CF_SQL_CHAR) = A
Parameter #7(CF_SQL_NUMERIC) = 589.0

GetContentInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1257
Parameter #2(CF_SQL_NUMERIC) = 1257
Parameter #3(CF_SQL_NUMERIC) = 1257

qCurrentSectionNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:27:52.052
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder, AncestoryList
     FROM l_NavMenu
    WHERE NavMenuID = 651
 ORDER BY SortOrder
qBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:27:52.052
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (
          NavMenuID IN (632) 
          )
 ORDER BY SortOrder
qHomeSectionBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:27:52.052
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (Name = 'Home')
 ORDER BY SortOrder
GetHTML (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\CM\HTMLDisplay.cfm @ 11:27:52.052
    SELECT a.*, b.Keywords, b.Description, b.MembersOnlyFlag
      FROM Content_HTML a, Content b
     WHERE a.ContentID = b.ContentID
       AND a.ContentID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 2424

qContentRecordInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
      SELECT CASE
               WHEN a.WorkflowStatusCode = ? THEN a.ContentID
               WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
             END AS ContentID
        FROM vCurrent_Content a LEFT OUTER JOIN Content c ON
              CASE
                WHEN a.WorkflowStatusCode = ? THEN a.ContentID
                WHEN a.WorkflowStatusCode IN (?,?) THEN a.PreviousContentID
              END = c.ContentID
       WHERE a.NavMenuID = ?
    ORDER BY a.SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = P
Parameter #2(CF_SQL_CHAR) = W
Parameter #3(CF_SQL_CHAR) = A
Parameter #4(CF_SQL_CHAR) = P
Parameter #5(CF_SQL_CHAR) = W
Parameter #6(CF_SQL_CHAR) = A
Parameter #7(CF_SQL_NUMERIC) = 595.0

GetContentInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1258
Parameter #2(CF_SQL_NUMERIC) = 1258
Parameter #3(CF_SQL_NUMERIC) = 1258

Stored Procedures

amsp_CMGetPublishedContentID (Datasource=RAMCNEW, Time=0ms) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  1255    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset
amsp_CMGetPublishedContentID (Datasource=RAMCNEW, Time=0ms) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  1264    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset
amsp_CMGetPublishedContentID (Datasource=RAMCNEW, Time=0ms) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  1257    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset
amsp_CMGetPublishedContentID (Datasource=RAMCNEW, Time=0ms) in C:\USERS\RAMC\WWW\AM\CM\HTMLDisplay.cfm @ 11:27:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  2424    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset
amsp_CMGetPublishedContentID (Datasource=RAMCNEW, Time=16ms) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:27:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  1258    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\USERS\RAMC\WWW\AM\Template.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.ramconline.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/AM/Template.cfm
PATH_TRANSLATED=C:\USERS\RAMC\WWW\AM\Template.cfm
QUERY_STRING=Section=eKey_Information&Template=/CM/HTMLDisplay.cfm&ContentID=2424&FuseFlag=1
REMOTE_ADDR=65.245.209.177
REMOTE_HOST=65.245.209.177
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AM/Template.cfm
SERVER_NAME=www.ramconline.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=643390
cftoken=74305416
hitcount=1
lastvisit={ts '2011-04-28 11:27:51'}
pausetrans=0
timecreated={ts '2011-04-28 11:27:51'}
urltoken=CFID=643390&CFTOKEN=74305416

Cookie Variables:
CFID=643390
CFTOKEN=74305416

Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=643390
cftoken=74305416
chapter=
cm=Struct (13)
cmbordercolor=#D1CDBB
cmcurrentfolderid=
cmeditorredirecturl=
cmfolderdisplay=
cmfoldersectiondisplay=
cmnavcontentgroupind=N
cmsavetemplatepath=
cmsectiondisplay=
cmsuperadminflag=
cmsurftoeditcontentid=0
cmsurftoeditreturnurl=
cmtextonlytemplate=False
cmwebsitekey=
committee=
companymaster=false
companymembershipnum=
companyname=
contactid=0
coregistrant=Array (0)
cpinvitegroupmembers=Array (0)
debug=False
emailaddress=
faqflag=
firstname=
fontface=verdana
fontsize=2
geformsubmitted=false
headersize=3
imismemberid=
initialized=True
interestcategorylist=
jbcompany=Struct (0)
jbpreview=Struct (0)
jbsearch=Struct (0)
lastname=
location=Struct (8)
loggedin=0
member=Struct (18)
memberid=0
membershipflag=false
membertype=
message=
ol=Struct (2)
platform=Windows
publicresultsflag=
questiondisplaylimit=
redirect=
redirectfrom=
registrationpage=
rowcolor1=FFFFFF
rowcolor2=D1DDEA
sc=Struct (3)
scadmincomponentcodelist=
screturnmessage=Click here to continue.
securitygrouplist=
sessionid=RAMCNEW_643390_74305416
shoppingcart=Array (0)
staff=Struct (13)
surveydate=
surveyid=0
surveyreporttemplate=
surveyresponse=0
surveyresponseid=0
surveyreviewquestionlist=
surveytakenlist=
surveytype=
sy=Struct (20)
templatepath=/AM/Template.cfm?Section=eKey_Information
title=
urltoken=CFID=643390&CFTOKEN=74305416
username=

URL Parameters:
CONTENTID=2424
FUSEFLAG=1
SECTION=eKey_Information
TEMPLATE=/CM/HTMLDisplay.cfm
Debug Rendering Time: 31 ms