Image
 

MLXChange Mobile

Your Wireless MLS Solution

MLX Wireless gives Realtors on the go the ability to access RAMC's Multiple Listing Service right from their internet-enabled phone. You'll never be caught without the information you need for your clients again, even at a moment's notice!

First, sign up at: http://ramc.mlxwireless.com/register/

Then, simply open your phone's internet browser, and navigate to:

http://ramc.mlxwireless.com

You'll use the same login and password you use on your computer to log in.

If you have any questions, please call MLX Wireless Technical Support at:
1-866-304-0080 or email at:
mlxsupport@mosthome.com
Monday through Friday from 10:00AM to 8:00PM EST.

You may scan this QR code with your phone to go directly to the MLX Wireless Site:
This is an iMIS Web site

Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /AM/Template.cfm
Time Stamp 15-Jul-11 02:35 PM
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
62 ms 62 ms 1 top level C:\USERS\RAMC\WWW\AM\Template.cfm
31 ms 31 ms 1 C:\USERS\RAMC\WWW\AM\Templates\TemplateHeader\RAMCONLINE_1505_20090807T100246_LayoutHeader.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\CM\HTMLDisplay.cfm
16 ms 16 ms 1 C:\USERS\RAMC\WWW\AM\TemplateBody.cfm
15 ms 15 ms 1 C:\USERS\RAMC\WWW\AM\DetermineHeader.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\LoadSessionVariables.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\OnRequestEnd.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 4 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateAreaSectionTag.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 3 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateNavigationTag.cfm
0 ms 0 ms 6 C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateUtilityLinksTag.cfm
0 ms 0 ms 1 C:\USERS\RAMC\WWW\AM\Templates\TemplateFooter\RAMCONLINE_1505_20090807T100246_LayoutFooter.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
62 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 @ 14:35:13.013
  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 @ 14:35:13.013
       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 @ 14:35:13.013
     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 @ 14:35:13.013
      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 @ 14:35:13.013
        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 @ 14:35:13.013
       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 @ 14:35:13.013
      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 @ 14:35:13.013
        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 @ 14:35:13.013
      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 @ 14:35:13.013
        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 @ 14:35:13.013
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder, AncestoryList
     FROM l_NavMenu
    WHERE NavMenuID = 724
 ORDER BY SortOrder
qBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 14:35:13.013
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (
          NavMenuID IN (635) 
          )
 ORDER BY SortOrder
qHomeSectionBreadCrumbNavInfo (Datasource=, Time=0ms, Records=1) in C:\USERS\RAMC\WWW\AM\Templates\LayoutAPI\TemplateBreadCrumbTag.cfm @ 14:35:13.013
   SELECT Breadcrumb, Title, PostFuseURL, PreFuseURL, Name, OpenInNewWindowFlag, SortOrder
     FROM l_NavMenu
    WHERE (Name = 'Home')
 ORDER BY SortOrder
GetHTML (Datasource=RAMCNEW, Time=16ms, Records=1) in C:\USERS\RAMC\WWW\AM\CM\HTMLDisplay.cfm @ 14:35:13.013
    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) = 2427

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

    
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 @ 14:35:13.013
    
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 @ 14:35:13.013
    
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 @ 14:35:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  2427    
 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 @ 14:35:13.013
    
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=MLXChange_Mobile&Template=/CM/HTMLDisplay.cfm&ContentID=2427&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=771560
cftoken=34230230
hitcount=1
lastvisit={ts '2011-07-15 14:35:13'}
pausetrans=0
timecreated={ts '2011-07-15 14:35:13'}
urltoken=CFID=771560&CFTOKEN=34230230

Cookie Variables:
CFID=771560
CFTOKEN=34230230

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

URL Parameters:
CONTENTID=2427
FUSEFLAG=1
SECTION=MLXChange_Mobile
TEMPLATE=/CM/HTMLDisplay.cfm
Debug Rendering Time: 16 ms