Hotel in: Home » Hotels »

Hotel
Hotels ,

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\europehotelsonline.com\System_Library\Include\hotel_info_inc_Rooms.cfm: line 17
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 332
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 2
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 1
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel.cfm: line 50
Called from C:\Inetpub\wwwroot\europehotelsonline.com\System_Library\Include\hotel_info_inc_Rooms.cfm: line 17
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 332
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 2
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm: line 1
Called from C:\Inetpub\wwwroot\europehotelsonline.com\hotel.cfm: line 50
 
15 : ON a.cat_id = b.cat_id LEFT OUTER JOIN hotel_category_data c
16 : ON b.parent_id = c.cat_id
17 : WHERE a.hotel_id = '#qHotelInf.hotel_id#' AND b.cancel = '0' AND #Parent_ID#
18 : ORDER BY b.cat_name 
19 : </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
DATASOURCE   panet01
VENDORERRORCODE   8114
SQLSTATE   HY000
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.60
Referrer  
Date/Time   20-Nov-08 03:15 PM
Stack Trace
at cfhotel_info_inc_Rooms2ecfm1683599702.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\System_Library\Include\hotel_info_inc_Rooms.cfm:17) at cfhotel_info2ecfm688962718._factor7(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:332) at cfhotel_info2ecfm688962718._factor8(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:2) at cfhotel_info2ecfm688962718.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:1) at cfhotel2ecfm1225189543.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\hotel.cfm:50) at cfhotel_info_inc_Rooms2ecfm1683599702.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\System_Library\Include\hotel_info_inc_Rooms.cfm:17) at cfhotel_info2ecfm688962718._factor7(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:332) at cfhotel_info2ecfm688962718._factor8(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:2) at cfhotel_info2ecfm688962718.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:1) at cfhotel2ecfm1225189543.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\hotel.cfm:50) 

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 cfhotel_info_inc_Rooms2ecfm1683599702.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\System_Library\Include\hotel_info_inc_Rooms.cfm:17)
	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 cfhotel_info2ecfm688962718._factor7(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:332)
	at cfhotel_info2ecfm688962718._factor8(C:\Inetpub\wwwroot\europehotelsonline.com\hotel_info.cfm:2)
	at cfhotel_info2ecfm688962718.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\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 cfhotel2ecfm1225189543.runPage(C:\Inetpub\wwwroot\europehotelsonline.com\hotel.cfm:50)
	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.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)