:: M.A.R.A.H ::

Assalamualaikum..


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][Oracle JDBC Driver][Oracle]ORA-00904: "C"."STATUS_APPLICANT": invalid identifier The error occurred in C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm: line 20 18 : select s.name,s.studentid,ca.semester,ca.code_college,ca.status, h.hc_desc 19 : from hep.college_applicant ca, uitm.student s, hep.hep_code h 20 : where s.studentid = '#session.user.studentid#' 21 : and s.studentid = ca.studentid 22 : and ca.studentid not in ('2007141703','2007141739','2007144763','2007106777','2006119311','2007210004', SQL select s.name,s.studentid,ca.semester,ca.code_college,ca.status, h.hc_desc from hep.college_applicant ca, uitm.student s, hep.hep_code h where s.studentid = '2007114001' and s.studentid = ca.studentid and ca.studentid not in ('2007141703','2007141739','2007144763','2007106777','2006119311','2007210004', '2007141723','2006119295','2007106597','2007144419','2006148219','2007141739','2007106533','2008293452', '2007106629','2008293462','2007106647','2008523941','2007141721','2006119315','2008560327','2007138063', '2007106831','2008319945','2008791247','2008768143','2007129927','2006146817','2008293458','2008272526', '2006120045','2007138199','2008720605','2008272546','2008226132','2007243006','2008571881','2007132175', '2008226192','2007288624','2007257364','2008291176','2008557587','2006126219','2007141701','2007252548', '2008343881','2008272562','2006120015','2008272582','2008715213','2006146803','2007141697','2006141573', '2006119097','2006146957','2007210032','2006119313','2008229498','2008794177','2007106545','2007106585') and ca.status = 'P' and c.status_applicant='' and ca.status = h.hc_code and ca.semester = (select cur_code from hep.current_config where cur_indicator = 'C') DATASOURCE conn_oracle_rac VENDORERRORCODE 904 SQLSTATE 42S22 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 Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11 Remote Address 203.82.79.104 Referrer http://isisweb53.uitm.edu.my/heponlinev2/index_menu_left.cfm Date/Time 01-Jul-09 11:41 AM Stack Trace at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20) at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "C"."STATUS_APPLICANT": invalid identifier at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.oracle.OracleImplStatement.execute(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.doEndTag(QueryTag.java:500) at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) 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)

Hmm..takde pape nak cerita sebenarnya, cuma marah sgt2..Dari kul 8.00pg tadi dok check result kolej..benda ni yg asyik keluar..aku mmg rase marah ni..kenapalah pihak berkuasa UiTM ni buat benda2 merepek cam ni..menyusahkan je aku rase..aaarrrggggghhhh..bengang aku cam ni..

ok..tu je aku nak bg tau..

jumpe lg nanti ek..

(^_^)