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\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 Jul 2009') and datediff(d, '1 oct 06', '17 Jul 2009') )
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 |
446 |
| SQLSTATE |
HY000 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.58 |
| Referrer |
|
| Date/Time |
03-Jul-09 11:08 PM |
|