Last Minute Holidays:

Depart within 14 days
Depart in 14 to 28 days

Don't know where to go?

Take a look at our country information pages to find out more about the individual countries and names.

Fantastic tropical deals:

For great holiday ideas and our selection of the best offers around, view our fantastic tropical holiday deals.

Last minute holidays departing within the next 14 days

Get away to the tropical sunshine now with our fantastic tropical holiday offers departing within the next 14 days.

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]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
 
The error occurred in \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 229
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 216
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 172
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 58
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 1
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\last_minute_holiday_deals.cfm: line 88
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 229
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 216
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 172
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 58
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm: line 1
Called from \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\last_minute_holiday_deals.cfm: line 88
 
227 : 				ON tropicalsearch.dbo.HolidayPriceSource.ParentHolidayPriceID = tqf.BaseHolidayPriceID
228 : 				JOIN Property WITH (NOLOCK) ON Property.PropertyID = tqf.PropertyID
229 : 				where (tqf.depDay between datediff(d, '1 oct 06', '#form.startdate#') and datediff(d, '1 oct 06', '#form.enddate#') )
230 : 		AND	(PA_Rule.publish = 1) AND(PA_Rule.expiryDate > Getdate())AND(Property.publish = 1) and (available > 0)) as selection
231 : 		JOIN [tropical].dbo.village v ON selection.villageID = v.villageID
SQL    SELECT r.regionCode, c.countryCode, v.villageID, rtrim(r.name) RegionName, CASE WHEN rtrim(c.name) = 'Africa' THEN 'North Africa' ELSE rtrim(c.name) END AS CountryName, v.Name as villageName FROM (SELECT DISTINCT tqf.regionCode, tqf.countryCode, tqf.villageID FROM tropical.dbo.PA_Rules_RuleGroups JOIN tropical.dbo.PA_Rule WITH (NOLOCK) ON PA_Rule.RuleID = PA_Rules_RuleGroups.RuleID JOIN tropicalsearch.dbo.HolidayPriceSource WITH (NOLOCK) ON PA_Rules_RuleGroups.RuleID = tropicalsearch.dbo.HolidayPriceSource.SourceProcessID JOIN TropicalSearch.dbo.tbl_qualifyingPrices4 tqf WITH (NOLOCK) ON tropicalsearch.dbo.HolidayPriceSource.ParentHolidayPriceID = tqf.BaseHolidayPriceID JOIN Property WITH (NOLOCK) ON Property.PropertyID = tqf.PropertyID where (tqf.depDay between datediff(d, '1 oct 06', '03 Sep 2010') and datediff(d, '1 oct 06', '17 Sep 2010') ) AND (PA_Rule.publish = 1) AND(PA_Rule.expiryDate > Getdate())AND(Property.publish = 1) and (available > 0)) as selection JOIN [tropical].dbo.village v ON selection.villageID = v.villageID JOIN [tropical].dbo.Region r ON r.RegionCode = selection.RegionCode JOIN [tropical].dbo.Country c ON c.CountryCode = selection.CountryCode
DATASOURCE   tropical
VENDORERRORCODE   468
SQLSTATE   HY000
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.191.91
Referrer  
Date/Time   03-Sep-10 07:59 AM
Stack Trace
at cfunified_getDrops2ecfm703417237._factor33(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:229) at cfunified_getDrops2ecfm703417237._factor35(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:216) at cfunified_getDrops2ecfm703417237._factor60(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:172) at cfunified_getDrops2ecfm703417237._factor61(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:58) at cfunified_getDrops2ecfm703417237.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:1) at cflast_minute_holiday_deals2ecfm85728989.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\last_minute_holiday_deals.cfm:88) at cfunified_getDrops2ecfm703417237._factor33(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:229) at cfunified_getDrops2ecfm703417237._factor35(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:216) at cfunified_getDrops2ecfm703417237._factor60(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:172) at cfunified_getDrops2ecfm703417237._factor61(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:58) at cfunified_getDrops2ecfm703417237.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:1) at cflast_minute_holiday_deals2ecfm85728989.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\last_minute_holiday_deals.cfm:88) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
	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 cfunified_getDrops2ecfm703417237._factor33(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:229)
	at cfunified_getDrops2ecfm703417237._factor35(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:216)
	at cfunified_getDrops2ecfm703417237._factor17(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm)
	at cfunified_getDrops2ecfm703417237._factor60(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:172)
	at cfunified_getDrops2ecfm703417237._factor61(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:58)
	at cfunified_getDrops2ecfm703417237.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\search\unified_getDrops.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cflast_minute_holiday_deals2ecfm85728989.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\last_minute_holiday_deals.cfm:88)
	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)