Technical College System of Georgia
State Board Policies and
TCSG & STC Procedures Manual
July 1, 2016

Table of Contents

Southeastern Technical College adheres to the policies, procedures, and guidelines developed by the State Board of the Technical College System of Georgia (SBTCSG).
STC develops procedures to ensure specific methods are employed to express TCSG policies in day-to-day operations.
STC Procedures Revised to Align with TCSG Effective July 1, 2016

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]'val' is not a recognized built-in function name.

69 : 
70 : 
71 : <CFQUERY name="select_exhibit" datasource="#Session.DSN#">  
72 : SELECT Policy_Procedure_exhibit_New.PPE_id, Policy_Procedure_exhibit_New.PPE_level_01, Policy_Procedure_exhibit_New.PPE_level_02, 
73 : Policy_Procedure_exhibit_New.PPE_level_03, Policy_Procedure_exhibit_New.PPE_level_04, Policy_Procedure_exhibit_New.PPE_level_05,

SQLSTATE	HY000
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	SPIRIT_2024
VENDORERRORCODE	195
SQL	SELECT Policy_Procedure_exhibit_New.PPE_id, Policy_Procedure_exhibit_New.PPE_level_01, Policy_Procedure_exhibit_New.PPE_level_02, Policy_Procedure_exhibit_New.PPE_level_03, Policy_Procedure_exhibit_New.PPE_level_04, Policy_Procedure_exhibit_New.PPE_level_05, Policy_Procedure_exhibit_New.PPE_Type, Policy_Procedure_exhibit_New.PPE_Name, Policy_Procedure_exhibit_New.PPE_Content, Policy_Procedure_exhibit_New.PPE_Adopted, Policy_Procedure_exhibit_New.PPE_location, PPE_Level_01_New.PPE_Level_01_Roman, Policy_Procedure_exhibit_New.PPE_Direct FROM PPE_Level_01_New INNER JOIN Policy_Procedure_exhibit_New ON PPE_Level_01_New.PPE_Level_01 = Policy_Procedure_exhibit_New.PPE_level_01 order by Policy_Procedure_exhibit_New.PPE_level_01, iif([Policy_Procedure_exhibit_New.PPE_level_02] is null,0,val([Policy_Procedure_exhibit_New.PPE_level_02])), iif([Policy_Procedure_exhibit_New.PPE_level_03] is null,0,val([Policy_Procedure_exhibit_New.PPE_level_03])),iif([Policy_Procedure_exhibit_New.PPE_level_04] is null,0,val([Policy_Procedure_exhibit_New.PPE_level_04])), iif([Policy_Procedure_exhibit_New.PPE_level_05] is null,0,val([Policy_Procedure_exhibit_New.PPE_level_05])),Policy_Procedure_exhibit_New.PPE_location DESC, Policy_Procedure_exhibit_New.PPE_Type;

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	18.97.14.88
Referrer
Date/Time	29-Apr-25 07:25 PM

Stack Trace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]'val' is not a recognized built-in function name.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cftable_of_contents2ecfm300622628.runPage(C:\IE_Web_Site\web\Inetpub_Public\policy_guide_new\table_of_contents.cfm:71)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:446)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)