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 \\ocean\html\myrtlebeachgolfhotels_com\Application.cfm: line 60
 
58 : 
59 : 	<cfquery name="getSpecialsRotator" datasource="#dsn#">
60 : 		select rotationCount from featuredPackagesRotation <cfif url.accomid neq 0>where accomId = #Trim(url.accomid)#<cfelse> where (accomid=#getFeaturedAccomodation.accomId#)</cfif> and
61 : 		(website='oceanresortsgolf.com')
62 : 	</cfquery>
VENDORERRORCODE   102
SQLSTATE   HY000
SQL    select rotationCount from featuredPackagesRotation where (accomid=) and (website='oceanresortsgolf.com')
DATASOURCE   oceanResorts
Resources:

Browser   ColdFusion
Remote Address   66.153.188.182
Referrer  
Date/Time   07-Sep-10 08:58 PM
Stack Trace
at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60) at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.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.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
	at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:261)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)
	at coldfusion.CfmServlet.service(CfmServlet.java:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

   Compass Cove

-Custom Daily Golf Design your own package-
Custom designed to meet your needs. Includes daily breakfast. Choose from over 100 courses.
Valid Dates: 12/15/06 - 12/31/10
Arrival Days: Any Day
Length of Stay: 1 nights minimum -- 14 nights maximum
2311 South Ocean Boulevard
Myrtle Beach, SC  29577

View More Images
map it |  driving directions  | website 		Rates from (USD): $39.00
 AAA rating
Conveniently located near the center of Myrtle Beach, the famous Compass Cove Oceanfront Resort has been entertaining Grand Strand visitors for generations. With over 530 luxurious units including one, two & three bedroom condominiums and 720 feet of oceanfront beach, Compass Cove is one of the area’s largest resort hotels and offers a wide array of guest pleasing amenities. Highlighting these amenities are 22 pool features including 6 indoor and outdoor pools, 3 indoor and outdoor Lazy Rivers, Jacuzzi hot tubs and kiddie pools – truly a water wonderland! The staff is committed to giving you an unforgettable vacation experience and can design a vacation package for every budget. Browse through our website for complete details or call us toll free today.
Rooms: 537    Floors: 15
Check-in: 3:00 PM   Check-out: 11:00 AM
What to expect: Fully equipped for pleasing children, the resort attracts families with its casual atmosphere and multiple water attractions.

Amenity highlights: The resort's 21 water attractions include two outdoor complexes containing a 200-foot lazy river, four swimming pools, two children's pools, and two spa tubs. Two indoor complexes contain a 200-foot lazy river, two swimming pools, a children's pool, a toddlers' pool, and four spa tubs. An indoor/outdoor complex contains a 220-foot lazy river curling around a six-person spa tub and a children's pool. Sunning lawns line the 720-foot beach frontage.

Insider tip: A beach center one-half mile from the resort offers a variety of water sports, including personal watercraft and parasailing.

Services/Amenities:

 Coming in Spring 2010 – 2 new three story waterslide attractions!

  • Swimming pool - indoor
  • Swimming pool - children's
  • Bar/lounge
  • Parking (free)
  • Fax machine
  • 24-hour front desk
  • Laundry facilities
  • Elevator/lift
  • Swimming pool - outdoor
  • Fitness equipment
  • Restaurant(s) in hotel
  • Number of rooms: 537
  • ATM
  • Arcade/game room
  • Air-conditioned public areas

Rooms

Favorite Family Myrtle Beach Resort Conveniently located near the center, the famous Compass Cove Oceanfront Resort has been entertaining Grand Strand and Myrtle Beach resort and hotel visitors for generations. With over 530 well - appointed units including one, two & three bedroom condominiums and 720 feet of oceanfront beach, Compass Cove is one of the largest Myrtle Beach resort hotels and offers a wide array of guest pleasing amenities.

Highlighting these amenities are 22 pool features including 6 indoor and outdoor pools, 3 indoor and outdoor Lazy Rivers, Jacuzzi hot tubs and kiddie pools (including our newest pool - the Yellow Submarine Jungle Adventure wading pool for young kids) - Compass Cove is truly a water wonderland among Myrtle Beach Hotels! The staff is committed to giving you an unforgettable vacation experience and can design a vacation package for every budget
Dining

Compass Rose - Located behind our main lobby in our Schooner Building, this casual restaurant has a wide variety of food on our daily buffet.

Crow’s Nest Lounge - located in our gorgeous Pinnacle building, it serves a wide variety of food for lunch and dinner.
Recreation
The wide, sandy beach and Atlantic surf invite swimming, boogie boarding, beachcombing, fishing (pier and deep-sea), boating, sandcastle-building, or simply soaking up the warm Southern sunshine. The resort’s own water park features a lazy river and other fun activities. More than 100 golf courses are within easy driving distance. The Myrtle Beach National South, West, and King’s North courses, designed by Arnold Palmer, are about 15 minutes from the resort.

The recreational activities listed below are available either on site or near the hotel; fees may apply.

  • Golfing
  • Sailing
  • Surfing/boogie boarding
  • Tennis
  • Volleyball
  • Fishing
  • Golf - driving range
  • Boating
  • Swimming
  • Running track/path
  • Bicycle rentals
  • Playground

Policies
Extra person charges may apply depending on hotel policy.
There are no room charges for children 16 and younger occupying the same room as their parents.
Rollaways and cribs may be available and should be requested at the time of booking; fees may apply.
Photo identification and credit card or cash deposit are required upon check-in for incidental charges.
All special requests are subject to availability upon check-in.

 

  • Check-in time is 3 PM
  • Check-out time is 11 AM
Property Images
Compass Cove
2311 South Ocean Boulevard
Myrtle Beach, SC  29577

View More Images
map it |  driving directions  | website 		Rates from (USD): $39.00
 AAA rating

Compass Cove Specials

1) * September Savings* - Rooms from $59 in September and october!
Book Now
2) **IMAX 3-D Experience** - 2 FREE tickets to the IMAX 3-D Theatre and up to a 25% discount!
Book Now
3) *20% Promotion* - Stay 3 nights or more and Save up to 20% off!!
Book Now
4) *25% Promotion* - Stay 5 nights or more and Save up to 25% off!!
Book Now
5) *AAA / AARP Members*  - bring your AAA or AARP card and receive a discount!
Book Now
6) *Bed and Breakfast* - Wake up to a bountiful breakfast each day of your stay!
Book Now
7) *Military/Veterans Benefits* - We support our servicemen and women!
Book Now
8) *Romantic Escapes* - Includes breakfast each morning, and champagne w/ souvenir glasses.
Book Now
9) *Sunday Super Saver* - Save BIG when you arrive on Sunday and stay at least 4 nights!
Book Now
10) *Winter Rates 2010 2011* - Come join us for the winter months!
Book Now
View All Specials

