my first cf page isnt working :(

charmed0rz · Jun 13, 2004

I dont know if I am coding it wrong.. or i am putting it in the wrong place or both

I am using the built in coldfusion server

so in the C:\CFusionMX\wwwroot i have a db folder with index.cfm and access.mbd

ok... now i am trying to get this code to work as my first page ever it should work when http://127.0.0.1:8500/db/index.html is opened right?

heres the code

<CFQUERY NAME="get_Access" DATASOURCE="db">
SELECT ID,
username,
password
FROM access
</CFQUERY>

<HTML>

<TITLE>I sure hope this works</TITLE>

<BODY BGCOLOR="green">

<B>Mystis Test Page</B>

This page is so see if it will list my username and password off the database.

<CFOUTPUT QUERY="get_Access">
Password: #password#

Username: #username#

</CFOUTPUT>

<FONT SIZE="-1">

This page was edited blah blah

</FONT>
</HTML>
</BODY>

I get this error:

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 'access'. Make sure it exists and that its name is spelled correctly.

Please try the following:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
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 13-Jun-04 05:43 PM

charmed0rz · Jun 13, 2004

Nevermind, got it

Log in or Sign up

my first cf page isnt working :(

charmed0rz Private E-2

charmed0rz Private E-2