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]Invalid object name 'Passionasia_com.sirsiam.currency'.
 
The error occurred in E:\template.hotelthailand.com\class\hotel.cfc: line 104
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 23
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 4
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 1
Called from E:\template.hotelthailand.com\class\hotel.cfc: line 104
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 23
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 4
Called from E:\template.hotelthailand.com\hotel_room.cfm: line 1
102 : AND hm.l_rate = 3
103 : AND hv.site3 = 1
104 : AND ht.hotel_id = #val(hotelId)#
105 : </CFQUERY>
106 :

SQL   SELECT hm.min_rate/cc.perUSD*obj.perUSD AS min_rate, 'THB' AS currency_abbrFROM Passionasia_com.sirsiam.hotel ht, Passionasia_com.sirsiam.hotel_min_max hm, Passionasia_com.sirsiam.hotel_validity hv, Passionasia_com.sirsiam.currency cc, (SELECT perUSDFROM Passionasia_com.sirsiam.currencyWHERE currency_abbr = 'THB') objWHERE ht.tmp_min_valid_id = hm.valid_idAND hm.valid_id = hv.valid_idAND hv.currency_id = cc.currency_idAND isNull(ht.cancel, 0) = 0AND hm.l_rate = 3AND hv.site3 = 1AND ht.hotel_id = 29256
DATASOURCE   hotel_static
VENDORERRORCODE   208
SQLSTATE   42S02
Resources:

Browser   ColdFusion
Remote Address   192.168.11.112
Referrer  
Date/Time   17-Jul-15 05:38 AM
Stack Trace
at cfhotel2ecfc1114226710$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel.cfc:104) at cfhotel_room2ecfm351902988._factor0(E:\template.hotelthailand.com\hotel_room.cfm:23) at cfhotel_room2ecfm351902988._factor7(E:\template.hotelthailand.com\hotel_room.cfm:4) at cfhotel_room2ecfm351902988.runPage(E:\template.hotelthailand.com\hotel_room.cfm:1) at cfhotel2ecfc1114226710$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel.cfc:104) at cfhotel_room2ecfm351902988._factor0(E:\template.hotelthailand.com\hotel_room.cfm:23) at cfhotel_room2ecfm351902988._factor7(E:\template.hotelthailand.com\hotel_room.cfm:4) at cfhotel_room2ecfm351902988.runPage(E:\template.hotelthailand.com\hotel_room.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'Passionasia_com.sirsiam.currency'.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: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 cfhotel2ecfc1114226710$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel.cfc:104)at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)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.CfJspPage._invoke(CfJspPage.java:1634)at cfhotel_room2ecfm351902988._factor0(E:\template.hotelthailand.com\hotel_room.cfm:23)at cfhotel_room2ecfm351902988._factor7(E:\template.hotelthailand.com\hotel_room.cfm:4)at cfhotel_room2ecfm351902988.runPage(E:\template.hotelthailand.com\hotel_room.cfm:1)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)