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 collation conflict for equal to operation.
 
The error occurred in \\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\cheap_tropical_holidays.cfm: line 61
59 : 				qf.[regioncode],qf.[countrycode],source.price		
60 : 		</cfquery> --->
61 : 		<cfquery name="QQ_discount" datasource="#request.dsn#" cachedafter="#request.cachedAfter#">
62 : 			SELECT r.name as region, dateadd(day, qf.depDay, '01-Oct-2006') depDate, source.price, source.priceWas, source.holidayPriceID
63 : 			FROM 

SQL    SELECT r.name as region, dateadd(day, qf.depDay, '01-Oct-2006') depDate, source.price, source.priceWas, source.holidayPriceID FROM [tropicalSearch].[dbo].[tbl_qualifyingPrices4] qf JOIN [tropicalSearch].[dbo].[holidayPriceSource] source ON source.parentHolidayPriceID = qf.baseHolidayPriceID JOIN tropical..country c ON c.countryCode = qf.countryCode JOIN tropical..region r ON r.regionCode = qf.regionCode JOIN ( SELECT top 20 max(source_1.[PriceWas]-source_1.[Price]) difference, [regioncode], [countrycode] FROM [tropicalSearch].[dbo].[tbl_qualifyingPrices4] qf_1 JOIN [tropicalSearch].[dbo].[holidayPriceSource] source_1 ON source_1.parentHolidayPriceID = qf_1.baseHolidayPriceID WHERE source_1.sourceProcessID > 0 GROUP BY [regioncode],[countrycode] ORDER BY difference desc ) as topresults ON topResults.difference = source.[PriceWas]-source.[Price] AND topResults.regioncode = qf.regioncode AND topResults.countrycode = qf.countrycode WHERE source.sourceProcessID > 0 ORDER BY qf.[regioncode],qf.[countrycode],topResults.difference
DATASOURCE   tropical
VENDORERRORCODE   446
SQLSTATE   HY000
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.58
Referrer  
Date/Time   04-Jul-09 08:54 PM
Stack Trace
at cfcheap_tropical_holidays2ecfm2043735093.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\cheap_tropical_holidays.cfm:61) at cfcheap_tropical_holidays2ecfm2043735093.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\cheap_tropical_holidays.cfm:61)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot resolve collation conflict for 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.setupCachedQuery(QueryTag.java:695)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:492)
	at cfcheap_tropical_holidays2ecfm2043735093.runPage(\\itchynscratchy\websites-templates\public-websites\www.iglutropical.com\cheap_tropical_holidays.cfm:61)
	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.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)