An Error Occurred
  • Your Location: 10.10.15.66
  • Your Browser: claudebot
  • Date and Time: 3/28/24 08:03:42
  • Page You Came From: http://web.har.com/edu/dispRealEstateSchoolsmap.cfm?schoolID=52
  • Page Occurred: /edu/dispRealEstateSchoolsmap.cfm
  • URL Query: schoolID=52
  • Error Description:
    Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'schoolID'.
    The error occurred on line 84.
A copy of this message was sent to the webmaster to resolve the problem.
Please check for following before contacting support
  • You are coming from a valid link.
  • You have not modified the URL.
  • You did not clear the browser's cookies during the browsing session.
  • You did not disabled the browser's cookie and/or javascript.

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]Invalid column name 'schoolID'.
 
The error occurred in C:/har/members/edu/dispRealEstateSchoolsMap.cfm: line 84
82 : 							(SIN(RADIANS(#inputLat#)) * SIN(RADIANS(a.LATITUDE)) + COS(RADIANS(#inputLat#))
83 : 							* COS(RADIANS(a.LATITUDE)) * COS(ABS(RADIANS(a.LONGITUDE) -
84 : 							RADIANS(#inputLong#))))) / PI()) * 180)) / 1.609344 < 10
85 : 		</cfif>
86 : 			order by

VENDORERRORCODE   207
SQLSTATE   42S22
SQL    SELECT distinct a.LONGITUDE, a.LATITUDE, a.streetNum + ' ' + Streetname address, a.CITY, a.state, a.zip zip_code, b.phone, b.schoolID, b.school_name campus_name, b.logo, d.campus_name_long, d.campusID FROM dbo.location a, dbo.class_schedule c, dbo.school_lookup b, dbo.campus_lookup d WHERE a.Longitude is not null and a.LID = c.LID and c.campusID = d.campusID and d.schoolID = b.schoolID and c.status = 'O' and c.start_date >= getdate() and (c.custom_address is null or c.custom_address = '') and a.status = 1 and b.status = 1 and b.association_id = 1 and a.schoolID = '52' order by a.LONGITUDE, a.LATITUDE
DATASOURCE   edudb
Resources:

Browser   claudebot
Remote Address   10.10.15.66
Referrer   http://web.har.com/edu/dispRealEstateSchoolsmap.cfm?schoolID=52
Date/Time   28-Mar-24 08:28 AM
Stack Trace
at cfdispRealEstateSchoolsMap2ecfm2013002407.runPage(C:/har/members/edu/dispRealEstateSchoolsMap.cfm:84) at cfdispRealEstateSchoolsMap2ecfm2013002407.runPage(C:/har/members/edu/dispRealEstateSchoolsMap.cfm:84)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'schoolID'.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfdispRealEstateSchoolsMap2ecfm2013002407.runPage(C:\har\members\edu\dispRealEstateSchoolsMap.cfm:84)
	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.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	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:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:201)
	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)