Website MS Access SQL Query: Too few parameters error

[davestar_delux]

Hey I am trying to run this query that works fine in MS Access but when I try to run it from a web page using ColdFusion and ODBC drivers it is giving this error:

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Here is the code I am using:

<cfquery name="yourcourses" datasource="bigben">
SELECT courses.coursename, courses.credits, courses.signups
FROM users INNER JOIN (courses INNER JOIN usercourses ON courses.courseID = usercourses.courseid) ON users.username = usercourses.username
WHERE usercourses.username="#Session.username#";
</cfquery>

Anyone any ideas how to get this to work?

 

[punky_munky]

I haven't looked at Cold Fusion before but are you sure there aren't any parameters missing in this line?

<cfquery name="yourcourses" datasource="bigben">

 

[MagSafe]

Make sure the #Session.username# is getting passed over, i usually get that error if a variable is getting lost along the way.

 

[davestar_delux]

Sorry I got by this earlier, it was the double-quotes around #Session.username# that should have been single-quotes.