Compass Cove Golf Packages

1) -Barefoot 4 Play- - Barefoot Resort 4 Round Multi Play Package
Book Now
2) -Best of The Beach Foursome- - The Best of the Beach Foursome Package
Book Now
3) -Classic 3-Round Special- - Play 1 round at Black Bear or Burning Ridge, and 1 round at Indian Wells and Crown Park.
Book Now
4) -Classic 4-Round Special- - Play 1 round each at Black Bear, Burning Ridge, Crown Park, and Indian Wells.
Book Now
5) -Classic Multi-Round 2 Play- - Classic Group 2 Play - Black Bear, Burning Ridge, Indian Wells or Founders Club of Pawleys Island.
Book Now
6) -Custom Daily Golf Design your own package- - Custom designed to meet your needs. Includes daily breakfast. Choose from over 100 courses.
Book Now
7) -Glens 3-Play- - Play 1 round each at Heather Glen, Shaftesbury Glen, and Possum Trot.
Book Now
8) -Grande Collection 2 Play- - The Grande Collection 2 Play Multi Course Discount
Book Now
9) -Grande Collection 3-Round Special- - Play 1 round at Tidewater or Grande Dunes, and 1 round at each Farmstead and Myrtlewood.
Book Now
10) -Grande Collection Big 2- - The Grande Collection "Big 2" Must Play Tidewater and Grande Dunes.
Book Now
11) -Legends 4 Play- - Based on 4nts. stay. Includes Heathland, Heritage, Moorland, Parkland, and Oyster Bay.
Book Now
12) -Mystical 2 Play- - Play the Mystical Collection Choose Witch, Wizard, or Man O'War.
Book Now
13) -Mystical Golf- - Stay 3 nights, Play 3 Rounds at Witch, Wizard, and Man O' War, recieve additional savings.
Book Now
14) -Ultimate Golf Insider Package- - Ultimate Golf Insider Package
Book Now
15) -Where Cat's Come To Life 2 Play- - Cat's Courses Multi-Play choose Lion's Paw, Tiger's Eye, Leopard's Chase, or Panther's Run
Book Now
16) -Where Cats Come to Life 3-Play- - Play 1 round each at Lion's Paw, Panther's Run, and Tiger's Eye.
Book Now
17) -Where Cats Come to Life 4-Play- - Play 1 round each at Leopard's Chase, Lion's Paw, Panther's Run and Tiger's Eye.
Book Now
18) 50% Off Tee Times - Fall 2010  - Play before 8:00am & save big!!! Tee times from just $30 this fall - choose from 14 Award-Winning courses. Including TPC of Myrtle Beach, Wild Wing, Long Bay Club, Blackmoor and River Club.
Book Now
19) 7-Round Signature Package: Play 6, Get Your 7th FREE!  - Myrtle Beach's Best Week-Long Golf Value! Choose from 14 award-winning designs, including: King's North, TPC of Myrtle Beach & Long Bay Club.
Book Now
20) Barefoot Golf - Play 3 Rounds & Get 1 FREE! - Home of the famed Dye Club, Love Course, Fazio Course and Norman Course. Get 1 FREE round when you play 3 this fall at one of America's finest 72-hole properties.
Book Now
21) Grande Collection, 3-Round Special  - Choose from 9 of the most recognized golf courses in the area like Myrtlewood, Tidewater, Pine Lakes, Arcadian Shores and 4 others. Save up to $76 per golfer!
Book Now
22) Grande Collection, 4-Round Special - Beginning September 16, 2010 - Play 4 Grande Collection courses & save up to 25% per golfer! Choose from 9 of Myrtle Beach's best, including Grande Dunes, Pine Lakes & Tidewater.
Book Now
23) Legends Golf - Play 4 & Get 1 FREE! - Choose from 5 Legendary courses and save up to $33 per round. Including Heathland, Moorland, Parkland, Oyster Bay, and Heritage Club.
Book Now
24) Legends Golf, 3-Round Special  - Choose from 5 Legendary courses and save big when you play 3 rounds. Each golfer receives lunch, 2 beers and a $45 Pro Shop gift card!
Book Now
25) Player's Choice Package - ALL Myrtle Beach Area Courses Available! - You Pick The Courses, We Make It Happen! Rounds From Just $28 This Summer & $34 This Fall. SAVE BIG with weekday and afternoon rates.
Book Now
26) Prime Times - Play 2, Get 1 FREE This Fall! - Get a FREE round this Fall and SAVE up to $90 per golfer. Rates begin at just $54 for each round! This Fall 2010 special is valid today through 11/14/10.
Book Now
27) Prime Times - Play 3, Get 2 FREE This Fall! - Play 3 Prime Times Courses this fall and get 2 additional rounds for FREE. Courses include King's North, TPC of Myrtle Beach & Long Bay Club.
Book Now
28) Prime Times 20% off Fall Tee Times
Book Now
29) Prime Times Group - Play 4, Get 1 FREE - Myrtle Beach's most popular golf package. Choose 4 award-winning courses and your 5th round is FREE! Courses include Wild Wing, Blackmoor, River Club & 11 others.
Book Now
30) The Challenge Select Package - 6 Myrtle Beach landmark courses in one great golf package. Play at least 3 rounds and save up to 25% per round off the regular price. Lunch included with each round!
Book Now
31) The Glen's Group, FREE Replay Special - Play 3 or 4 rounds and receive FREE same-day replays at Shaftesbury Glen, Heather Glen, Glen Dornoch & Possum Trot.
Book Now
View All Golf Packages