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]Transaction (Process ID 96) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in E:\template.hotelthailand.com\Application.cfm: line 71
 
69 : --->
70 : <CFSET ListCityPromoWifi = "4,70,21,38,5,44">
71 : <CFQUERY NAME="qCyberpoint" DATASOURCE="#xDSN#" USERNAME="#dbuser#" PASSWORD="#dbpasswd#">
72 : SELECT hotel_id, cyberpoint
73 : FROM hotel
SQL    SELECT hotel_id, cyberpoint FROM hotel WHERE cyberpoint = 1
DATASOURCE   panet02
VENDORERRORCODE   1205
SQLSTATE   40001
Resources:

Browser   ColdFusion
Remote Address   192.168.11.43
Referrer  
Date/Time   06-Nov-08 05:13 PM
Stack Trace
at cfApplication2ecfm2080212224.runPage(E:\template.hotelthailand.com\Application.cfm:71) at cfApplication2ecfm2080212224.runPage(E:\template.hotelthailand.com\Application.cfm:71) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 96) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.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 cfApplication2ecfm2080212224.runPage(E:\template.hotelthailand.com\Application.cfm:71)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.CfincludeFilter.include(CfincludeFilter.java:33)at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:172)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)