ASP in a Nutshell, 2nd Edition

Name

Execute (Command Object)

Synopsis

Set rsObj = cmdObj .Execute( RecordsAffected, _Parameters, Options)

(if the call to Execute returns records)

cmdObj.Execute( RecordsAffected, Parameters, Options)

(if the call to Execute does not return records)

Executes a query, SQL statement, or stored procedure. If it results in the creation of a recordset, that recordset can be immediately assigned to a Recordset object variable.

Parameters

rsObj

A Recordset object that you want initialized and set equal to the collection of records returned by the call to the Execute method.

cmdObj

The name of the Command object whose Execute method you are calling.

RecordsAffected

An optional Long variable that, when the method returns, indicates how many records were affected by the call.

Parameters

An array of variants containing parameters for the command to be executed. You should not put output parameters here, since they will not be returned properly.

Options

The Options parameter can be used to specify the type of command being executed or the Execute options desired.

The ADO constant values for the command type are the same as those for the Command.CommandType property:

adCmdUnspecified (-1)

This indicates that the CommandType property has not yet been specified.

adCmdText (1)

The command is a text command, such as a simple SQL statement; CommandText is evaluated as a textual definition of a command.

adCmdTable (2)

The Command object represents a table; CommandText is evaluated as the name of a ...