Command text and parameters

[fredb23]

Hello,

simple 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.

 

[pgferro]

According to Microsoft Knowledge Base

http://support.microsoft.com/default.aspx?scid=kb;en-us;216425

This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.