Calling a store procedure 1

[GDX]

I am sure this is an easy question for some of you guys but I was wondering how might I go about calling a store procedure from an ASP page?

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[jkb17]

I have the same issue right now; however, my problem deals with traversing the recordset object. I plan on reiterating through the recordset (i.e., movefirst to last and then first to last again). But if you plan on just using the recordset once (first to last) then the syntax is as follows:

'example below contains no input parameters
dim adConn
dim adCmd
dim adRS

set adConn = server.CreateObject("ADODB.Connection&quot
set adCmd = server.CreateObject("ADODB.Command&quot
set adRS = server.CreateObject("ADODB.Recordset&quot

'establish your connection (this is example using sql server)
with adConn
.ConnectionString _ = "Provider=SQLOLEDB;DataSource=ServerName;Initial _
Catalog=DatabaseName;User ID=username;PWD=password"
.Open
end with

'set up the command object information
with adcmd
.CommandText = "storedProcName"
.CommandType = adCmdStoredProc
.ActiveConnection = adConn
end with

'if you are expecting a Recordset to be returned then:
set adRS = adCmd.execute
'or
adRS.Open adCmd

'if you are not expecting a recordset then:
adCmd.execute

If there are parameters then the command object (adCmd) information will change. For example, using the same code above I will include an integer parameter named @id

'set up the command object information
with adcmd
.CommandText = "storedProcName"
.CommandType = adCmdStoredProc
.ActiveConnection = adConn
.Parameters.Append adCmd.CreateParameter( _
("@id",adInteger,adParamInput,,yourValue)
end with

good luck.

Jim