Hi

In the book "Active Server Pages 3.0" page 586 in the example 
AccQueryParam.asp, it says that for parameters you would use the 
Command.CreateParameter("name", , , )etc. then append it, why can't you do 
(unless everything is done under the hood) like the following:

objcomd.Parameters("@customerID") = 90
objcomd.Parameters("@Phone") = Null
set objrst = objcomd.Execute

Thanks

Abraham

The code below is setting the values of parameters. It is not creating and
appending the parameter objects.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Abraham" <asryf@y...>
Subject: [asp_databases] output parameters


: In the book "Active Server Pages 3.0" page 586 in the example
: AccQueryParam.asp, it says that for parameters you would use the
: Command.CreateParameter("name", , , )etc. then append it, why can't you do
: (unless everything is done under the hood) like the following:
:
: objcomd.Parameters("@customerID") = 90
: objcomd.Parameters("@Phone") = Null
: set objrst = objcomd.Execute
:
: Thanks
:
: Abraham

Hi

Why do I need to create and append for, it works without that just as well?

Thanks

Abraham


> The code below is setting the values of parameters. It is not creating 
and
appending the parameter objects.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Abraham" <asryf@y...>
Subject: [asp_databases] output parameters


: In the book "Active Server Pages 3.0" page 586 in the example
: AccQueryParam.asp, it says that for parameters you would use the
: Command.CreateParameter("name", , , )etc. then append it, why can't you 
do
: (unless everything is done under the hood) like the following:
:
: objcomd.Parameters("@customerID") = 90
: objcomd.Parameters("@Phone") = Null
: set objrst = objcomd.Execute
:
: Thanks
:
: Abraham