Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY entrydatetime desc),Count(EntryID) OVER() AS TotalRowCount,Blogs_Entries.*,Agents.firstname,Agents.lastnameFROM Blogs_Entries WITH (NOLOCK)INNER JOIN Agents WITH (NOLOCK)ON Blogs_Entries.EntryPostedByPublicID = Agents.PublicIDWHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2')and EntryDateTime <= {d '2017-05-28'}and blogs_entries.status = 'A'and EntryID IN (SELECT EntryID FROM Blogs_Categories WHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2') and CategoryName = 'USDA')) dtDataWHERE dtData.RowNumber BETWEEN 1 and 5
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string12.00.2000
DriverName
stringjTDS Type 4 JDBC Driver for MS SQL Server and Sybase
DriverVersion
string1.3.1
Datasource
stringiq_cb_select
DataSource
stringiq_cb_select
Detail
stringConversion failed when converting the nvarchar value '0f5763f6-9afc-219d-0a9fce0e7993b2e2' to data type int.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number245
queryError
stringSELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY entrydatetime desc),Count(EntryID) OVER() AS TotalRowCount,Blogs_Entries.*,Agents.firstname,Agents.lastnameFROM Blogs_Entries WITH (NOLOCK)INNER JOIN Agents WITH (NOLOCK)ON Blogs_Entries.EntryPostedByPublicID = Agents.PublicIDWHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2')and EntryDateTime <= {d '2017-05-28'}and blogs_entries.status = 'A'and EntryID IN (SELECT EntryID FROM Blogs_Categories WHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2') and CategoryName = 'USDA')) dtDataWHERE dtData.RowNumber BETWEEN 1 and 5
Sql
stringSELECT *FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY entrydatetime desc),Count(EntryID) OVER() AS TotalRowCount,Blogs_Entries.*,Agents.firstname,Agents.lastnameFROM Blogs_Entries WITH (NOLOCK)INNER JOIN Agents WITH (NOLOCK)ON Blogs_Entries.EntryPostedByPublicID = Agents.PublicIDWHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2')and EntryDateTime <= {d '2017-05-28'}and blogs_entries.status = 'A'and EntryID IN (SELECT EntryID FROM Blogs_Categories WHERE blogid in ('0f5763f6-9afc-219d-0a9fce0e7993b2e2') and CategoryName = 'USDA')) dtDataWHERE dtData.RowNumber BETWEEN 1 and 5
SQLState
string22018
StackTrace
stringlucee.runtime.exp.DatabaseException: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:838)at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:149)at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:682)at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784)at com.intergral.fusionreactor.jdbc.jdbc42.PreparedStatementSurrogate2.execute(PreparedStatementSurrogate2.java:200)at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:275)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:221)at lucee.runtime.tag.Query.executeDatasoure(Query.java:864)at lucee.runtime.tag.Query.doEndTag(Query.java:622)at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:84)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:247)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:758)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1701)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.blog_cfc$cf.udfCall(/components/blog.cfc:108)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1931)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at iqweb.app._rss_cfm$cf.call(/iqapp_mappath/iqweb/app/_rss.cfm:37)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:928)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:842)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:826)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:758)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1701)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:57)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:758)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1701)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:758)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1701)at application_cfc$cf.udfCall(/Application.cfc:265)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:420)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:222)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2408)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2398)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2366)at lucee.runtime.engine.Request.run(Request.java:34)
TagContext
Array
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number247
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:247)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:141)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string106: ) dtData<br>107: WHERE dtData.RowNumber BETWEEN #local.StartRow# and #local.EndRow#<br><b>108: &lt;/cfiqquery&gt;</b><br>109: <br>110: &lt;/cfoutput&gt;<br>
codePrintPlain
string106: ) dtData107: WHERE dtData.RowNumber BETWEEN #local.StartRow# and #local.EndRow#108: </cfiqquery>109: 110: </cfoutput>
column
number0
id
string??
line
number108
Raw_Trace
stringcomponents.blog_cfc$cf.udfCall(/components/blog.cfc:108)
template
stringC:\realistiq\production\iqweb\components\blog.cfc
type
stringcfml
4
Struct
codePrintHTML
string35: &lt;cfinvokeargument name=&quot;StartPage&quot; value=&quot;#request.StartPage#&quot;&gt;<br>36: &lt;cfinvokeargument name=&quot;MaxRows&quot; value=&quot;#request.MaxRows#&quot;&gt;<br><b>37: &lt;/cfinvoke&gt;</b><br>38: <br>39: &lt;cfif retEntries.Status EQ 1&gt;<br>
codePrintPlain
string35: <cfinvokeargument name="StartPage" value="#request.StartPage#">36: <cfinvokeargument name="MaxRows" value="#request.MaxRows#">37: </cfinvoke>38: 39: <cfif retEntries.Status EQ 1>
column
number0
id
string??
line
number37
Raw_Trace
stringiqweb.app._rss_cfm$cf.call(/iqapp_mappath/iqweb/app/_rss.cfm:37)
template
stringC:\realistiq\production\iqweb\app\_rss.cfm
type
stringcfml
5
Struct
codePrintHTML
string80: <br>81: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>82: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>83: &lt;cfelse&gt;<br>84: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string80: 81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />83: <cfelse>84: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number82
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
6
Struct
codePrintHTML
string55: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br>56: &lt;cfscript&gt;<br><b>57: RenderPage();</b><br>58: &lt;/cfscript&gt;<br>59: &lt;cfelse&gt;<br>
codePrintPlain
string55: <cfif local.Layout EQ "none">56: <cfscript>57: RenderPage();58: </cfscript>59: <cfelse>
column
number0
id
string??
line
number57
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:57)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
7
Struct
codePrintHTML
string40: <br>41: &lt;cfscript&gt;<br><b>42: doLayout();</b><br>43: &lt;/cfscript&gt;<br>44: &lt;/cfif&gt;<br>
codePrintPlain
string40: 41: <cfscript>42: doLayout();43: </cfscript>44: </cfif>
column
number0
id
string??
line
number42
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string263: local.url.process(cgi.path_info);<br>264: <br><b>265: writeOutput(request.iqLib.RenderContent());</b><br>266: }<br>267: }<br>
codePrintPlain
string263: local.url.process(cgi.path_info);264: 265: writeOutput(request.iqLib.RenderContent());266: }267: }
column
number0
id
string??
line
number265
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:265)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string