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_jp.cfc: line 142
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 11
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 4
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 1
Called from E:\template.hotelthailand.com\class\hotel_jp.cfc: line 142
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 11
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 4
Called from E:\template.hotelthailand.com\hotel_index.cfm: line 1
140 : AND hm.l_rate = 3
141 : AND hv.site3 = 1
142 : AND ht.hotel_id = #val(hotelId)#
143 : </CFQUERY>
144 :

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 = 8525
DATASOURCE   hotel_static
VENDORERRORCODE   208
SQLSTATE   42S02
Resources:

Browser   ColdFusion
Remote Address   192.168.11.43
Referrer  
Date/Time   17-Jul-15 06:32 AM
Stack Trace
at cfhotel_jp2ecfc1644882636$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_jp.cfc:142) at cfhotel_index2ecfm1699292198._factor0(E:\template.hotelthailand.com\hotel_index.cfm:11) at cfhotel_index2ecfm1699292198._factor13(E:\template.hotelthailand.com\hotel_index.cfm:4) at cfhotel_index2ecfm1699292198.runPage(E:\template.hotelthailand.com\hotel_index.cfm:1) at cfhotel_jp2ecfc1644882636$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_jp.cfc:142) at cfhotel_index2ecfm1699292198._factor0(E:\template.hotelthailand.com\hotel_index.cfm:11) at cfhotel_index2ecfm1699292198._factor13(E:\template.hotelthailand.com\hotel_index.cfm:4) at cfhotel_index2ecfm1699292198.runPage(E:\template.hotelthailand.com\hotel_index.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 cfhotel_jp2ecfc1644882636$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_jp.cfc:142)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_index2ecfm1699292198._factor0(E:\template.hotelthailand.com\hotel_index.cfm:11)at cfhotel_index2ecfm1699292198._factor13(E:\template.hotelthailand.com\hotel_index.cfm:4)at cfhotel_index2ecfm1699292198.runPage(E:\template.hotelthailand.com\hotel_index.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)