sql stored procedures

[SeanKenney]

What I would like to know is how to pass VBScript variables to a sql stored procedure. As an example:

<% 
dim Name
Name = Request.Form(&quot;Name&quot;)
strSQL = &quot;exec my_proc(&quot; & Name & &quot;)&quot;

Conn.Execute(strSQL)
%>

Is this code right? Please help!

 

[TomSark]

You need to set up a COMMAND object, and append parameters to it, then execute the command object...

I'm mixing VB and VBScript here, but I speak VB and know you are doing ASP...

So, to illustrate:

Dim cmd

cmd = Server.CreateObject(ADODB.Command)

With cmd
.ActiveConnection = conn
.CommandType = adCmdStoredProc
.CommandText = "my_proc"
End With

cmd.Parameters.Append cmd.CreateParameter("Name", adVarChar, adParamInput, 30, Name)

cmd.Execute

Tom

 

[sharonc]

I use a very handy add-in to setup my stored procedures. I found it at the SQL Server Magazine Online

Http://www.sqlmag.com/articles/print.cfm?articleID=7402

The file you download is 7402.zip