Error Too few parameteres expect 1

[wildt]

Works fine.

Recid = rs("id")
SQLstmt = "SELECT * FROM courses WHERE ID=" &
Request.QueryString("Recid")

When i combine two tables

SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name,
Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM
tblAuthor INNER JOIN Courses ON tblAuthor.employee_code =
Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid")

i get Too few parameteres expect 1
is it a syntax error?

 

[Aaron Bertrand - MVP]

i get Too few parameteres expect 1

is it a syntax error?

Tough to tell. SHow us what

response.write SQLstmt

yields...

 

[Ray at]

Do you have a querystring value for the "recid" key?

Ray at work

 

[jbongran]

Works fine.

Recid = rs("id")
SQLstmt = "SELECT * FROM courses WHERE ID=" &
Request.QueryString("Recid")

When i combine two tables

SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name,
Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM
tblAuthor INNER JOIN Courses ON tblAuthor.employee_code =
Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid")

i get Too few parameteres expect 1
is it a syntax error?

Is it a typo ?
WHERE Course.ID where it should be WHERE Courses.ID
Are you sure Recid is always populated ?
Do a
Response.Write "<b>SQLstmt :</b>" & SQLstmt & "<br>" & vbCrLf
Response.Flush