i'm trying to retrieve values from the MS-access database into a asp field using sql query.

i'm giving the query as

strSQL ="SELECT add.* FROM add where add.prjname=pname;"

here the pname is the variable which store the value of the record to be retrieved in the database column named prjname.

i'm getting an error as

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/TestASP/FIT_ver03_030105/html/myplane_new.asp, line 29

here line 29 is: rsAddComments.Open strSQL, adoCon


Can Anybody solve and help.

You need to make sure that there is a valid value in pname, and that it is enclosed in single quotes e.g. 'Smith'

Unless you are joining tables, you do not need to specify the table name, so your SQL statement could read:

strSQL ="SELECT * FROM add where prjname='" & pname & "';"

It is probably also worth checking whether "add" is acceptable as a table name - it might be a reserved word.

Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk