execute store procedure from asp

[gojohnnygogogogo]

hello,
I currently run sql in asp like :


sql = "SELECT * FROM vCurrentandHistoryfinal WHERE (((ID) Like '"&id&"')) "


If cstr(Param) <> &quot;&quot; And cstr(Data) <> &quot;&quot; Then
sql = sql & &quot; And [&quot; & cstr(Param) & &quot;] = &quot; & cstr(Data)
End If
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot
rs.Open sql, conn, 3, 3


I have created a store procedure with id as the parameter, but don't know how to use sp's with asp.
coiuld somebody post an example of what I need to do ?


thank you for any help.

 

[MrGreed]

Take a look at this link:

http://www.asp101.com/articles/wrox/asp30/26100903.asp

&quot;did you just say Minkey?, yes that's what I said.&quot;

MrGreed