Error Occurred While Processing Request
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric.
The error occurred in C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 7 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_HotelFacilities.cfm: line 18 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 734 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 5 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 2 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel.cfm: line 61 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 7 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_HotelFacilities.cfm: line 18 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 734 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 5 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 2 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 1 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel.cfm: line 61
5 : ON a.cat_id = b.cat_id LEFT OUTER JOIN hotel_category_data c
6 : ON b.parent_id = c.cat_id
7 : WHERE a.hotel_id = '#qHotelInf.hotel_id#' AND b.cancel = '0' AND #Parent_ID_HotelFacilities#
8 : ORDER BY b.cat_name
9 : </CFQUERY>
SQL
SELECT a.hotel_id , a.cat_id ,b.cat_name As Cat_Name , b.parent_id , c.cat_name As Cat_NameGroup
FROM sirsiam.hotel_category a LEFT OUTER JOIN sirsiam.hotel_category_data b
ON a.cat_id = b.cat_id LEFT OUTER JOIN hotel_category_data c
ON b.parent_id = c.cat_id
WHERE a.hotel_id = '' AND b.cancel = '0' AND (b.parent_id = 89 OR b.parent_id = 70 OR b.parent_id = 71 OR b.parent_id = 72)
ORDER BY b.cat_name
Search the Knowledge Base to find a solution to your problem.
Browser
ColdFusion
Remote Address
192.168.11.28
Referrer
Date/Time
11-Jan-09 09:03 AM
Stack Trace
at cfinc2dHotelFacilities2ecfm1057930966._factor13(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:7)
at cfinc2dHotelFacilities2ecfm1057930966._factor14(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:1)
at cfinc2dHotelFacilities2ecfm1057930966.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:1)
at cftemplate_hotel_info_inc_HotelFacilities2ecfm911145428.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_HotelFacilities.cfm:18)
at cftemplate_hotel_info2ecfm1192434897._factor14(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:734)
at cftemplate_hotel_info2ecfm1192434897._factor15(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:5)
at cftemplate_hotel_info2ecfm1192434897._factor16(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:2)
at cftemplate_hotel_info2ecfm1192434897.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:1)
at cftemplate_hotel2ecfm99120151.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel.cfm:61)
at cfinc2dHotelFacilities2ecfm1057930966._factor13(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:7)
at cfinc2dHotelFacilities2ecfm1057930966._factor14(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:1)
at cfinc2dHotelFacilities2ecfm1057930966.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:1)
at cftemplate_hotel_info_inc_HotelFacilities2ecfm911145428.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_HotelFacilities.cfm:18)
at cftemplate_hotel_info2ecfm1192434897._factor14(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:734)
at cftemplate_hotel_info2ecfm1192434897._factor15(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:5)
at cftemplate_hotel_info2ecfm1192434897._factor16(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:2)
at cftemplate_hotel_info2ecfm1192434897.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:1)
at cftemplate_hotel2ecfm99120151.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel.cfm:61)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric.
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.tds.TDSRequest.getRow(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java:287)
at coldfusion.sql.QueryTable.populate(QueryTable.java:216)
at coldfusion.sql.Executive.getRowSet(Executive.java:311)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfinc2dHotelFacilities2ecfm1057930966._factor13(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:7)
at cfinc2dHotelFacilities2ecfm1057930966._factor14(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.cfm:1)
at cfinc2dHotelFacilities2ecfm1057930966.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\inc-HotelFacilities.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 cftemplate_hotel_info_inc_HotelFacilities2ecfm911145428.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_HotelFacilities.cfm:18)
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 cftemplate_hotel_info2ecfm1192434897._factor14(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:734)
at cftemplate_hotel_info2ecfm1192434897._factor15(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:5)
at cftemplate_hotel_info2ecfm1192434897._factor16(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:2)
at cftemplate_hotel_info2ecfm1192434897.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.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 cftemplate_hotel2ecfm99120151.runPage(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel.cfm:61)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
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.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)