Too few parameters. Expected 1

[javediq143]

Hi all,
I got one more prob in another ASP page linked to the earlier one. I've created an Access DB and created a query using Access Query wizard. The query is running fine in Access and it is showing me the right Record each time. But when I'm taking this query in ASP page it is giving me this Err:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/imagine/ShowJobDetailTe st.asp, line 36

Dont know whats the prob over here also.
Anyone could plz help me. I know the mistake is in my ASP codes. So plz help me out to find the cause for it.

Thanks in Advance,
Javed.

<%
    Dim objDbConn
    Set objDbConn = Server.CreateObject("ADODB.Connection")
    objDbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=F:\Imagineer\html\career.mdb"
    objDbConn.Open
    %>
 
    <%
    Dim strSQL, objRS    
 
    strSQL = "SELECT JobDetail.Job_Ref, JobDetail.Job_Descrip, " & _
    "JobDetail.Job_Skills, JobDetail.Add_Info, JobTitle.Job_Title " & _
    "FROM JobTitle INNER JOIN JobDetail ON " & _
    "JobTitle.Job_Ref = JobDetail.Job_Ref WHERE " & _
    "(((JobDetail.Job_Ref)=(Select Job_Ref from JobTitle where Job_Ref = ""CFC0031"")))"
 
    Set objRS = Server.CreateObject("ADODB.Recordset")
    objRS.open strSQL, objDbConn, adOpenForwardOnly, adLockReadOnly, adCmdText  (This is Line Num: 36)
    %>
 
 
    <%
        Response.write "Job Title: " & objRS.Fields("Job_Title") & "<BR>"
        Response.write "Job Reference: " & objRS.Fields("Job_Ref") & "<BR><BR>"
 
        Response.write "Job Description: " & objRS.Fields("Job_Descrip") & "<BR><BR>"
 
        Response.write "Job Skills: " & objRS.Fields("Job_Skills") & "<BR><BR>"
 
        Response.write "Additional Information: " & objRS.Fields("Add_Info")
    %>
 
    <%
    objRS.Close
    Set objRS = Nothing
    %>

[ilearneditonline]

Hi all,
I got one more prob in another ASP page linked to the earlier one. I've created an Access DB and created a query using Access Query wizard. The query is running fine in Access and it is showing me the right Record each time. But when I'm taking this query in ASP page it is giving me this Err:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/imagine/ShowJobDetailTe st.asp, line 36

Dont know whats the prob over here also.
Anyone could plz help me. I know the mistake is in my ASP codes. So plz help me out to find the cause for it.

Thanks in Advance,
Javed.

Try this, i just cleaned up the SQL so that it was easier to look at.

 
"SELECT a.Job_Ref, a.Job_Descrip, " & _ 
"a.Job_Skills, a.Add_Info, b.Job_Title " & _ 
"FROM JobTitle b INNER JOIN JobDetail a ON " & _ 
"b.Job_Ref = a.Job_Ref WHERE " & _ 
"a.Job_Ref = (Select Job_Ref from JobTitle where Job_Ref = \"CFC0031\")"