Too Few Parameters??

[JahShuWah]

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


this error occurs on this line:

objRS.Open strSQL objConn



anyone have any ideas as to why this is happening??

thanks in advance for any advice you can offer.

[doctorgonzo]

It would help to know exactly what you are trying to do. Could you post the full function where this line occurs?

[LoveJones]

Generically the error means that a function call you made did not have the desired parameters specified in the function declaration. Since it was expecting 1 argument, your function has no arguments. So look for a function or method that has empty parenthesis but should be passing an argument.

[chris1977uk]

i think if u change the line

objRS.Open strSQL objConn

to objRS.Open strSQL, objConn it will work

u need the comma so the code knows that the arguement after the sql is the connection string

:)