Hi, I am a beginner at Coldfusion (using Studio 4.0) and have a problem.
I have created my first database on MS Access and verified it on OBDC. I have written the following code to query it but receive a server error (161) message on my browser. Anyone have any idea why I'm getting this message? Thanks for looking anyway. (Hopefully it's something simple and dumb as I haven't been using CF long!)
Regards, Rob
Here is the code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFQUERY DATASOURCE="courses" NAME="sales" >
SELECT * FROM sales</cfquery>
<html>
<head>
<title>Sales Courses</title>
</head>
<body bgcolor="orange">
<h1> Sales Courses</h1>
<h2> We can offer the following courses at present</h2>
<CFOUTPUT QUERY="sales">
<P> Course Title: #title# </p>
<p> Course Number: #coursenumber#</p>
<p> Description: #description#</p>
<p> Duration: #duration#</p>
</cfoutput>
</body>
</html>
I have created my first database on MS Access and verified it on OBDC. I have written the following code to query it but receive a server error (161) message on my browser. Anyone have any idea why I'm getting this message? Thanks for looking anyway. (Hopefully it's something simple and dumb as I haven't been using CF long!)
Regards, Rob
Here is the code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFQUERY DATASOURCE="courses" NAME="sales" >
SELECT * FROM sales</cfquery>
<html>
<head>
<title>Sales Courses</title>
</head>
<body bgcolor="orange">
<h1> Sales Courses</h1>
<h2> We can offer the following courses at present</h2>
<CFOUTPUT QUERY="sales">
<P> Course Title: #title# </p>
<p> Course Number: #coursenumber#</p>
<p> Description: #description#</p>
<p> Duration: #duration#</p>
</cfoutput>
</body>
</html>
- does it work ?