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\Get_rooms_picture.cfm: line 111 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_Rates.cfm: line 51 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 722 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\Get_rooms_picture.cfm: line 111 Called from C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_Rates.cfm: line 51 Called from C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm: line 722 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
109 : ON a.cat_id = b.cat_id LEFT OUTER JOIN hotel_category_data c
110 : ON b.parent_id = c.cat_id
111 : WHERE a.hotel_id = '#qHotelInf.hotel_id#' AND b.cancel = '0' AND #Parent_ID_Rooms#
112 : ORDER BY b.cat_name
113 : </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 = 1)
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 cfGet_rooms_picture2ecfm2112935185.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\Get_rooms_picture.cfm:111)
at cftemplate_hotel_info_inc_Rates2ecfm654919474.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_Rates.cfm:51)
at cftemplate_hotel_info2ecfm1192434897._factor14(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:722)
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 cfGet_rooms_picture2ecfm2112935185.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\Get_rooms_picture.cfm:111)
at cftemplate_hotel_info_inc_Rates2ecfm654919474.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_Rates.cfm:51)
at cftemplate_hotel_info2ecfm1192434897._factor14(C:\Inetpub\wwwroot\hotelthailand_new\template_hotel_info.cfm:722)
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 cfGet_rooms_picture2ecfm2112935185.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\Get_rooms_picture.cfm:111)
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_Rates2ecfm654919474.runPage(C:\Inetpub\wwwroot\hotelthailand_new\System_Library\Include\template_hotel_info_inc_Rates.cfm:51)
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:722)
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)