Database error in get_table_records - DS: www_freedomcontracts_com_2
Attributes
| struct |
|---|
| APPCACHETIMEOUT |
0
|
| CRITERIA |
bt.unique_record_id in ( )
|
| FIELDS |
category,importance,unique_record_id,cfr_draft,cfr_deleted,cfr_created,cfr_version,cfr_lastupdate,cfr_createdby,cfr_changedby,cfr_checkedout,cfr_checkedoutby,cfr_checkedouttime,cfr_workflowid,cfr_seotitle
|
| FILTER |
[empty string]
|
| FORCEDSORTORDER |
[empty string]
|
| GETALLFIELDS |
false
|
| GETCHILDDATA |
false
|
| INCLUDEDELETED |
false
|
| INCLUDEDRAFT |
true
|
| KEYFIELD |
unique_record_id
|
| MAXROWS |
999999
|
| NESTED |
false
|
| NEWBLANKCOLUMNS |
[empty string]
|
| NEWBLANKCOLUMNSNUMERIC |
[empty string]
|
| PARENTTABLE |
[empty string]
|
| RANDOMRESULTS |
0
|
| RELATE |
true
|
| RETURNASSTRUCTURE |
false
|
| STRUCTUREKEYFIELD |
unique_record_id
|
| TABLE |
categories
|
Join command
select bt.unique_record_id
, bt.importance
, bt.category
, bt.cfr_draft
, bt.cfr_deleted
, bt.cfr_created
, bt.cfr_version
, bt.cfr_lastupdate
, bt.cfr_createdby
, bt.cfr_changedby
, bt.cfr_checkedout
, bt.cfr_checkedoutby
, bt.cfr_checkedouttime
, bt.cfr_workflowid
, bt.cfr_seotitle,bt.cfr_draft, -1 as cfr_parentID, '' as cfr_parentTable
FROM categories as bt where 1=1
AND ( bt.cfr_deleted = 0 )
and (bt.unique_record_id in ( ))
order by bt.importance desc,bt.category
Related fields
| query - Top 0 of 0 Rows |
|---|
| |
FIELDNAME | LISTFIELDS | RELATEDTABLE |
Relations
Base fields
bt.unique_record_id
, bt.importance
, bt.category
, bt.cfr_draft
, bt.cfr_deleted
, bt.cfr_created
, bt.cfr_version
, bt.cfr_lastupdate
, bt.cfr_createdby
, bt.cfr_changedby
, bt.cfr_checkedout
, bt.cfr_checkedoutby
, bt.cfr_checkedouttime
, bt.cfr_workflowid
, bt.cfr_seotitle
| struct |
|---|
| DataSource |
www_freedomcontracts_com_2
|
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| ErrorCode |
HY000
|
| Message |
Error Executing Database Query.
|
| NativeErrorCode |
102
|
| RootCause |
| struct |
|---|
| ErrorCode |
102
|
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| SQLState |
HY000
|
| StackTrace |
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:775)
at coldfusion.sql.Executive.executeQuery(Executive.java:685)
at coldfusion.sql.Executive.executeQuery(Executive.java:646)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfqry_get_table_records_v22ecfm138343302._factor13(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:466)
at cfqry_get_table_records_v22ecfm138343302._factor14(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:154)
at cfqry_get_table_records_v22ecfm138343302._factor18(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:101)
at cfqry_get_table_records_v22ecfm138343302._factor21(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:65)
at cfqry_get_table_records_v22ecfm138343302.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfqry_get_table_records2ecfm254350810._factor19(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:2)
at cfqry_get_table_records2ecfm254350810.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
at cfCMSFunction2ecfm276314163._factor48(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:356)
at cfCMSFunction2ecfm276314163._factor6(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor57(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:318)
at cfCMSFunction2ecfm276314163._factor8(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor61(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:316)
at cfCMSFunction2ecfm276314163._factor9(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor152(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:301)
at cfCMSFunction2ecfm276314163.runPage(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
at cfdsp_vehicles2ecfm15935513._factor9(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:46)
at cfdsp_vehicles2ecfm15935513._factor12(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:41)
at cfdsp_vehicles2ecfm15935513.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfrssoffer2ecfm1917972074.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm:34)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:239)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:180)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
466
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor13(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:466)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
154
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor14(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:154)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
101
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor18(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:101)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
65
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor21(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:65)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
1
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 6 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
2
|
| RAW_TRACE |
at cfqry_get_table_records2ecfm254350810._factor19(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:2)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm
|
| TYPE |
CFML
|
|
| 7 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS
|
| LINE |
1
|
| RAW_TRACE |
at cfqry_get_table_records2ecfm254350810.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm
|
| TYPE |
CFML
|
|
| 8 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFMODULE
|
| LINE |
356
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor48(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:356)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 9 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor6(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 10 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
318
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor57(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:318)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 11 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor8(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 12 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
316
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor61(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:316)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 13 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor9(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 14 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
301
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor152(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:301)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 15 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163.runPage(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 16 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFMODULE
|
| LINE |
46
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513._factor9(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:46)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 17 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_DSP_VEHICLES
|
| LINE |
41
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513._factor12(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:41)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 18 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_DSP_VEHICLES
|
| LINE |
1
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 19 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
34
|
| RAW_TRACE |
at cfrssoffer2ecfm1917972074.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm:34)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm
|
| TYPE |
CFML
|
|
| 20 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
239
|
| RAW_TRACE |
at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:239)
|
| TEMPLATE |
W:\WebRoot\CMS\Application_normal.cfc
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLException
|
|
| SQLState |
HY000
|
| Sql |
select bt.unique_record_id
, bt.importance
, bt.category
, bt.cfr_draft
, bt.cfr_deleted
, bt.cfr_created
, bt.cfr_version
, bt.cfr_lastupdate
, bt.cfr_createdby
, bt.cfr_changedby
, bt.cfr_checkedout
, bt.cfr_checkedoutby
, bt.cfr_checkedouttime
, bt.cfr_workflowid
, bt.cfr_seotitle,bt.cfr_draft, -1 as cfr_parentID, '' as cfr_parentTable FROM categories as bt where 1=1
AND ( bt.cfr_deleted = 0 )
and (bt.unique_record_id in ( ))
order by bt.importance desc,bt.category
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
at cfqry_get_table_records_v22ecfm138343302._factor13(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:466)
at cfqry_get_table_records_v22ecfm138343302._factor14(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:154)
at cfqry_get_table_records_v22ecfm138343302._factor18(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:101)
at cfqry_get_table_records_v22ecfm138343302._factor21(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:65)
at cfqry_get_table_records_v22ecfm138343302.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfqry_get_table_records2ecfm254350810._factor19(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:2)
at cfqry_get_table_records2ecfm254350810.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
at cfCMSFunction2ecfm276314163._factor48(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:356)
at cfCMSFunction2ecfm276314163._factor6(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor57(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:318)
at cfCMSFunction2ecfm276314163._factor8(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor61(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:316)
at cfCMSFunction2ecfm276314163._factor9(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
at cfCMSFunction2ecfm276314163._factor152(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:301)
at cfCMSFunction2ecfm276314163.runPage(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
at cfdsp_vehicles2ecfm15935513._factor9(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:46)
at cfdsp_vehicles2ecfm15935513._factor12(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:41)
at cfdsp_vehicles2ecfm15935513.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfrssoffer2ecfm1917972074.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm:34)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:239)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:180)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
466
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor13(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:466)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
154
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor14(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:154)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
101
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor18(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:101)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
65
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302._factor21(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:65)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS_V2
|
| LINE |
1
|
| RAW_TRACE |
at cfqry_get_table_records_v22ecfm138343302.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records_v2.cfm
|
| TYPE |
CFML
|
|
| 6 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
2
|
| RAW_TRACE |
at cfqry_get_table_records2ecfm254350810._factor19(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:2)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm
|
| TYPE |
CFML
|
|
| 7 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_QRY_GET_TABLE_RECORDS
|
| LINE |
1
|
| RAW_TRACE |
at cfqry_get_table_records2ecfm254350810.runPage(W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\qry_get_table_records.cfm
|
| TYPE |
CFML
|
|
| 8 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFMODULE
|
| LINE |
356
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor48(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:356)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 9 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor6(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 10 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
318
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor57(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:318)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 11 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor8(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 12 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
316
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor61(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:316)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 13 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
-1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor9(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm)
|
| TEMPLATE |
W
|
| TYPE |
CFML
|
|
| 14 |
| struct |
|---|
| COLUMN |
0
|
| ID |
W
|
| LINE |
301
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163._factor152(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:301)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 15 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_CMSFUNCTION
|
| LINE |
1
|
| RAW_TRACE |
at cfCMSFunction2ecfm276314163.runPage(W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\contentmanagement\customtags\CMSFunction.cfm
|
| TYPE |
CFML
|
|
| 16 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFMODULE
|
| LINE |
46
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513._factor9(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:46)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 17 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_DSP_VEHICLES
|
| LINE |
41
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513._factor12(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:41)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 18 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_DSP_VEHICLES
|
| LINE |
1
|
| RAW_TRACE |
at cfdsp_vehicles2ecfm15935513.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm:1)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\_includes\dsp_vehicles.cfm
|
| TYPE |
CFML
|
|
| 19 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
34
|
| RAW_TRACE |
at cfrssoffer2ecfm1917972074.runPage(W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm:34)
|
| TEMPLATE |
W:\WebRoot\CMS\_site_data\www.freedomcontracts.com\site\contract_hire_leasing_pch_pcp_offers\rssoffer.cfm
|
| TYPE |
CFML
|
|
| 20 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
239
|
| RAW_TRACE |
at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:239)
|
| TEMPLATE |
W:\WebRoot\CMS\Application_normal.cfc
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| where |
[empty string]
|
ENSURE THAT UNIQUE_RECORD_ID EXISTS IN ALL RELATED TABLES