Where am I going wrong ?

fredb23 · August 9th, 2004, 08:24 AM

Hello,

Simple code :

Code:

Set cmd1 = Server.CreateObject("ADODB.Command")
Set prm1 = cmd1.CreateParameter("[Lowest]", adInteger, adParamInput)
prm1.Value = 2
cmd1.Parameters.Append prm1
cmd1.ActiveConnection = statistiques_connexion_STRING
cmd1.CommandText = "Parameters [Lowest] Long;" & _
"SELECT * FROM Client WHERE Client.CLCLEUNIK=[Lowest]"
cmd1.CommandType = adCmdText
cmd1.Execute

I get "Error '80040e10' Too Few Parameters. Expected 1"

I can't workout what I'm doing wrong ...
Thanks for your time.

happygv · August 9th, 2004, 10:21 PM

What is the database you are using?

What is Parameters here, is that a stored procedure? If so, why do you append a select statement to it, for COMMANDobj.Text property?

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

fredb23 · August 10th, 2004, 03:41 AM

Hi,

I'm using an Access database.

This is not a stored procedure, the command text is an sql query and the command type is adCmdText.

Once I can make this simple code work the plan is to pass (from asp to access) some sql that will query a stored procedure instead of a table, hence the need to append parameters.

Thanks

happygv · August 10th, 2004, 04:56 AM

Then you might want to take a look at this link.

Parameterized Queries in Access

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection