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/ShowJobDetailTest.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.
Expand|Select|Wrap|Line Numbers
- <%
- 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
- %>