53
[U]employee.cfm[/u]
Expand|Select|Wrap|Line Numbers
- <html>
- <head>
- <title>Employee List</title>
- </head>
- <body>
- <h1>Employee List</h1>
- <cfquery name="EmpList" datasource="cfdocexamples">
- SELECT FirstName, LastName, Salary, Contract
- FROM Employee
- </cfquery>
- <cfoutput query="EmpList">
- #EmpList.FirstName#, #EmpList.LastName#, #EmpList.Salary#,
- #EmpList.Contract#<br>
- </cfoutput>
- </body>
- </html>
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Employee'. Make sure it exists and that its name is spelled correctly.
The error occurred in C:\CFusionMX\wwwroot\jesmi\employee.cfm: line 7
Expand|Select|Wrap|Line Numbers
- 5 : <body>
- 6 : <h1>Employee List</h1>
- 7 : <cfquery name="EmpList" datasource="cfdocexamples">
- 8 : SELECT FirstName, LastName, Salary, Contract
- 9 : FROM Employee
--------------------------------------------------------------------------------
SQL SELECT FirstName, LastName, Salary, Contract FROM Employee
DATASOURCE cfdocexamples
VENDORERRORCODE -1305
SQLSTATE 42S02
Please try the following:
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/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address 127.0.0.1
Referrer
Date/Time 28-Apr-07 03:53 AM
Stack Trace (click to expand)
at cfemployee2ecfm1881328053.runPage(C:\CFusionMX\www root\jesmi\employee.cfm:7) at cfemployee2ecfm1881328053.runPage(C:\CFusionMX\www root\jesmi\employee.cfm:7)
Expand|Select|Wrap|Line Numbers
- java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Employee'. Make sure it exists and that its name is spelled correctly.
- at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
- at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
- at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
- at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
- at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
- at macromedia.sequelink.ssp.Chain.send(Unknown Source)
- at macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
- at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source)
- at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source)
- at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source)
- at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
- at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
- at coldfusion.sql.Executive.executeQuery(Executive.java:974)
- at coldfusion.sql.Executive.executeQuery(Executive.java:886)
- at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
- at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
- at cfemployee2ecfm1881328053.runPage(C:\CFusionMX\wwwroot\jesmi\employee.cfm:7)
- at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
- at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
- at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
- at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
- at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
- at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
- at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
- at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
- at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
- at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
- at coldfusion.CfmServlet.service(CfmServlet.java:105)
- at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
- at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
- at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
- at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
- at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
- at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
- at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
- at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
- at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
