Catch
Entries:14
additional
Struct
SQL
stringSELECT *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
string
Detail
string
ErrorCode
string0
ExtendedInfo
string
Message
stringcolumn [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
number-1
queryError
stringSELECT *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
stringSELECT *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
string
StackTrace
stringcolumn [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
string461: &lt;tr&gt;<br>462: &lt;td valign=&quot;top&quot; bgcolor=&quot;##FFFFFF&quot; class=&quot;PageBody&quot;&gt;<br><b>463: &lt;cfif retAgents.query.ProfileText EQ &quot;&quot;&gt;</b><br>464: &lt;p style=&quot;color:##000&quot;&gt;<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
string461: <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
number0
id
string??
line
number463
raw_trace
stringiq_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
stringcfml
2
Struct
codePrintHTML
string319: &lt;/ul&gt;<br>320: &lt;select name=&quot;Res_SQ_Foot&quot; style=&quot;width:100%&quot;&gt;<br><b>321: &lt;option value=&quot;0&quot; #IIF(SQ_Foot eq &quot;0&quot;,DE(&quot;SELECTED&quot;),DE(&quot;NOTSELECTED&quot;))#&gt;#APPLICATION.Stringlib.GetLabel(&quot;IQWeb_ALL&quot;)#&lt;/option&gt;</b><br>322: &lt;cfloop from=&quot;500&quot; to=&quot;5000&quot; step=&quot;250&quot; index=&quot;CurrSQFT&quot;&gt;<br>323: &lt;option value=&quot;#CurrSQFT#&quot; #IIF(SQ_Foot eq CurrSQFT,DE(&quot;SELECTED&quot;),DE(&quot;NOTSELECTED&quot;))#&gt;#CurrSQFT#+&lt;/option&gt;<br>
codePrintPlain
string319: </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
number0
id
string??
line
number321
raw_trace
stringiq_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
stringcfml
3
Struct
codePrintHTML
string87: &lt;cfelse&gt;<br>88: &lt;cfif FileExists(&quot;#REQUEST.CustomAbsolutePath#/_#LOCAL.PageName#.cfm&quot;)&gt;<br><b>89: &lt;cfsavecontent variable=&quot;LOCAL.retVal&quot;&gt;&lt;cfinclude template=&quot;#REQUEST.CustomMapPath#/_#LOCAL.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>90: &lt;cfelse&gt;<br>91: &lt;cfif FileExists(&quot;#REQUEST.AppAbsolutePath#/app/_#LOCAL.PageName#.cfm&quot;)&gt;<br>
codePrintPlain
string87: <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
number0
id
string??
line
number89
raw_trace
stringcomponents.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:89)
template
stringC:\realistiQ\WWWContent\_global\components\lib\iq.cfc
type
stringcfml
4
Struct
codePrintHTML
string428: &lt;div id=&quot;Site_Wrapper&quot;&gt;<br>429: &lt;div id=&quot;Site_Body&quot;&gt;<br><b>430: #REQUEST.IQFramework.RenderPage()#</b><br>431: &lt;/div&gt;<br>432: &lt;/div&gt;<br>
codePrintPlain
string428: <div id="Site_Wrapper">429: <div id="Site_Body">430: #REQUEST.IQFramework.RenderPage()#431: </div>432: </div>
column
number0
id
string??
line
number430
raw_trace
stringiq_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
stringcfml
5
Struct
codePrintHTML
string358: &lt;cfset ButtonNumber=++ButtonNumber&gt;<br>359: <br><b>360: &lt;div class=&quot;MenubarButton&quot; onMouseOver=&quot;Menu('#ButtonNumber#','On');&quot; onMouseOut=&quot;Menu('#ButtonNumber#','Off');&quot;&gt;</b><br>361: &lt;div class=&quot;MenubarButtonTopLeft&quot; id=&quot;ButtonTopLeft#ButtonNumber#&quot;&gt;&lt;/div&gt;<br>362: &lt;div class=&quot;MenubarButtonTopRight&quot; id=&quot;ButtonTopRight#ButtonNumber#&quot;&gt;&lt;/div&gt;<br>
codePrintPlain
string358: <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
number0
id
string??
line
number360
raw_trace
stringiq_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
stringcfml
6
Struct
codePrintHTML
string57: &lt;cfelse&gt;<br>58: &lt;cfif FileExists(&quot;#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm&quot;)&gt;<br><b>59: &lt;cfsavecontent variable=&quot;LOCAL.retVal&quot;&gt;&lt;cfinclude template=&quot;#REQUEST.CustomMapPath#/layouts/_#LOCAL.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>60: &lt;cfelse&gt;<br>61: &lt;cfset LOCAL.retVal = &quot;&lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.&quot;&gt;<br>
codePrintPlain
string57: <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 &quot;<em>#REQUEST.CustomAbsolutePath#/layouts/_#LOCAL.Layout#.cfm</em>&quot; could not be found.">
column
number0
id
string??
line
number59
raw_trace
stringcomponents.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:59)
template
stringC:\realistiQ\WWWContent\_global\components\lib\iq.cfc
type
stringcfml
7
Struct
codePrintHTML
string34: &lt;/cfif&gt;<br>35: <br><b>36: &lt;cfreturn doLayout()&gt;</b><br>37: &lt;/cfif&gt;<br>38: <br>
codePrintPlain
string34: </cfif>35: 36: <cfreturn doLayout()>37: </cfif>38:
column
number0
id
string??
line
number36
raw_trace
stringcomponents.lib.iq_cfc$cf.udfCall1(C:\realistiQ\WWWContent\_global\components\lib\iq.cfc:36)
template
stringC:\realistiQ\WWWContent\_global\components\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string333: include(ARGUMENTS.TargetPage);<br>334: }else{<br><b>335: writeOutput(REQUEST.iqLib.RenderContent());</b><br>336: }<br>337: }<br>
codePrintPlain
string333: include(ARGUMENTS.TargetPage);334: }else{335: writeOutput(REQUEST.iqLib.RenderContent());336: }337: }
column
number0
id
string??
line
number335
raw_trace
stringapplication_cfc$cf.udfCall(C:\realistiQ\WWWContent\iqweb\application.cfc:335)
template
stringC:\realistiQ\WWWContent\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string
Maria Cieri - CB Premier Real Estate Real Estate
Maria Cieri - CB Premier Real Estate Real Estate