ADO problem 1

[makys]

I use following code to access datebase through ADO:


.
.
.
Set command = Server.CreateObject("ADODB.Command&quot
.
.
.
Set prmName = command.CreateParameter("Name&quot
command.Parameters.Append prmName
prmEntryID.value = Request.Form("Name&quot
.
.
.

Response is: Parameter object is improperly defined.
Inconsistent or incomplete information was provided.

What is missing??

 

[Guru7777]

I think that you should find this helpful.

http://www.xefteri.com/articles/apr302002/default.aspx

Hope this helps.

 

[woja]

Although the documentation doesn't make it clear, it seems you must set the [tt]Direction[/tt] property of the [tt]Parameter[/tt] object (and, possibly, the [tt]Type[/tt] property).

This can be done in the [tt]CreateParameter[/tt] call:

   Set prmName = command.CreateParameter("Name", adVarChar, adParamInput)

Or afterwards:

   Set prmName = command.CreateParameter("Name")
   With prmName
      .Direction = adParamInput
      .Type = adVarChar
   End With

Hope this helps

(I assume the [tt]prmEntryID[/tt] in your post is just a typo).

________________________________________
Roger J Coult; Grimsby, UK
In the game of life the dice have an odd number of sides.