Search:

Map of the Caribbean

Caribbean bargains from £ pp!

Unwind on the beautiful islands of the Caribbean with our fantastic tropical holiday deals. Prices from just £pp. Choose from destinations including the Bahamas, St Lucia, Grenada and more...

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]Incorrect syntax near ')'.

The error occurred in \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 244
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 220
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 1
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 244
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 220
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm: line 1

242 : 			SELECT name as rName, regioncode
243 : 			FROM region
244 : 			WHERE regionCode in (#preserveSingleQuotes(regionList)#)
245 : 			ORDER BY rName ASC
246 : 		</cfquery>

SQL	SELECT name as rName, regioncode FROM region WHERE regionCode in () ORDER BY rName ASC
DATASOURCE	tropical
VENDORERRORCODE	102
SQLSTATE	HY000

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address	38.107.191.119
Referrer
Date/Time	12-Mar-10 04:03 PM

Stack Trace

at cfcaribbean_holiday_offers2ecfm903644813._factor4(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:244) at cfcaribbean_holiday_offers2ecfm903644813._factor7(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:220) at cfcaribbean_holiday_offers2ecfm903644813.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:1) at cfcaribbean_holiday_offers2ecfm903644813._factor4(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:244) at cfcaribbean_holiday_offers2ecfm903644813._factor7(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:220) at cfcaribbean_holiday_offers2ecfm903644813.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	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 cfcaribbean_holiday_offers2ecfm903644813._factor4(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:244)
	at cfcaribbean_holiday_offers2ecfm903644813._factor7(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.cfm:220)
	at cfcaribbean_holiday_offers2ecfm903644813.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\caribbean_holiday_offers.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)