DSN Less code problem

[emax6]

I have the following code(in an asp page):

DIM objConn, SQL_query, rs1
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath ("/eshop/database/MajorDetail.mdb") & ";"
objConn.Open
SQL_query = "SELECT * FROM PRDDetail where PRDDetail='AA'"
RS1 = objConn.Execute(SQL_query)


When the code run, I get the following error in my browser:

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

What is wrong with this code?
thanks iin advance

 

[SatishPutcha]

The error occurs when a table's field name is incorrectly spelt or does not exist at all.

Check the query

"SELECT * FROM PRDDetail where PRDDetail='AA'"

Also check the recordset object while retrieving the rows.

Hope this helps.

Cheers,
Satish

 

[emax6]

Stupid me - I put the table name 2 time instead of table and row.
Thanks.