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_ch.cfc: line 141
Called from E:\template.hotelthailand.com\hotel_gallery.cfm: line 20
Called from E:\template.hotelthailand.com\class\hotel_ch.cfc: line 141
Called from E:\template.hotelthailand.com\hotel_gallery.cfm: line 20
 
139 : AND hm.l_rate = 3
140 : AND hv.site3 = 1
141 : AND ht.hotel_id = #val(hotelId)#
142 : </CFQUERY>
143 :
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 = 999
DATASOURCE   hotel_static
VENDORERRORCODE   208
SQLSTATE   42S02
Resources:

Browser   ColdFusion
Remote Address   192.168.11.44
Referrer  
Date/Time   26-Nov-09 04:20 PM
Stack Trace
at cfhotel_ch2ecfc1852322351$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_ch.cfc:141) at cfhotel_gallery2ecfm241036326.runPage(E:\template.hotelthailand.com\hotel_gallery.cfm:20) at cfhotel_ch2ecfc1852322351$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_ch.cfc:141) at cfhotel_gallery2ecfm241036326.runPage(E:\template.hotelthailand.com\hotel_gallery.cfm:20) 

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_ch2ecfc1852322351$funcSETID.runFunction(E:\template.hotelthailand.com\class\hotel_ch.cfc:141)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_gallery2ecfm241036326.runPage(E:\template.hotelthailand.com\hotel_gallery.cfm:20)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)