Image
 

Headlines

Sunday Real Estate articles from RAMC

Every Sunday, The Realtor Association of Martin County publishes an article in the Real Estate section of the Stuart News. We've archived those articles for your reference and convenience here.

Record Pending Sales
This is an iMIS Web site

Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /AM/Template.cfm
Time Stamp 11-Jul-11 11:48 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
63 ms 63 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 11 ms 3 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm
31 ms 8 ms 4 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.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\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\DetermineHeader.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\TemplateBreadCrumbTag.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 1 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateInteriorNav.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:48:12.012
  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'
qNavInfo (Datasource=, Time=16ms, Records=4) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm @ 11:48:12.012
       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:48:12.012
     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:48:12.012
      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:48:12.012
        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=16ms, Records=7) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm @ 11:48:12.012
       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:48:12.012
      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:48:12.012
        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:48:12.012
      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:48:12.012
        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:48:12.012
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder, AncestoryList
     FROM l_NavMenu
    WHERE NavMenuID = 717
 ORDER BY SortOrder
qBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:48:12.012
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (
          NavMenuID IN (637) 
          )
 ORDER BY SortOrder
qHomeSectionBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 11:48:12.012
   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:48:12.012
    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) = 2349

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

    
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:48:12.012
    
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:48:12.012
    
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:48:12.012
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  2349    
 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:48:12.012
    
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=News_and_Headlines&Template=/CM/HTMLDisplay.cfm&ContentID=2349&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=764491
cftoken=40884118
hitcount=1
lastvisit={ts '2011-07-11 11:48:12'}
pausetrans=0
timecreated={ts '2011-07-11 11:48:12'}
urltoken=CFID=764491&CFTOKEN=40884118

Cookie Variables:
CFID=764491
CFTOKEN=40884118

Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=764491
cftoken=40884118
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_764491_40884118
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=News_and_Headlines
title=
urltoken=CFID=764491&CFTOKEN=40884118
username=

URL Parameters:
CONTENTID=2349
FUSEFLAG=1
SECTION=News_and_Headlines
TEMPLATE=/CM/HTMLDisplay.cfm
Debug Rendering Time: 15 ms