Catch
Entries:14 | | additional | | Struct | | SQL | | string | SELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY lastname asc),Agents.PublicID,Agents.FirstName,Agents.LastName,Agents.AKA,Agents.Cell,Agents.Phone,Agents.Fax,Agents.Email,Agents.Team,Agents.Title,Agents.Extension,Agents.Certifications,Agents.WebsiteAddress,Agents.OfficeID,Agents.Image_List,'/global/images/nophoto/nophoto-agents.jpg' AS ImagePath,'/global/images/nophoto/nophoto-agents-thumb.jpg' AS ThumbPath,'' AS LogoPath,'' AS LogoPathSmall,'' AS BioPath,'F' AS HasBlog,Offices.OfficeName,Offices.OfficePhone,Offices.OfficeFax,Offices.OfficeTollFree,Offices.OfficeAddress,Offices.OfficeCity,Offices.OfficeState,Offices.OfficeZip,Offices.SerialNumber,Offices.OfficeDomainFROM AgentsINNER JOIN OfficesON Offices.OfficeID = Agents.OfficeIDWHERE (Agents.Status = 'A')AND (Agents.Website = 'T')AND (Agents.OfficeID = 'cbpre08')) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 10 |
|
| | DataSource | | | Detail | | | ErrorCode | | | ExtendedInfo | | | Message | | string | column [PROFILETEXT] not found in query, columns are [RowNumber,PublicID,FirstName,LastName,AKA,Cell,Phone,Fax,Email,Team,Title,Extension,Certifications,WebsiteAddress,OfficeID,Image_List,ImagePath,ThumbPath,LogoPath,LogoPathSmall,BioPath,HasBlog,OfficeName,OfficePhone,OfficeFax,OfficeTollFree,OfficeAddress,OfficeCity,OfficeState,OfficeZip,SerialNumber,OfficeDomain] |
| | NativeErrorCode | | | queryError | | string | SELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY lastname asc),Agents.PublicID,Agents.FirstName,Agents.LastName,Agents.AKA,Agents.Cell,Agents.Phone,Agents.Fax,Agents.Email,Agents.Team,Agents.Title,Agents.Extension,Agents.Certifications,Agents.WebsiteAddress,Agents.OfficeID,Agents.Image_List,'/global/images/nophoto/nophoto-agents.jpg' AS ImagePath,'/global/images/nophoto/nophoto-agents-thumb.jpg' AS ThumbPath,'' AS LogoPath,'' AS LogoPathSmall,'' AS BioPath,'F' AS HasBlog,Offices.OfficeName,Offices.OfficePhone,Offices.OfficeFax,Offices.OfficeTollFree,Offices.OfficeAddress,Offices.OfficeCity,Offices.OfficeState,Offices.OfficeZip,Offices.SerialNumber,Offices.OfficeDomainFROM AgentsINNER JOIN OfficesON Offices.OfficeID = Agents.OfficeIDWHERE (Agents.Status = 'A')AND (Agents.Website = 'T')AND (Agents.OfficeID = 'cbpre08')) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 10 |
| | Sql | | string | SELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY lastname asc),Agents.PublicID,Agents.FirstName,Agents.LastName,Agents.AKA,Agents.Cell,Agents.Phone,Agents.Fax,Agents.Email,Agents.Team,Agents.Title,Agents.Extension,Agents.Certifications,Agents.WebsiteAddress,Agents.OfficeID,Agents.Image_List,'/global/images/nophoto/nophoto-agents.jpg' AS ImagePath,'/global/images/nophoto/nophoto-agents-thumb.jpg' AS ThumbPath,'' AS LogoPath,'' AS LogoPathSmall,'' AS BioPath,'F' AS HasBlog,Offices.OfficeName,Offices.OfficePhone,Offices.OfficeFax,Offices.OfficeTollFree,Offices.OfficeAddress,Offices.OfficeCity,Offices.OfficeState,Offices.OfficeZip,Offices.SerialNumber,Offices.OfficeDomainFROM AgentsINNER JOIN OfficesON Offices.OfficeID = Agents.OfficeIDWHERE (Agents.Status = 'A')AND (Agents.Website = 'T')AND (Agents.OfficeID = 'cbpre08')) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 10 |
| | SQLState | | | StackTrace | | string | column [PROFILETEXT] not found in query, columns are [RowNumber,PublicID,FirstName,LastName,AKA,Cell,Phone,Fax,Email,Team,Title,Extension,Certifications,WebsiteAddress,OfficeID,Image_List,ImagePath,ThumbPath,LogoPath,LogoPathSmall,BioPath,HasBlog,OfficeName,OfficePhone,OfficeFax,OfficeTollFree,OfficeAddress,OfficeCity,OfficeState,OfficeZip,SerialNumber,OfficeDomain]at railo.runtime.type.QueryImpl.getAt(QueryImpl.java:908):908at railo.runtime.type.QueryImpl.get(QueryImpl.java:2127):2127at railo.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:240):240at railo.runtime.PageContextImpl.get(PageContextImpl.java:1296):1296at iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent._default_cfm$cf._call000948(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm:463):463at iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent._default_cfm$cf.call(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm:321):321at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:716):716at components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:89):89at components.lib.iq_cfc$cf.udfCall(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc):-1at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383at railo.runtime.ComponentImpl.call(ComponentImpl.java:1793):1793at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1445):1445at iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent.layouts._site_cfm$cf._call000078(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm:430):430at iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent.layouts._site_cfm$cf.call(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm:360):360at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:716):716at components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:59):59at components.lib.iq_cfc$cf.udfCall(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc):-1at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1445):1445at components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:36):36at components.lib.iq_cfc$cf.udfCall(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc):-1at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383at railo.runtime.ComponentImpl.call(ComponentImpl.java:1793):1793at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1445):1445at application_cfc$cf.udfCall(C:\realistiQ\WWWContent\iqweb\application.cfc:335):335at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383at railo.runtime.ComponentImpl.call(ComponentImpl.java:1793):1793at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:33):33at javax.servlet.http.HttpServlet.service(HttpServlet.java:854):854at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:503):503at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390):390at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216):216at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182):182at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765):765at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418):418at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:329):329at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:127):127at org.mortbay.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:493):493at javax.servlet.http.HttpServlet.service(HttpServlet.java:740):740at javax.servlet.http.HttpServlet.service(HttpServlet.java:854):854at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:503):503at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390):390at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216):216at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182):182at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765):765at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418):418at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220):220at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114):114at org.mortbay.jetty.Server.handle(Server.java:326):326at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536):536at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:913):913at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:540):540at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212):212at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405):405at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409):409at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451):451 |
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 461: <tr><br>462: <td valign="top" bgcolor="##FFFFFF" class="PageBody"><br><b>463: <cfif retAgents.query.ProfileText EQ ""></b><br>464: <p style="color:##000"><br>465: Thank you for visiting #OurOrMy# site. These pages are intended to provide you with information on all aspects of Tulsa Real Estate. Use the links to find answers to any questions regarding our services or the process itself. Of course always feel free to Contact Me directly by phone and we can arrange to meet for a free consultation. <br> |
| | codePrintPlain | | string | 461: <tr>462: <td valign="top" bgcolor="##FFFFFF" class="PageBody">463: <cfif retAgents.query.ProfileText EQ "">464: <p style="color:##000">465: Thank you for visiting #OurOrMy# site. These pages are intended to provide you with information on all aspects of Tulsa Real Estate. Use the links to find answers to any questions regarding our services or the process itself. Of course always feel free to Contact Me directly by phone and we can arrange to meet for a free consultation. |
| | column | | | id | | | line | | | raw_trace | | string | iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent._default_cfm$cf._call000948(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm:463) |
| | template | | string | \\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 319: </ul><br>320: <select name="Res_SQ_Foot" style="width:100%"><br><b>321: <option value="0" #IIF(SQ_Foot eq "0",DE("SELECTED"),DE("NOTSELECTED"))#>#APPLICATION.Stringlib.GetLabel("IQWeb_ALL")#</option></b><br>322: <cfloop from="500" to="5000" step="250" index="CurrSQFT"><br>323: <option value="#CurrSQFT#" #IIF(SQ_Foot eq CurrSQFT,DE("SELECTED"),DE("NOTSELECTED"))#>#CurrSQFT#+</option><br> |
| | codePrintPlain | | string | 319: </ul>320: <select name="Res_SQ_Foot" style="width:100%">321: <option value="0" #IIF(SQ_Foot eq "0",DE("SELECTED"),DE("NOTSELECTED"))#>#APPLICATION.Stringlib.GetLabel("IQWeb_ALL")#</option>322: <cfloop from="500" to="5000" step="250" index="CurrSQFT">323: <option value="#CurrSQFT#" #IIF(SQ_Foot eq CurrSQFT,DE("SELECTED"),DE("NOTSELECTED"))#>#CurrSQFT#+</option> |
| | column | | | id | | | line | | | raw_trace | | string | iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent._default_cfm$cf.call(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm:321) |
| | template | | string | \\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\_Default.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 87: <cfelse><br>88: <cfif FileExists("#REQUEST.CustomAbsolutePath#/_#LOCAL.PageName#.cfm")><br><b>89: <cfsavecontent variable="LOCAL.retVal"><cfinclude template="#REQUEST.CustomMapPath#/_#LOCAL.PageName#.cfm" /></cfsavecontent></b><br>90: <cfelse><br>91: <cfif FileExists("#REQUEST.AppAbsolutePath#/app/_#LOCAL.PageName#.cfm")><br> |
| | codePrintPlain | | string | 87: <cfelse>88: <cfif FileExists("#REQUEST.CustomAbsolutePath#/_#LOCAL.PageName#.cfm")>89: <cfsavecontent variable="LOCAL.retVal"><cfinclude template="#REQUEST.CustomMapPath#/_#LOCAL.PageName#.cfm" /></cfsavecontent>90: <cfelse>91: <cfif FileExists("#REQUEST.AppAbsolutePath#/app/_#LOCAL.PageName#.cfm")> |
| | column | | | id | | | line | | | raw_trace | | string | components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:89) |
| | template | | string | C:\realistiQ\WWWContent\_global\components\lib\iq.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 428: <div id="Site_Wrapper"><br>429: <div id="Site_Body"><br><b>430: #REQUEST.IQFramework.RenderPage()#</b><br>431: </div><br>432: </div><br> |
| | codePrintPlain | | string | 428: <div id="Site_Wrapper">429: <div id="Site_Body">430: #REQUEST.IQFramework.RenderPage()#431: </div>432: </div> |
| | column | | | id | | | line | | | raw_trace | | string | iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent.layouts._site_cfm$cf._call000078(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm:430) |
| | template | | string | \\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 358: <cfset ButtonNumber=++ButtonNumber><br>359: <br><b>360: <div class="MenubarButton" onMouseOver="Menu('#ButtonNumber#','On');" onMouseOut="Menu('#ButtonNumber#','Off');"></b><br>361: <div class="MenubarButtonTopLeft" id="ButtonTopLeft#ButtonNumber#"></div><br>362: <div class="MenubarButtonTopRight" id="ButtonTopRight#ButtonNumber#"></div><br> |
| | codePrintPlain | | string | 358: <cfset ButtonNumber=++ButtonNumber>359: 360: <div class="MenubarButton" onMouseOver="Menu('#ButtonNumber#','On');" onMouseOut="Menu('#ButtonNumber#','Off');">361: <div class="MenubarButtonTopLeft" id="ButtonTopLeft#ButtonNumber#"></div>362: <div class="MenubarButtonTopRight" id="ButtonTopRight#ButtonNumber#"></div> |
| | column | | | id | | | line | | | raw_trace | | string | iq_cb_premier_real_estate.sitetemplates.cb_premier_real_estate_agent.layouts._site_cfm$cf.call(\\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm:360) |
| | template | | string | \\content-2\content-2\iq_cb_premier_real_estate\SiteTemplates\CB_Premier_Real_Estate_Agent\Layouts\_Site.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 57: <cfelse><br>58: <cfif FileExists("#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm")><br><b>59: <cfsavecontent variable="LOCAL.retVal"><cfinclude template="#REQUEST.CustomMapPath#/layouts/_#LOCAL.Layout#.cfm" /></cfsavecontent></b><br>60: <cfelse><br>61: <cfset LOCAL.retVal = "<strong>File Not Found.</strong><br>The file &quot;<em>#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm</em>&quot; could not be found."><br> |
| | codePrintPlain | | string | 57: <cfelse>58: <cfif FileExists("#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm")>59: <cfsavecontent variable="LOCAL.retVal"><cfinclude template="#REQUEST.CustomMapPath#/layouts/_#LOCAL.Layout#.cfm" /></cfsavecontent>60: <cfelse>61: <cfset LOCAL.retVal = "<strong>File Not Found.</strong><br>The file "<em>#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm</em>" could not be found."> |
| | column | | | id | | | line | | | raw_trace | | string | components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:59) |
| | template | | string | C:\realistiQ\WWWContent\_global\components\lib\iq.cfc |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 34: </cfif><br>35: <br><b>36: <cfreturn doLayout()></b><br>37: </cfif><br>38: <br> |
| | codePrintPlain | | string | 34: </cfif>35: 36: <cfreturn doLayout()>37: </cfif>38: |
| | column | | | id | | | line | | | raw_trace | | string | components.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:36) |
| | template | | string | C:\realistiQ\WWWContent\_global\components\lib\iq.cfc |
| | type | |
| | 8 | | Struct | | codePrintHTML | | string | 333: include(ARGUMENTS.TargetPage);<br>334: }else{<br><b>335: writeOutput(REQUEST.iqLib.RenderContent());</b><br>336: }<br>337: }<br> |
| | codePrintPlain | | string | 333: include(ARGUMENTS.TargetPage);334: }else{335: writeOutput(REQUEST.iqLib.RenderContent());336: }337: } |
| | column | | | id | | | line | | | raw_trace | | string | application_cfc$cf.udfCall(C:\realistiQ\WWWContent\iqweb\application.cfc:335) |
| | template | | string | C:\realistiQ\WWWContent\iqweb\application.cfc |
| | type | |
|
| | type | | | where | |
|
