Image

 

Member Service Center

For all Your Real Estate Needs

RAMC's Member Service Center is on site to provide you with tools and materials to make doing business easy. We carry signs, flags, flyer boxes, and many other promotional items for use at your listings and Open Houses, as well as Area Maps, CDs and DVDs and our new Relocation Guide for potential clents.

A complete list of our items for sale, including pricing information, is available here:

Member Service Center Inventory & Price List

This is an iMIS Web site


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /AM/Template.cfm
Time Stamp 31-Jan-12 11:30 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
94 ms 94 ms 1 top level C:\USERS\RAMC\WWW\AM\Template.cfm
63 ms 63 ms 1 C:\USERS\RAMC\WWW\AM\Templates\TemplateHeader\RAMCONLINE_1505_20090807T100246_LayoutHeader.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\Application.cfm
16 ms 4 ms 4 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm
16 ms 3 ms 6 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateUtilityLinksTag.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\TemplateInteriorNav.cfm
15 ms 5 ms 3 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.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  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
110 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:30:40.040
  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:30:40.040
       SELECT Name, SortOrder
         FROM l_NavMenu
        WHERE 
                (
                
                
                ShowInSideFlag = 'Y'
                )
               
              AND WebsiteKey = '8e8a2045-bd8a-4ed9-977f-a42863617bd0'
     ORDER BY SortOrder
    
qSearchNavInfo (Datasource=, Time=16ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateUtilityLinksTag.cfm @ 11:30:40.040
     SELECT Name
       FROM l_NavMenu
      WHERE WebsiteKey = '8e8a2045-bd8a-4ed9-977f-a42863617bd0' AND
            Title = 'Search'
    
qContentRecordInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:30:40.040
      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:30:40.040
        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:30:40.040
       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:30:40.040
      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:30:40.040
        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:30:40.040
      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:30:40.040
        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:30:40.040
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder, AncestoryList
     FROM l_NavMenu
    WHERE NavMenuID = 638
 ORDER BY SortOrder
qBreadCrumbNavInfo (Datasource=, Time=16ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:30:40.040
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (
          NavMenuID IN (553) 
          )
 ORDER BY SortOrder
qHomeSectionBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:30:40.040
   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:30:40.040
    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) = 2489

qContentRecordInfo (Datasource=RAMCNEW, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.cfm @ 11:30:40.040
      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:30:40.040
        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:30:40.040

    
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:30:40.040
    
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:30:40.040
    
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:30:40.040
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  2489    
 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:30:40.040
    
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=Realtor_Store&Template=/CM/HTMLDisplay.cfm&ContentID=2489&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=1137177
cftoken=84712404
hitcount=1
lastvisit={ts '2012-01-31 11:30:40'}
pausetrans=0
timecreated={ts '2012-01-31 11:30:40'}
urltoken=CFID=1137177&CFTOKEN=84712404
Cookie Variables:
CFID=1137177
CFTOKEN=84712404
Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=1137177
cftoken=84712404
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_1137177_84712404
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=Realtor_Store
title=
urltoken=CFID=1137177&CFTOKEN=84712404
username=
URL Parameters:
CONTENTID=2489
FUSEFLAG=1
SECTION=Realtor_Store
TEMPLATE=/CM/HTMLDisplay.cfm
Debug Rendering Time: 15 ms